Practice Test Project 1
INSTRUCTIONS: Answer each question below. Enter your name and click the 'Grade Test' button to receive a graded study guide. You will not get a grade until all questions are answered.
1.
The range of cells receiving a copy is called the ____ area.
 A: source
 B: destination
 C: copy
 D: reference
2.
To split a merged cell, select the cell and click the ____ button.
 A: Split
 B: Center
 C: Merge and Center
 D: Split and Merge
3.
To move the insertion point to the beginning of data in a cell, press ____.
 A: Begin
 B: Page Up
 C: End
 D: Home
4.
The ____ contains areas where you can view and enter document properties.
 A: Action Window
 B: Normal View
 C: Property Window
 D: Document Information Panel
5.
The ____ command in the AutoCalculate area displays the number of non blank cells in the selected range.
 A: Count
 B: Blank
 C: Zero
 D: Fill
6.
____ allow users to enter, calculate, manipulate, and analyze data.
 A: Charts
 B: Lists
 C: Worksheets
 D: Databases
7.
Each worksheet has a sheet name that appears on a(n) ____ at the bottom of the workbook.
 A: name indicator
 B: active tab
 C: title tab
 D: sheet tab
8.
A(n) ____ is a window that contains additional commands and can stay open and visible while you work on a worksheet.
 A: Ready window
 B: task pane
 C: Excel pane
 D: action window
9.
The ____, located near the top of the Excel window, is the control center in Excel.
 A: Ribbon
 B: Control bar
 C: Home tab
 D: Mode bar
10.
The number of worksheets that you can add to a workbook is ____.
 A: 100
 B: 256
 C: 1,067,456
 D: limited by the amount of memory on the computer
11.
A cell is referred to by its unique address, called a(n) ____, which is the coordinates of the intersection of a column and a row.
 A: cell reference
 B: name box
 C: unit
 D: active cell
12.
The horizontal and vertical lines on a worksheet are called ____.
 A: cells
 B: sheets
 C: blocklines
 D: gridlines
13.
A ____ is a list of commands.
 A: tab
 B: Key Tip
 C: menu
 D: dialog box
14.
The ____ is a central location for managing and sharing workbooks.
 A: Ribbon
 B: Office Button
 C: ScreenTip
 D: Share toolbar
15.
The ____ feature of Excel works behind the scenes, correcting common mistakes.
 A: AutoCorrect
 B: Spelling
 C: Help
 D: Ribbon
16.
A saved workbook is referred to as a ____.
 A: Book
 B: Workbook
 C: project
 D: file
17.
Excel's ____ function allows you to add all of the numbers in a range of cells.
 A: MIN
 B: MAX
 C: SUM
 D: ADD
18.
The small black square located in the lower-right corner of the heavy border around the active cell is called the ____.
 A: relative reference
 B: source area
 C: range
 D: fill handle
19.
The vertical axis of a chart is called the ____ axis.
 A: long
 B: range
 C: value
 D: floating
20.
Holding down the ____ key while you drag a chart snaps the edge of the chart area to the worksheet gridlines.
 A: ALT
 B: HOME
 C: INSERT
 D: CTRL

Enter your name and click the 'Grade Test' button.