Computer Operator
Electronic Spreadsheet – Set 7
Dear ! This is Electronic Spreadsheet – Set 7 Quiz and it contains 50 questions.
1 / 50
1. Which elements of worksheet can be protected accidental modification ?
2 / 50
2. The chart wizard term data categories refers to;
3 / 50
3. A typical worksheet has………Number of columns ?
4 / 50
4. Which of following is NOT one of Excel’s what if function ?
5 / 50
5. Tab scrolling button?
6 / 50
6. The chart wizard term data series refers to?
7 / 50
7. When you link data maintained in an excel workbook to a word document ?
8 / 50
8. You cannot link excel worksheet data to a word document ?
9 / 50
9. Multiple calculations can be made in a single formula using?
10 / 50
10. Each excel file is called a workbook because ?
11 / 50
11. The paste Special command let’s you copy and paste?
12 / 50
12. Getting data from a cell located in a different sheet is called?
13 / 50
13. Which of the following is not information you can specify using the solver?
14 / 50
14. You can use the format painter multiple times before you turn it off by?
15 / 50
15. Which of the following is a popular DOS based spreadsheet package ?
16 / 50
16. All worksheet formula?
17 / 50
17. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell,you?
18 / 50
18. A circular reference is?
19 / 50
19. A worksheet can have a maximum of……..Number of rows?
20 / 50
20. Which of the following is the oldest spreadsheet package ?
21 / 50
21. You can edit a cell by?
22 / 50
22. What symbol is used before a number to make it a label?
23 / 50
23. Which of the following methods cannot be used to edit the contents of a cell?
24 / 50
24. You can use the horizontal and vertical scroll bars to?
25 / 50
25. Right clicking something in Excel?
26 / 50
26. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
27 / 50
27. Concatenation of text cam be done using?
28 / 50
28. Rounding errors can occur?
29 / 50
29. You can use the drag and drop method to?
30 / 50
30. Which is used to perform what if analysis ?
31 / 50
31. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
32 / 50
32. Which of the following options is not located in the page setup dialog box?
33 / 50
33. A numerical value can be treated as a label value if it precedes with?
34 / 50
34. To view a cell comment ?
35 / 50
35. How many characters can be typed in a single cell Excel?
36 / 50
36. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the?
37 / 50
37. Which of the following is a correct order of precedence in formula calculation ?
38 / 50
38. When you copy a formula ?
39 / 50
39. To copy formatting from one area in a worksheet and apply it to another area you would use?
40 / 50
40. Which area in an excel window allows entering values and formulas?
41 / 50
41. When you insert an excel file into a word document. The data are?
42 / 50
42. Which of the following is the latest version of Excel?
43 / 50
43. You can enter which types of data into worksheets cells?
44 / 50
44. To save a workbook, you?
45 / 50
45. Excel worksheet cells work very similarly to what common element of the windows graphical user inrerface?
46 / 50
46. You can copy data or formulas?
47 / 50
47. Excel probably considers the cell entry january 1,2000 to be a ?
48 / 50
48. Files created with lotus 1 2 3 have an extension ?
49 / 50
49. The name box?
50 / 50
50. To copy cell contents using drag and drop press the?
Your score is
Restart quiz Exit
You cannot copy content of this page
