1. The title bar displays the name of the program, the program icon, and:
a. Menu names.
b. Toolbar buttons.
c. The Minimize, Restore Down/Maximize, and Close buttons.
d. The program's current status.

2. Task panes in Excel include Getting Started, Help, and:
a. Search Results.
b. Database Operations.
c. Printing.
d. Troubleshooting.

3. A menu item that displays a dialog box includes a(n):
a. Triangle.
b. Arrow.
c. Checkmark.
d. Ellipsis.

4. Excel allows you to create your own, customized toolbars.
a. True
b. False

5. Which function key is used to display the Help task pane?
a. F1
b. F3
c. F5
d. F7

6. Microsoft Access is a _______ program.
a. Word Processing
b. Database Management
c. Presentation
d. Spreadsheet

7. To open an existing workbook, click the Open button on the Standard toolbar.
a. True
b. False

8. The buttons on the Formula Bar are:
a. Cancel, Enter, and Go.
b. Add, Save, and Subtract.
c. Cancel, Enter, and Insert Function.
d. Edit, Cancel, and Activate .


9. Cut, Copy, and paste buttons are found on the _______ toolbar.
a. Formula
b. Formatting
c. Standard

10. To save a workbook with a different name or to different location, use the _______ _______ dialog box.
a. Save
b. Insert
c. Save As
d. Find

Chapter 3
Creating and Editing Workbooks

11. Use AutoComplete to quickly:
a. Add formatting to cells.
b. Delete items.
c. Enter previously entered text.
d. Create a new formula.

12. In Excel, formulas begin with:
a. An equal sign.
b. The word Sum.
c. A plus sign.

13. Functions are prewritten formulas that use values to perform an operation in a specific order.
a. True
b. False

14. _______ displays the sum of a range in the status bar.
a. Range Finder
b. AutoCalculate
c. MAX
d. AutoSum

15. To link formulas in two sheets, use the _______ command on the Edit menu.
a. Paste
b. Cut
c. Paste Special
d. Link

Chapter 4
Working with Functions

16. You can type a function or you can insert the function by clicking the:
a. Tools menu.
b. Name box.
c. Status bar.
d. Insert Function button.

17. If set to manual calculation, use the Calc Now button or press the _______ key on your keyboard to calculate the worksheet.
a. F1
b. F5
c. F9
d. F12

18. A financial function that calculates the total value at the end of a series of payments is the _______ function.
a. DATE
b. FV
c. AVERAGE
d. COUNT

19. To evaluate the formulas in your worksheet, use the:
a. Standard toolbar.
b. Formula Auditing toolbar.
c. Status bar.
d. Menu Bar.

20. The TODAY function will enter the current date into a cell.
a. True
b. False

Chapter 5
Formatting Workbooks

21. The _______ menu contains commands that control the way cells, columns, and rows appear.
a. Edit
b. Window
c. File
d. Format

22. Drag the double-headed arrow between _______ to resize columns and rows.
a. Columns and rows
b. Column headings and row headings
c. Columns, rows, or cells

23. Only text can be formatted using the buttons on the Formatting toolbar.
a. True
b. False

24. To check the spelling in a worksheet, click the Spelling button on the _______ toolbar.
a. Formatting
b. Standard
c. Drawing
d. Control Toolbox

25. AutoCorrect replaces the text you type with the replacement text when you:
a. Type the text and press the Enter key.
b. Type the text and press the Ctrl Key.
c. Type the text.
d. Type the first 5 letters of the replacement text.

Chapter 6
Adding Charts and Pictures

26. You can specify the type of chart and select the data series to be included using:
a. The Format Chart Area dialog box.
b. The Chart Wizard.
c. Chart Preview.

27. If you update data in a worksheet, Excel will:
a. Delete the chart.
b. Not change the chart.
c. Automatically update the chart.

28. Use the _______ to draw lines and shapes on a chart and also to insert graphic objects into the chart.
a. Format Chart Area dialog box
b. Chart toolbar
c. Drawing toolbar

29. You can print a chart with or without displaying the associated worksheet data.
a. True
b. False

30. To allow users of a workbook to click and access Web or intranet documents, insert a _______ in a worksheet.
a. 3-D reference
b. Hyperlink
c. Web browser

Chapter 7
Viewing and Printing

31. Freezing a worksheet row is helpful to keep headings _______ while scrolling.
a. Hidden
b. Visible
c. On a different page
d. Formatted

32. The Excel tool that allows you to display only selected rows of data is called:
a. AutoFit.
b. AutoComplete.
c. AutoFilter.

33. Headers and footers appear on the top and bottom of:
a. Each printed page of a worksheet.
b. The complete display of a worksheet.
c. Every 17 rows of a worksheet.

34. Once you select a print area, it is used until you:
a. Print one time.
b. Exit Excel.
c. Close the worksheet.
d. Reset or clear the print area.

35. A comment is a short note that attaches to:
a. An entire Excel worksheet.
b. A single cell of a worksheet.
c. A column heading.