Excel Lessons 1 – 3 Test Review
Multiple Choice
Select the best response for the following statements.
Excel Unit 1
1. An arrow in the lower-right corner of a group on the ribbon tells you that which of the
following is available?
a. A dialog box or task pane
b. An additional workbook
c. A list of worksheets
d. An additional part of the current range
2. Which feature enables you to preview headers and footers, page breaks, and other
features that will print?
a. Page Layout
b. Print Layout
c. Synchronous Scrolling
d. ScreenTips
3. When you split a window, the window is divided into how many panes?
a. two
b. three
c. four
d. two or four
4. Which of the following is the intersection of a row and column?
a. range
b. tab
c. bar chart
d. cell
5. Which of the following starts off with Save, Undo, and Redo and can be customized to
contain the commands you use most frequently?
a. A worksheet
b. The Help window
c. The Quick Access Toolbar
d. The ribbon
6. How many worksheets does a new Excel 2016 workbook open with?
a. one
b. two
c. three
d. four
True / False
Circle T if the statement is true or F if the statement is false.
T F 1. The Quick Access Toolbar appears on the right side of the title bar, above theribbon.
T F 2. The columns in a worksheet are identified by numbers.
T F 3. The active cell in a worksheet is outlined by a bold rectangle.
T F 4. Page Layout view is useful when preparing your data for printing.
Excel Unit 2
1. Which of the following consists of details that describe or identify a le, including the
author?
a. Paste
b. Document properties
c. Copy
d. Range
2. Which command is used to insert a cut or copied selection to a cell or range of cells?
a. Paste
b. Document properties
c. Copy
d. Range
3. If you want to use a workbook in another kind of document, you have the option to save
using which of the following?
a. File format
b. Worksheet
c. File sheet
d. File range
4. Which is a small green square in the lower-right corner of a selected cell or range that
you can use to copy one cell to adjacent cells or to create a series?
a. Cell pointer
b. Column marker
c. Fill handle
d. Formula bar
5. Which of the following can you drag or double-click to change the width of a column?
a. Cell pointer
b. Column marker
c. Fill handle
d. Formula bar
True / False
Circle T if the statement is true or F if the statement is false.
T F 1. Using the Delete key removes both text and formats from a cell.
T F 2. You can assign keywords so that others can search for your documents online.
T F 3. The formula bar is found at the bottom of the Excel window.
T F 4. Use the ll handle to create a natural series, such as the months of the year.
T F 5. Workbooks can be saved as web pages, PDF les, and for use in previous
versions of Excel.
Excel Unit 3
1. Which of the following is where you can save, select a template, change document
properties, and close or exit Excel?
a. Backstage
b. Print
c. Edit
d. Windows
2. To change printer, layout, or margin settings, you click the File tab and use which of the
following options?
a. Info
b. Options
c. Print
d. Open
3. Which of the following can be customized for quicker access to your most commonly
used commands?
a. Print Preview
b. Quick Access Toolbar
c. Printer setup
d. Workbook
4. When you modify the ribbon, which of the following is created?
a. command
b. tab
c. button
d. worksheet
5. Which predesigned file already has a significant amount of formatting, text, and other
features?
a. Blank workbook
b. Preset file
c. Text file
d. Template
True/False
Circle T if the statement is true or F if the statement is false.
T F 1. To access an Excel template, you can click the File tab and then click New.
T F 2. If you have too many columns on a page, the only option to see them all on a
printed page is to decrease the column width.
T F 3. You can access Backstage view by pressing Ctrl+B.
T F 4. In Excel, you can add your most commonly used commands to the Quick Access
Toolbar.
T F 5. You can create a completely new ribbon tab as well as groups on that ribbon.