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