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