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