2. In Excel which of the following is not an option in the spelling dialog box
Correct : A. Edit
3. Excel uses the …. Function when creating a data table
Correct : D. Table
4. In Excel you can copy cell formats from one cell to another by using the
Correct : C. Format painter
5. In Excel accounting style shows negative numbers in
Correct : C. Parentheses
6. In Excel you can use drag and drop to embed excel worksheet data in a word document
Correct : D. (A) and (C)
7. In Excel the chart wizard
Correct : B. Can only place a chart on new chart sheet
8. In Excel which functions will calculate the
number of workdays between 6/9/2004 and 8/12/2004
Correct : D. All of the above
9. In Excel data marker on a chart are linked to data points in a worksheet, therefore,
Correct : B. You can change the position of a data marker and automatically change the data point value in the worksheet
10. In Excel when you group worksheets
Correct : D. (B) and (C)
11. In Excel you can zoom a worksheet
Correct : D. All of the above
12. You cannot link Excel worksheet data to a Word document
Correct : D. With the copy and paste buttons on the standard toolbar
13. In Excel this type of software is similar to an
accountant’s worksheet
Correct : C. Spreadsheets
14. In Excel you can use the format painter multiple times before you turn it off by
Correct : B. Double clicking the format painter button
15. In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu
Correct : C. Format
16. In Excel….. is a group of cells that form a rectangle on the screen.
Correct : C. Range
17. In Excel following term describes explanatory text attached to a cell
Correct : B. Comment
18. In Excel the drag and drop method of copying or moving
Correct : C. Can be used between workbooks but not worksheets
19. In Excel 3-D reference in a formula
Correct : D. Spans worksheets
20. In Excel the auto calculate feature
Correct : B. Provides a quick way to view the results of an arithmetic operation on a range of cells
21. In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu
Correct : C. Tools
22. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
Correct : D. Tools
23. In Excel which of the following is not a worksheet design criterion
Correct : C. Description
24. In Excel to copy cell contents using drag and drop, press the
Correct : D. None of above
25. In Excel if you press …….., the cell accepts your typing as its contents.
Correct : A. Enter
26. In Excel the auto fill feature
Correct : D. None of above
27. In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cells
Correct : D. F11
28. In Excel you can use the formula palette to
Correct : B. Create and edit formulas containing functions
29. What excel feature can you use if you want to work with one record at a time?
Correct : C. Data Form
30. In Excel what chart object is horizontal or
vertical line that extends across the plot area to make it easier to read and follow the values?
Correct : D. Gridline
31. In Excel value used in a formula that does not change is called a
Correct : B. Constant
32. In Excel which elements of worksheet can be protected from accidental modification ?
Correct : D. All of above
33. In Excel you can use the drag and drop method to
Correct : D. (A) and (B)
34. In Excel it is acceptable ot let long text flow into adjacent cells on a worksheet when
Correct : B. No data will be entered in the adjacent cells
35. In Excel how can you delete a record?
Correct : B. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
36. Right clicking something in Excel
Correct : C. Opens a shortcut menu listing everything you can do to the object
37. In Excel Documentation should include
Correct : D. All of the above
38. Files created with Lotus 1-2-3 have an
extension
Correct : C. 123
39. In Excel to delete an embedded objects, first
Correct : D. Select it and then press the delete key
40. In Excel comments can be added to cells using
Correct : B. Insert > Comments
41. In Excel which of the following is not a worksheet design criterion?
Correct : C. Description
42. In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?
Correct : A. Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.
43. In Excel a fast way to add up this column of number is to click in the cell below the numbers and then
Correct : C. Click the autosum button on the standard toolbar, then press enter
44. In Excel which of the following is an absolute cell reference?
Correct : B. $A$1
45. In Excel what symbol is used before a number to make it a label?
Correct : B. = (equal)
46. In Excel which symbol must all formula begin
with?
Correct : A. =
47. In Excel which of the following formulas is not entered correctly?
Correct : D. 10+50
48. In Excel which of the following formulas will Excel not be able to calculate?
Correct : A. =SUM(Sales)-A3
49. In Excel typical worksheet has …. Number of columns
Correct : B. 256
50. In Excel how many characters can be typed in a single cell?
Correct : D. 65,535
51. In Excel worksheet can have a maximum of
…. Number of rows
Correct : D. 65,535
52. In Excel the following is not an example of a value
Correct : D. Serial Number 50771
53. In Excel chart wizard term data series refers to
Correct : B. A collection of chart data markers
54. In Excel Chart wizard term data categories refers to
Correct : B. A horizontal axis
55. In Excel worksheet range is a
Correct : C. A group of cells
56. In Excel getting data from a cell located in a
different sheet is called
Correct : B. Referencing
57. In Excel Tab scrolling button
Correct : D. Allow you to view additional sheets tabs
58. In Excel numeric value can be treated as a label value if it precedes with
Correct : A. Apostrophe (‘)
59. In Excel concatenation of text can be done using
Correct : D. Ampersand (&)
60. In Excel data can be arranged in a worksheet in a easy to understand manner using
Correct : D. All of above
61. In Excel you can use drag-and-drop to embed excel worksheet data in a word document
Correct : A. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
62. In Excel the auto calculate feature
Correct : B. Provides a quick way to view the result of an arithmetic operation on a range of cells
63. In Excel to view a cell comment
Correct : C. Position the mouse pointer over the cell
64. In Excel say that you want to paste a formula
result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?
Correct : C. Click the arrow on the paste button on the standard toolbar, then click values.
65. In Excel you can select a single range of cells by
Correct : D. Dragging over the desired cells
66. All formula in Excel start with
Correct : D. -
67. In Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?
Correct : A. & (ampersan(D)
68. In Excel two common wildcard characters that Excel recognizes are
Correct : A. * and ?
69. In Excel divide symbol is
Correct : A. /
70. In Excel to add two cells (A1 and A2) together you use the following formula
Correct : A. =A1 + A2
71. In Excel on an excel sheet the active cell in indicated by
Correct : A. A dark wide boarder
72. In Excel on an Excel sheet the active cell in
indicated by
Correct : A. A dark wide border
73. In Excel using the F11 shortcut key to create a chart on chart sheet creates
Correct : B. A 2-dimensional column chart
74. In Excel you can print
Correct : D. All of the above
75. In Excel you can create only a horizontal page break by first selecting
Correct : D. (A) and (C)
76. In Excel you can create hyperlinks from the Excel workbook to
Correct : D. All
77. In Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
Correct : D. B1:G10*
78. In Excel advantage of using a spreadsheet is
Correct : D. all of the above
79. In Excel intersection of a row and column is called :
Correct : C. A cell
80. There are three types of data found in a spreadsheet
Correct : D. numbers formulas, labels
81. In Excel to select a column the easiest
method is to
Correct : C. Click the column heading
82. In Excel if you press ……, the cell accepts your typing as its contents.
Correct : A. Enter
83. In Excel to view a cell comment
Correct : C. Position the mouse pointer over the cell
84. In Excel when you want to insert a blank imbedded excel object in a word document you can
Correct : A. Click the object command on the insert menu
85. In Excel to save a workbook, you
Correct : A. Click the save button on the standard toolbar from the menu
86. In Excel you can edit a cell by
Correct : B. Double clicking the cell to edit it in-place
87. In Excel to copy cell contents using drag and
drop press the
Correct : D. Esc key
88. In Excel when you copy a formula
Correct : B. Excel edits cell references in the newly copied formula
89. In Excel autofill feature
Correct : B. Automatically adds range of cell values
90. In Excel which menu option can be sued to split windows into two
Correct : C. Window > split
91. In Excel which of the following special function keys allow the content in cell
Correct : C. Return
92. In Excel which is not an advantage of using computerized spreadsheets?
Correct : D. Cost of initial setup
93. In Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Correct : B. Freeze panes command on the window menu
94. In Excel the following will not cut information
Correct : A. Pressing Ctrl + C
95. In Excel which of the following is not a way to complete a cell entry?
Correct : D. Pressing spacebar
96. In Excel you can activate a cell by
Correct : D. All of the above
97. In Excel Text formulas
Correct : C. Concatenate and manipulate text
98. In Excel how do you insert a row?
Correct : A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
99. In Excel the following is not a basic step in creating a worksheet
Correct : D. Copy the worksheet
100. In Excel how do you select an entire column?
Correct : A. Select Edit > Select > Column from the menu