Computer Operator
Electronic Spreadsheet – Set 6
Dear ! This is Electronic Spreadsheet – Set 6 Quiz and it contains 50 questions.
1 / 50
1. Which of the following is correct ?
2 / 50
2. What is the AutoComplete feature of Excel ?
3 / 50
3. What will be the result if you type = A1 = B1 in cell C1
4 / 50
4. Which of the following function will return a value of 8 ?
5 / 50
5. In Excel ———– may not contain in Formula
6 / 50
6. Which of the following is not a way to complete a cell entry?
7 / 50
7. Pre made sheet formats like Simple , Classic , Accounting; Colorful etc can be applied from
8 / 50
8. Text formulas?
9 / 50
9. Which one is the last column header in Excel 2007 ?
10 / 50
10. What is the shortcut key to hide entire column ?
11 / 50
11. How can you find specific information in a list?
12 / 50
12. you are editing an worksheet that you had previously save if you want to save the edited sheet without losing the original one , which command should you use ?
13 / 50
13. How to restrict the value of a cell so that only whole number between 9 and 99 can be entered in a cell
14 / 50
14. Which of the following syntax is correct regarding to SUM function in Excel ?
15 / 50
15. what does the Now() function return ?
16 / 50
16. you can use the formula palette to
17 / 50
17. How to specify cell range from A9 to A99 in Excel ?
18 / 50
18. Which of the following is not a basic step in creating a worksheet?
19 / 50
19. Selecting the Rows 5 & 6 then choose insert > Row what will happen ?
20 / 50
20. you want to record experiment information and create a chart that shows the rate of crystal growth over a period of time best application to use would be:
21 / 50
21. Which is not the function of “Edit, Clear” command ?
22 / 50
22. A numeric value can be treated as label value if ……. precedes it .
23 / 50
23. Microsoft Excel is a powerful ……………
24 / 50
24. What is the shortcut key to insert new sheet in current workbook ?
25 / 50
25. Which of the following is correct ?
26 / 50
26. What should be added before a fraction to avoid entering it as a date ?
27 / 50
27. To show/hide the grid lines in Microsoft Excel 2007
28 / 50
28. Worksheet can be renamed by
29 / 50
29. In maximum , how many sheets can be set as default while creating new workbook ?
30 / 50
30. “New Comment” option can be found under ——— tab
31 / 50
31. If the cell B1 contains the formula = $A$1, which of the following statements is true
32 / 50
32. When a label is too long to fit within a worksheet cell, you typically must?
33 / 50
33. Which option allows you to Bold all the negative values within the selected cell range
34 / 50
34. Which function is not available in the Consolidate dialog box ?
35 / 50
35. How to fit long texts in a single cell with multiple lines ?
36 / 50
36. Which of the following shortcuts can be used to insert a new line in the same cell ?
37 / 50
37. What is the shortcut key to insert current date in a cell ?
38 / 50
38. In Excel , by default Numeric values Appears in
39 / 50
39. Which of the following is correct syntax in Excel ?
40 / 50
40. A smart tag will be removed from a cell when
41 / 50
41. What is the shortcut key to hide entire row ?
42 / 50
42. What value will display if the formula = “$55.00″+5 is entered into a cell ?
43 / 50
43. you can merge the main document with data source in Excel . In mail merge operation , word is usually
44 / 50
44. Which of the following will not cut information ?
45 / 50
45. What is the quickest way to select entire worksheet ?
46 / 50
46. What is the shortcut key to insert a new comment in a cell ?
47 / 50
47. What pivot Table toolbar button updates the data in a pivot Table or pivot Chart report if the source data has changed ?
48 / 50
48. How to restrict to run a macro automatically when starting Microsoft Excel ?
49 / 50
49. Which of the following methods cannot be used to enter data in a cell ?
50 / 50
50. To create a formula, you first?
Your score is
Restart quiz Exit
You cannot copy content of this page
