Computer Operator
Electronic Spreadsheet – Set 3
Dear ! This is Electronic Spreadsheet – Set 3 Quiz and it contains 50 questions.
1 / 50
1. What is the keyword shortcut(button or buttons to be pressed ) for creating a chart from the selected cells
2 / 50
2. In Excel financial function, NPER is?
3 / 50
3. The cell reference for a range of cells that starts cell B1 and goes over to column G and down to row 10 is …..
4 / 50
4. What term describes a background that appears as a grainy , non – smooth surface
5 / 50
5. What feature enables you to adjust or back solve the value in a cell to reach a desire outcome in a formula ?
6 / 50
6. Which of the following is not a logical function ?
7 / 50
7. ………function is used to calculate the amount paid as interest on a loan during a period of the lifetime of a loan or an investment ?
8 / 50
8. To create an interactive pivot Table for the Web , you use a Microsoft office web component called
9 / 50
9. Which of the following is not a statistical function in Excel?
10 / 50
10. ……….key provides a chart immediately ?
11 / 50
11. Red triangle at the top right corner of a cell indicates
12 / 50
12. How many sheets are there in excel workbook by default ?
13 / 50
13. Cell E23 has a data value and you wish to place that date on an invoice prefaced with the text located in B15 . what is the command to do that ?
14 / 50
14. If you press …… the cell accepts your typing as its contents
15 / 50
15. How do you rearrange the data in ascending or descending order ?
16 / 50
16. To select multiple non adjacent cells in a worksheet you will click them holding
17 / 50
17. The accounting style shows negative numbers in
18 / 50
18. Which of the following is not a database function in Excel?
19 / 50
19. First column in excel sheet is …….and column is…..?
20 / 50
20. What is an expression that tells how the number in a determined set of cells are to be calculated ?
21 / 50
21. Which of the following is not a worksheet design criterion
22 / 50
22. The……….function returns a prediction of a future value based on existing values provided ?
23 / 50
23. …………calculates the interest paid during a specific period of an investment ?
24 / 50
24. The number of row in a worksheet is
25 / 50
25. What pivot Table toolbar button updates the data in a pivot table or pivot chart report if the source data has changed ?
26 / 50
26. When a formatted number does not fit within a cell , it displays
27 / 50
27. When you create two or four separate windows containing part of the spreadsheet that can be viewed , you have created
28 / 50
28. ……facility helps to take single output of multiple sheets?
29 / 50
29. You can edit existing Excel data by pressing the
30 / 50
30. Total number of columns in Excel?
31 / 50
31. Total number of rows in Excel?
32 / 50
32. To copy all content using drag and drop , press the
33 / 50
33. Which of the following is concatenating operator ?
34 / 50
34. Data can be arranged in ascending or descending order by using
35 / 50
35. What symbol is used to enter number as text ?
36 / 50
36. “Qtr 1, Qtr 2 , Qtr 3” is an example of a
37 / 50
37. Which of the following component displays the content of active cell ?
38 / 50
38. The process of identifying specific rows and columns so that certain columns are always visible on the screen is called
39 / 50
39. In Excel, the AutoSum feature is available in?
40 / 50
40. The function used to determine the maximum or minimum value of one cell by changing more than one cell is?
41 / 50
41. In Excel financial function, PMT means?
42 / 50
42. To keep specific rows and columns from scrolling off the screen you first must position the cell pointer
43 / 50
43. If you wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest) , which of the following would be the correct order of the list
44 / 50
44. A user wishes to remove a spreadsheet from a workbook. which is the correct sequence of events that will do this ?
45 / 50
45. A……….in Excel offers you different ways to view a set of figures, and allows you to switch between them quite easily ?
46 / 50
46. …………In Excel is used to get a particular result when you’re not too sure of the starting value?
47 / 50
47. The auto fill features
48 / 50
48. ………..function in excel calculates the average of the cells in a supplied range, that satisfy a given criteria ?
49 / 50
49. To move to the previous worksheet press
50 / 50
50. ………denotes an interactive table that quickly summarises or cross tabulates, large amount of data?
Your score is
Restart quiz Exit
You cannot copy content of this page
