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