Computer Operator
Electronic Spreadsheet – Set 5
Dear ! This is Electronic Spreadsheet – Set 5 Quiz and it contains 50 questions.
1 / 50
1. Which key do you press to check spelling ?
2 / 50
2. A ———– is a grid with labeled columns and rows.
3 / 50
3. The active cell :
4 / 50
4. Which of the following formulas will Excel Not be able to calculate ?
5 / 50
5. Which of the following is not a term of MS Excel ?
6 / 50
6. Which function is used to calculate depreciation , rates of return , future values and loan payment amounts ?
7 / 50
7. Excel displays the current cell address in the ……….
8 / 50
8. You can check the conditions against_________when applying conditional formatting?
9 / 50
9. Which language is used to create macros in Excel ?
10 / 50
10. The spelling dialog box can be involved by choosing spelling from ———-menu
11 / 50
11. How many worksheets can workbook have ?
12 / 50
12. What is the short cut key to highlight the entire column ?
13 / 50
13. Formatting a cell in currency, you can specify?
14 / 50
14. What do you mean by a Workspace ?
15 / 50
15. How can set page Border in Excel from?
16 / 50
16. In a worksheet you can select ?
17 / 50
17. How do you wrap the next in a cell ?
18 / 50
18. To record a sequence of keystrokes and mouse actions to play back later we use:
19 / 50
19. We can save and protect the workbook by
20 / 50
20. What will be the output if you format the cell containing 5436.8 as ‘#,##,0.00’ ?
21 / 50
21. What do you call the chart that shows the proportions of how one or more data elements relate to another data element
22 / 50
22. When the formula bar is active, you can see?
23 / 50
23. Whic area in an excel window allows entering values and formulas?
24 / 50
24. To active the previous cell in a pre-selected range,press?
25 / 50
25. Which setting you must modify to print a worksheet using letterhead ?
26 / 50
26. Which of the following formulas is not entered correctly?
27 / 50
27. Which of the following format you can decide to apply or not in AutoFormat dialog box?
28 / 50
28. Which would you choose to create a bar diagram ?
29 / 50
29. Hyperlinks can be ?
30 / 50
30. Which of the following is an absolute cell reference ?
31 / 50
31. A worksheet range is a?
32 / 50
32. MS EXCEL is based on …………..?
33 / 50
33. What is entered by the function =today()?
34 / 50
34. To drag a selected range of data to another worksheet in the same workbook,use the?
35 / 50
35. Which symbol must all formula begin with?
36 / 50
36. Which function will you use to enter current time in a worksheet cell?
37 / 50
37. what does COUNTA () function do ?
38 / 50
38. To select an entire column in MS EXCEL , press ?
39 / 50
39. The auto calculate feature ?
40 / 50
40. The spelling tool is placed on_____toolbar?
41 / 50
41. What is the correct way to refer the cell A10 on sheet3 from sheet1 ?
42 / 50
42. In EXCEL , you can sum a large range of data by simply selecting a tool button called ……. ?
43 / 50
43. How can you remove borders applied in cells?
44 / 50
44. Excel uniquely identifies cells within a worksheet with a cell name?
45 / 50
45. To return the remainder after a number is divided by a divisor in EXCEL we use the function ?
46 / 50
46. Which button do you click to add up a series of numbers?
47 / 50
47. How do you display current date and time in MS Excel ?
48 / 50
48. Which chart can be created in Excel ?
49 / 50
49. In the formula , which symbol specifies the fixed columns or rows ?
50 / 50
50. Formatting a cell in Number foemat you can’t set?
Your score is
Restart quiz Exit
You cannot copy content of this page
