Computer Operator
Electronic Spreadsheet – Set 2
Dear ! This is Electronic Spreadsheet – Set 2 Quiz and it contains 50 questions.
1 / 50
1. You can open the highlight changes dialog box by choosing track changes from the menu
2 / 50
2. you want to set such that when you type Baishakh and drag the fill handle , excel should produce Jestha , Aashdh and soon . what will you set to affect that
3 / 50
3. By default the cell pointer moves down when you press Enter . From where can you change this setting ?
4 / 50
4. By default there are……….worksheets in an Excel file?
5 / 50
5. The Trace Dependence in auditing shows
6 / 50
6. The minimum and maximum value you can set for save AutoRecovery Info in Excel are
7 / 50
7. You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?
8 / 50
8. MS Excel provides the default value for step in fill series dialog box
9 / 50
9. While Finding and Replacing some data in Excel , which of the following statement is valid ?
10 / 50
10. How many recent files you can display on file menu at maximum ?
11 / 50
11. When you start typing the same value as of some cells on same column, Excel automatically shows that text, This feature is known as?
12 / 50
12. you can auto fit the width of column by
13 / 50
13. Which of the following cannot be hidden from Tools >> Options then View tab ?
14 / 50
14. Whats is the short cut key to replace a data with another in sheet?
15 / 50
15. Edit>> Delete command ?
16 / 50
16. Which of the following is invalid regarding the protection in Excel?
17 / 50
17. Paste Special allows some operation while you paste to new cell . which of the following operation is valid ?
18 / 50
18. When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next?
19 / 50
19. Which of the following option is not available to remove arrows of Formula Auditing
20 / 50
20. By default excel provides 3 worksheets. you need only two of them , how will you delete the third one ?
21 / 50
21. The Trace precedence in auditing shows
22 / 50
22. If you need to remove only the formatting done in a range (number and formula typed should not be removed) , you must
23 / 50
23. Which of the following is not an option in the spelling dialog box ?
24 / 50
24. We can make a cell address an absolute cell address by placing a sign in front of the row and column identifiers?
25 / 50
25. When a row of data is to be converted into columns
26 / 50
26. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
27 / 50
27. The……..in Excel 2007 replaces the menus and toolbars found in earlier versions of Excel?
28 / 50
28. The command edit >> Fill Across Worksheet is active only when
29 / 50
29. What happens when you press Ctrl + x after selecting some cells in Excel ?
30 / 50
30. Excel is a good application for what IF analysis. Which of the following tool help you for this?
31 / 50
31. Which of the following is not true about Find and Replace in Excel
32 / 50
32. Which of the following is tool you will use in Excel to see what must be the value of a cell to get required result ?
33 / 50
33. To apply Goal Seek command your cell pointer must be in
34 / 50
34. It is acceptable to let long text flow into adjacent cells on a worksheet when
35 / 50
35. Each file in a MS Excel is known as?
36 / 50
36. What happens if you remove the check mark from Row and Column headers on options dialog box ?
37 / 50
37. The default font size in Excel worksheet is
38 / 50
38. Which of the following is not What IF analysis tool in Excel?
39 / 50
39. Which tool you will use to join some cells and place the content at the middle of joined cell ?
40 / 50
40. The default font size in Excel worksheet is?
41 / 50
41. Which of the following action removes a sheet from worksheet ?
42 / 50
42. To remove the content of selected cells you must issue ——— command .
43 / 50
43. You can move a sheet from one workbook into new book by
44 / 50
44. you can quickly change the appearance of your work by choosing Auto Format from the …….. Menu
45 / 50
45. Paste special allows some operation while you paste to new cell. Which of the following operation is valid?
46 / 50
46. To protect a worksheet , you can choose protection and the protect sheet from the menu
47 / 50
47. The arrows create by Auditing can be removed by
48 / 50
48. Which of the following you can paste selectively using Paste Special command?
49 / 50
49. The default and maximum number of sheets for a new worksheet in Excel 2003 is
50 / 50
50. The default font used in Excel is?
Your score is
Restart quiz Exit
You cannot copy content of this page
