Electronic Spreadsheet – Set 5

1) In a report , you need to show the monthly rainfall in Nepal . The best way to do this is to insert a

2) The first cell in EXCEL worksheet is labeled as

3) Total number of rows in Excel?

4) Give me an example of a cell address .

5) what are the tabs that appear at the bottom of each workbook called ?

6) ………denotes an interactive table that quickly summarises or cross tabulates, large amount of data?

7) Which of the following is not a valid data type in Excel?

8) Which of the following is not a valid Zoom percentage in Excel?

9) ………..function in excel calculates the average of the cells in a supplied range, that satisfy a given criteria ?

10) Which is an example of a formula ?

11) What is the symbol for dividing ?

12) Ms EXCEL can be used to automate

13) If you require more than two conditions or if you want to analyze a list using Excel 2003’s database functions , you must define which filter ?

14) ……facility helps to take single output of multiple sheets?

15) The function used to determine the maximum or minimum value of one cell by changing more than one cell is?

16) Which menu option can be used to split windows into two?

17) The……….function returns a prediction of a future value based on existing values provided ?

18) Which of the following is not a logical function ?

19) What happens when dollar signs($) are entered in a cell address ?

20) If you want to have a blank line after the title in a worksheet , what is the best thing for you to do ?

21) The box on the chart that contains the name of each individual record is called the ——–

22) When you use the fill effects in the format data series dialog box, you can not?

23) you want to report experiment information and create a chart that shows the rate of crystal growth over a period of time . the best application to use would be:

24) what is represented by the small , black square in the lower right corner of an active cell or range ?

25) NOT, AND, OR, and XOR are

26) In order to perform a calculation in a spreadsheet , you need to use a :

27) ……….key provides a chart immediately ?

28) The spelling tool is placed on_____toolbar?

29) What is the symbol for multiplying ?

30) Which keyword shortcut opens the Go to dialog box ?

31) First column in excel sheet is …….and column is…..?

32) Total number of columns in Excel?

33) The Cancel and Enter buttons appear in the :

34) B7:B9 indicates

35) In Excel, the AutoSum feature is available in?

36) If you want all of the white cats grouped together in the database , you need to sort by —–

37) ……………are used in excel to present information contained in worksheet in a graphic format?

38) In order to arrange the countries from those with the highest population to those with the lowest , you need to sort on the population field in ………..

39) How do you tell one cell from another

40) Chart in Excel is available in……..Tab?

41) Which is an example of function ?

42) You can active a cell by?

43) you are editing a worksheet that you had previously saved . if you want to save the edited sheet without losing the original one , which command should you use ?

44) …………is a quick and easy way to find and work with a subset of data in a excel sheet?

45) Where a row and a column meet , what do you call that ?

46) A quick way to return to a specific area of a worksheet is to type in the —–

47) Comments can be added to cells using……..?

48) Which of the following is not a database function in Excel?

49) you accidentally erased a record in the sheet . what command can be used to restore it immediately ?

50) Comments put in cells are called……?