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