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