Computer Operator
Electronic Spreadsheet – Set 1
Dear ! This is Electronic Spreadsheet – Set 1 Quiz and it contains 50 questions.
1 / 50
1. Except for the ………. function , a formula with a logical function shows the word “TRUE” or “FALSE” as a result
2 / 50
2. Where can you change automatic or manual calculation mode in Excel?
3 / 50
3. The software which contain rows and columns is called ………..
4 / 50
4. Special category of number tab in Format cells dialog box can be used to apply format like
5 / 50
5. Which of the following option is not available in paste special dialog box?
6 / 50
6. How can you update the values of formula cells if Auto calculate mode of Excel is disabled?
7 / 50
7. Which of the following series type is not valid for fill series dialog box?
8 / 50
8. If you need a text to show vertically in a cell . how will you achieve this ?
9 / 50
9. Ctrl+D shortcut key in Excel will?
10 / 50
10. Which of the following Excel screen components can NOT be turned on or off?
11 / 50
11. Excel files have a default extension of
12 / 50
12. Which of the following is not an underline option in the format cells dialog box ?
13 / 50
13. Formula in Excel start with
14 / 50
14. Macros are “run” or executed from the ……..menu.
15 / 50
15. The default header for a worksheet is
16 / 50
16. Where can you set the shedding color for a range of cell in excel ?
17 / 50
17. Which function calculates your monthly mortage payment ?
18 / 50
18. You can use the formula palette to?
19 / 50
19. The shortcut key Ctrl+R is used in Excel to?
20 / 50
20. To drag a selected range of data to another worksheet in the same workbook, use the
21 / 50
21. you can automatically adjust the size of text in a cell if they do not fit in width by
22 / 50
22. To create a formula , you can use :
23 / 50
23. Gridlines
24 / 50
24. Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet in workbook?
25 / 50
25. An excel workbook is a collection of
26 / 50
26. Which of the following is not an option of the spelling dialog box ?
27 / 50
27. The cell reference for cell range of G2 to M12 is ………….
28 / 50
28. Long text can be broken down into many lines within a cell. You can do this through ?
29 / 50
29. You can merge the main document with data source in Excel. In mail merge operation, Word is usually?
30 / 50
30. Which of the cell pointer indicate that you can move the content to other cell?
31 / 50
31. Which of the cell pointer indicates you that you can make selection ?
32 / 50
32. you can group noncontiguous worksheets with
33 / 50
33. When all the number between 0 and 100 in a range should be displayed in Red Color , apply
34 / 50
34. A function inside another function is called a ………function
35 / 50
35. The name box on to the left of formula bar?
36 / 50
36. Merge cells option can be applied from
37 / 50
37. Which of the following is not the correct method of editing the cell content ?
38 / 50
38. When the formula bar is activated , you can see
39 / 50
39. Pre made sheet formats like sample , Classic and Accounting , Colorful etc can be applied from
40 / 50
40. Which function will you use to enter current time in a worksheet cell ?
41 / 50
41. can you set 0.5 inch left indentation for a cell in excel ?
42 / 50
42. Which of the following is invalid statement ?
43 / 50
43. Status indicators are located on the
44 / 50
44. To edit in an embedded excel worksheet object in a word document
45 / 50
45. Which of the following methods will not enter data in a cell ?
46 / 50
46. Which command will you choose to convert a column of data into row?
47 / 50
47. How are data organized in a spreadsheet ?
48 / 50
48. Tab scroll buttons are place on Excel screen?
49 / 50
49. you can open the consolidate dialog box by choosing consolidate from the ……. menu.
50 / 50
50. How can you show or hide the gridlibes in Excel Worksheet?
Your score is
Restart quiz Exit
You cannot copy content of this page
