1. What symbol is used before a number to make it a label?
Correct : B. = (equal)
2. Which symbol must all formula begin with?
Correct : A. =
3. Which of the following formulas is not entered correctly?
Correct : D. 10+50
4. Which of the following formulas will Excel Not be able to calculate?
Correct : A. =SUM(Sales)-A3
5. A typical worksheet has …. Number of columns
Correct : B. 256
6. How many characters can be typed in a single cell in Excel?
Correct : D. 65535
7. A worksheet can have a maximum of …. Number of rows
Correct : D. 65535
8. Which of the following is not an example of a value?
Correct : D. Serial Number 50771
9. The chart wizard term data series refers to
Correct : B. A collection of chart data markers
10. The Chart wizard term data categories refers to;
Correct : B. A horizontal axis
11. A worksheet range is a
Correct : C. A group of cells
12. Getting data from a cell located in a different sheet is called
Correct : B. Referencing
13. Tab scrolling button
Correct : D. Allow you to view additional sheets tabs
14. A numeric value can be treated as a label value if it precedes with
Correct : A. Apostrophe (&lsquo
15. Concatenation of text can be done using
Correct : D. Ampersand (&)
16. Data can be arranged in a worksheet in a easy to understand manner using
Correct : D. all of above
17. 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
18. The auto calculate feature
Correct : B. Provides a quick way to view the result of an arithmetic operation on a range of cells
19. Excel uniquely identifies cells within a worksheet with a cell name
Correct : C. Column letters and row numbers
20. You can zoom a worksheet
Correct : D. All of the above
21. You can not link Excel worksheet data to a Word document
Correct : D. With the copy and paste buttons on the standard toolbar
22. This type of software is similar to an accountant’s worksheet
Correct : C. Spreadsheets
23. which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
Correct : D. All of the above
24. 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
25. When you group worksheets
Correct : D. b, and c
26. You can use the format painter multiple times before you turn it off by
Correct : B. Double clicking the format painter button
27. The default header for a worksheet is
Correct : C. None
28. To drag a selected range of data to another worksheet in the same workbook, use the
Correct : B. Alt key
29. When creating a vertical page break
Correct : C. The active cell must be in row 1
30. to activate the previous cell in a pre-selected range, press
Correct : D. none of above
31. When the formula bar is activated, you can see
Correct : D. All of above
32. In a worksheet you can press Shift+Space to select entire
Correct : D. a, b, and c
33. when you print preview a worksheet
Correct : D. a, b and c
34. You can group noncontiguous worksheets with
Correct : C. The ctrl key and mouse
35. Weight refers to
Correct : A. The print density of characters
36. When you link data maintained in Excel workbook to a Word document
Correct : B. The Word document contains a reference to the original source application
37. When you see a cell with a red triangle in the top right corner, what does this signify?
Correct : B. There is a comment associated with the cell
38. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
Correct : B. Freeze panes command on the window menu
39. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
Correct : C. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
40. To edit data in an embedded Excel worksheet object in a Word document
Correct : A. Use the Excel menu bar and toolbars inside the word application
41. Status indicators are located on the
Correct : C. Formula bar
42. You can open the scenario Manager dialog box by choosing scenarios from the ….. menu.
Correct : D. Tools
43. You can open the Sort dialog box by choosing Sort from the ….. menu
Correct : D. Data
44. when working in the page break preview, you can
Correct : D. all of above
45. A data map is helpful
Correct : B. To show a geographic distribution of data
46. Rounding errors can occur
Correct : A. When you use multiplication, division or exponentiation in a formula
47. You can copy data or formulas
Correct : D. All of the above
48. You can activate a cell by
Correct : D. All of above
49. Which of the following setup options can not be set in the page setup dialog box?
Correct : A. Printer selection
50. What term refers to a specific set of values saved with the workbook?
Correct : B. Scenario
51. Got functions? No? You need the insert function dialog box. How do you get it?
Correct : B. Click the insert menu and then click function
52. Which of the following describes how to select all the cells in a single column?
Correct : C. Left click on the gray column title button
53. when you use the fill effects in the format data series dialog box, you can not
Correct : A. rotate text on the chart
54. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
Correct : C. Speed
55. Which of the following is not a basic step in creating a worksheet?
Correct : D. Copy the worksheet
56. What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
Correct : A. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
57. To insert three columns between columns D and E you would
Correct : C. Select columns E, F and G
58. To center worksheet titles across a range of cell, you must
Correct : C. Select the cells containing the title text and use the fill handle to center the text across a range of cells
59. When integrating Ms-Word and Excel, Word is usually the
Correct : C. Client
60. Charts tips can
Correct : D. b and c
61. The Name box
Correct : B. Appears t the left of the formula bar
62. How do you change column width to fit the contents?
Correct : B. Double click the boundary to the right of the column heading
63. when you work with large worksheets, you may need to
Correct : D. all of above
64. Hyperlinks cannot be
Correct : D. All can be hyperlinks
65. You can use the horizontal and vertical scroll bars to
Correct : B. View different rows and columns
66. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
Correct : A. Spreadsheet program
67. You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
Correct : D. Picture
68. What function displays row data in a column or column data in a row?
Correct : C. Transpose
69. When you insert an Excel file into a Word document, the data are
Correct : B. Placed in a word table
70. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
Correct : A. IF
71. Macros are “run” or executed from the ….. menu.
Correct : C. Tools
72. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
Correct : D. Data
73. Which types of charts can excel produce?
Correct : C. Bar charts, line graphs and pie charts
74. How are data organized in a spreadsheet?
Correct : C. Rows and columns
75. What does the VLOOKUP function do?
Correct : C. Finds related records
76. Gridlines
Correct : D. a, b and c
77. You can print only an embedded chart by
Correct : D. a and c
78. Which of the following is a correct order of precedence in a formula calculation?
Correct : D. None of above
79. A function inside another function is called a ….. function.
Correct : A. Nested
80. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
Correct : B. On the file menu, click print, and then click selection under print what
81. Youar German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?
Correct : B. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
82. Which function calculates your monthly mortage payment?
Correct : A. PMT (payments)
83. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
Correct : A. Point to speech on the tools menu, and then click show text to speech toolbar.
84. Which of the following methods can not be used to enter data in a cell?
Correct : C. Pressing the Esc key
85. Which of the following will not set text in selected cells to italics?
Correct : B. Using the Tools – Wizard – Web Form menu item
86. Which of the following methods cannot be used to edit the content of cell?
Correct : A. Pressing the Alt key
87. Which of the following is not an option in the spelling dialog box?
Correct : A. Edit
88. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
Correct : C. Format
89. To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu
Correct : C. Tools
90. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
Correct : D. Tools
91. Which of the following is not a worksheet design criterion?
Correct : C. Description
92. To copy cell contents using drag and drop, press the
Correct : D. None of above
93. If you press …., the cell accepts your typing as its contents.
Correct : A. Enter
94. The autofill feature
Correct : A. Extends a sequential series of data
95. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
Correct : D. F11
96. you can use the formula palette to
Correct : B. create and edit formulas containing functions
97. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed
Correct : C. Refresh Data
98. What is an expression that tells how the numbers in a determined set of cells are to be calculated?
Correct : A. Formula
99. “Qtr 1, Qtr 2, Qtr 3” is an example of a
Correct : C. Series
100. You can edit existing Excel data by pressing the