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