Identify the letter of the choice that best completes the statement or answers the question.
____ 1. Numbers can contain all of the following characters except __________.
a. + - ( ) c. 0 % E e
b. , / . $ d. & @ ! ~
____ 2. The small __________ at the corners and along the sides of the rectangle that encloses an embedded chart indicate
the chart is selected.
a. sizing handles c. move handles
b. fill handles d. marquee
____ 3. When Excel is installed on a computer, the default chart type is the 2-D (two-dimensional) __________.
a. Line chart c. Pie chart
b. Column chart d. Scatter chart
____ 4. Excel provides the Undo command on the __________ and the Undo button on the Standard toolbar that can be
used to erase the most recent worksheet entries.
a. Edit menu c. Tools menu
b. Insert menu d. Windows menu
____ 5. In Excel, a blank cell has __________.
a. no numerical value c. a numerical value of one
b. a numerical value of zero d. a numerical value of two
____ 6. If Range Finder is used to change cells referenced in a formula, press the __________ key to complete the edit.
a. INSERT c. ENTER
b. ESC d. END
____ 7. When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of
a. 8.43 characters, or 64 pixels c. 12.75 points, or 17 pixels
b. 64 characters, or 8.43 pixels d. 17 points, or 12.75 pixels
____ 8. If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks
a. only the text in the selected cell
b. the remainder of the worksheet, including notes and embedded charts
c. the spelling of all sheets in the workbook
d. the remainder of the worksheet, not including notes and embedded charts
____ 9. To save a workbook a second time using a new name or on a different drive, __________.
a. click Save on the File menu c. click Save As on the File menu
b. press SHIFT+F12 d. press CTRL+S
____ 10. To change the stock symbols Excel uses when refreshing the data in a Web query, click the __________ on the
External Data toolbar.
a. Data Range Properties button c. Refresh Status button
b. Query Parameters button d. Edit Query button
____ 11. To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and
a. click the Cancel box c. click the Name box
b. press the ESC key d. press the ENTER key
____ 12. If cells containing 780 and 760 are copied using the fill handle, the next three values of the extended series will be
a. 780, 760, 780 c. 680, 660, 580
b. 740, 720, 700 d. 775, 770, 765
____ 13. To copy formats to a range of cells, __________.
a. drag through the range to which the format should be pasted, click the Format Painter
button, and then select a cell with the desired format
b. drag through the range to which the format should be pasted, select a cell with the desired
format, and then click the Format Painter button
c. click the Format Painter button, drag through the range to which the format should be
pasted, and then select a cell with the desired format
d. select a cell with the desired format, click the Format Painter button, and then drag
through the range to which the format should be pasted
____ 14. If, in completing a paste, valuable data accidentally is deleted, immediately click the __________ on the Edit
menu to cancel the paste.
a. Paste Special command c. Clear command
b. Undo Paste command d. Redo Paste command
____ 15. To copy a selection, hold down the __________ key while dragging the selection to its new location.
a. SHIFT c. CTRL
b. ALT d. INSERT
____ 16. Valid format symbols that can be entered with a number include all of the following except the __________.
a. asterisk (*) c. dollar sign ($)
b. comma (,) d. percent sign (%)
____ 17. In an IF function, valid comparison operators (and their meaning) include all of the following except __________.
a. = (equal to) and <> (not equal to)
b. < (less than) and > (greater than)
c. >= (greater than or equal to) and <= (less than or equal to)
d. >< (less than or greater than) and ^ (outside of)
____ 18. The IF function =IF(B4>=$B$22, $B$18, 0) is assigned to cell B8. If the value in cell B4 is 6692019, the value in
cell B22 is 6,500,000.00, and the value in cell B18 is 60000, Excel displays __________ in cell B8.
a. 6692019 c. 6,500,000.00
b. 60000 d. 0
____ 19. When Excel initially draws a Pie chart, it always points one of the dividing lines between two slices to
a. twelve o’clock (or zero degrees)
b. three o’clock (or ninety degrees)
c. six o’clock (or one hundred-eighty degrees)
d. nine o’clock (or two hundred-seventy degrees)
____ 20. Different parts of a worksheet can be viewed through __________.
a. zoom boxes c. window panes
b. chart sheets d. toolbar docks
Indicate whether the sentence or statement is true or false.
____ 21. To start Excel, Windows must be running.
____ 22. A new workbook opens with three worksheets, but additional worksheets can be added up to a maximum of 255.
____ 23. To indicate whether commands will be spoken or cell entries dictated, use the Language bar.
____ 24. Numbers are left-aligned, which means the cell entry is positioned at the far left in the cell.
____ 25. When a font color is chosen, Excel changes the Font Color button on the Formatting toolbar to the chosen color.
____ 26. Most formats assigned to a cell will display on the Standard toolbar when the cell is selected.
____ 27. To use the AutoCalculate area, select the range of cells containing the numbers you want to check and then click
the AutoCalculate area to display the shortcut menu.
____ 28. A smart tag indicator is a block plus sign located in the center of the cell.
____ 29. The default row height in a blank worksheet is 12.75 points (or 17 pixels).
____ 30. To skip correcting a word identified by the spell checker, click the Ignore Once button in the Spelling dialog box.
____ 31. When a workbook is saved a second time using the same file name, Excel will display the Save As dialog box just
as it does the first time the workbook was saved.
____ 32. The tabs at the bottom of the worksheet window allow any sheet in the workbook to be displayed.
____ 33. Longer sheet names mean more tabs will display.
____ 34. The Increase Indent button indents the contents of a cell to the left by three spaces each time it is clicked.
____ 35. To copy a range of cells to a nonadjacent destination area, the fill handle can be used.
____ 36. When a copy is completed, the values and formats of the latest item placed on the Office Clipboard are replaced
with the values and formats in the destination area.
____ 37. The Paste Options button displays when the ENTER key is used to complete the paste operation.
____ 38. The Rows command on the Insert menu or the Insert command on the shortcut menu allows rows to be inserted
between rows that already contain data.
____ 39. In information processing, a report often is meaningless without a date stamp.
____ 40. Once a chart item is selected, it can be formatted using the Formatting toolbar, shortcut menu, or the Format
Complete each sentence or statement.
41. a cell is designated as the ___________ cell because data can be entered here currently.
42. You _________________________ a worksheet to emphasize certain entries and make the worksheet easier to
read and understand.
43. One of the reasons Excel is such a valuable tool is that a(n) _________________________ can be assigned to a
cell and Excel will calculate the result.
44. The _________________________ is a format that displays a dollar sign to the left of a number, inserts a comma
every three positions to the left of the decimal point, and displays numbers to the nearest cent (hundredths place).
45. When using conditional formatting, a(n) _________________________, which is made up of two values and a
relational operator, is true or false for each cell in a range.
46. A worksheet can be sent as part of a Word document by using the _________________________.
47. The Copy button places the contents and format of a selected range on the _________________________, which
allows up to 24 different items from any Office application to be collected.
48. When one item is on the Office Clipboard and then a second item is copied, Excel automatically displays the
_________________________ on the left side of the screen showing its contents.
49. When pointing to the border of a selected cell or range of cells, the mouse pointer changes to a(n)
50. Using the mouse to move or copy cells is called _________________________.
1. ANS: D REF: E 1.21
2. ANS: A REF: E 1.38
3. ANS: B REF: E 1.40
4. ANS: A REF: E 1.50
5. ANS: B REF: E 2.16
6. ANS: C REF: E 2.26
7. ANS: A REF: E 2.43
8. ANS: B REF: E 2.50
9. ANS: C REF: E 2.51
10. ANS: B REF: E 2.61
11. ANS: D REF: E 2.62
12. ANS: B REF: E 3.10
13. ANS: D REF: E 3.12
14. ANS: B REF: E 3.15
15. ANS: C REF: E 3.16
16. ANS: A REF: E 3.19
17. ANS: D REF: E 3.27
18. ANS: B REF: E 3.28
19. ANS: A REF: E 3.51
20. ANS: C REF: E 3.58
21. ANS: T REF: E 1.07
22. ANS: T REF: E 1.10
23. ANS: T REF: E 1.16
24. ANS: F REF: E 1.22
25. ANS: T REF: E 1.31
26. ANS: F REF: E 1.32
27. ANS: F REF: E 1.47
28. ANS: F REF: E 2.15
29. ANS: T REF: E 2.43
30. ANS: T REF: E 2.50
31. ANS: F REF: E 2.51
32. ANS: T REF: E 2.62
33. ANS: F REF: E 2.62
34. ANS: F REF: E 3.13
35. ANS: F REF: E 3.13
36. ANS: F REF: E 3.15
37. ANS: F REF: E 3.16
38. ANS: T REF: E 3.16
39. ANS: T REF: E 3.22
40. ANS: T REF: E 3.48
41. ANS: active REF: E 1.11
42. ANS: format REF: E 1.28
43. ANS: formula REF: E 2.09
44. ANS: Currency style format REF: E 2.34
45. ANS: condition REF: E 2.40
Mail Recipient command
REF: E 2.64
47. ANS: Office Clipboard REF: E 3.14
48. ANS: Clipboard task pane REF: E 3.14
49. ANS: block arrow REF: E 3.16
50. ANS: drag and drop REF: E 3.16