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.
____ allow users to enter, calculate, manipulate, and analyze data.
 A: Charts
 B: Lists
 C: Worksheets
 D: Databases
2.
The ____ is a blinking vertical line that indicates where the next typed character will appear.
 A: insertion point
 B: Key Tip
 C: active cell
 D: Ribbon
3.
If you point to a button that includes an arrow, Excel displays a ____, which is a list of additional commands associated with the selected command.
 A: full menu
 B: hidden menu
 C: submenu
 D: Key Tip
4.
The process of editing a cell contents directly in the cell is called ____.
 A: Edit mode
 B: in-cell editing
 C: cell editing
 D: internal editing
5.
A ____ is a list of commands.
 A: tab
 B: Key Tip
 C: menu
 D: dialog box
6.
The ____ command in the AutoCalculate area displays the highest value in the selected range.
 A: Large
 B: Highest
 C: Most
 D: Maximum
7.
A ____ is a set of choices, often graphical, arranged in a grid or in a list.
 A: gallery
 B: table
 C: ribbon
 D: tab
8.
The ____ contains areas where you can view and enter document properties.
 A: Action Window
 B: Normal View
 C: Property Window
 D: Document Information Panel
9.
Each worksheet in a workbook has ____ rows.
 A: 100
 B: 32,767
 C: 65,536
 D: 1,048,576
10.
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
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.
In ____ mode, as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right.
 A: Insert
 B: Overtype
 C: Right-Align
 D: Push Right
13.
A column letter above the grid, also called a ____, identifies each column.
 A: column heading
 B: column reference
 C: cell heading
 D: table reference
14.
To split a merged cell, select the cell and click the ____ button.
 A: Split
 B: Center
 C: Merge and Center
 D: Split and Merge
15.
Excel opens a new workbook with ____ worksheets.
 A: one
 B: two
 C: three
 D: five
16.
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
17.
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
18.
A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.
 A: area
 B: range
 C: section
 D: list
19.
A(n) ____ chart is drawn on the same worksheet as its data.
 A: 3D Pie
 B: embossed
 C: embedded
 D: local
20.
To enter a number as text, start the entry with a(n) ____.
 A: asterisk
 B: hyphen
 C: semicolon
 D: apostrophe

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