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.
Each worksheet in a workbook has ____ rows.
 A: 100
 B: 32,767
 C: 65,536
 D: 1,048,576
2.
The ____ bar presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel.
 A: function
 B: indicator
 C: chart
 D: status
3.
____ cells involves creating a single cell by combining two or more selected cells.
 A: Formatting
 B: Merging
 C: Embedding
 D: Splitting
4.
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
5.
A file name can have a maximum of ____ characters.
 A: 25
 B: 100
 C: 255
 D: 32,676
6.
You press the ____ key on the keyboard to display a Key Tip badge.
 A: ESC
 B: CTRL
 C: ALT
 D: HOME
7.
A column letter above the grid, also called a ____, identifies each column.
 A: column heading
 B: column reference
 C: cell heading
 D: table reference
8.
The four major parts of Excel are ____.
 A: Worksheets, Charts, Tables, and Web Support
 B: Workbooks, Charts, Lists, and Databases
 C: Workbooks, Charts, Wizards, and Templates
 D: Worksheets, Charts, Graphs, and Databases
9.
A printed version of a worksheet is called a ____.
 A: hard copy
 B: copy
 C: file
 D: worksheet copy
10.
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
11.
The ____ feature of Excel works behind the scenes, correcting common mistakes.
 A: AutoCorrect
 B: Spelling
 C: Help
 D: Ribbon
12.
The horizontal and vertical lines on a worksheet are called ____.
 A: cells
 B: sheets
 C: blocklines
 D: gridlines
13.
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
14.
____ allow users to enter, calculate, manipulate, and analyze data.
 A: Charts
 B: Lists
 C: Worksheets
 D: Databases
15.
To move the insertion point to the beginning of data in a cell, press ____.
 A: Begin
 B: Page Up
 C: End
 D: Home
16.
To enter a number as text, start the entry with a(n) ____.
 A: asterisk
 B: hyphen
 C: semicolon
 D: apostrophe
17.
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
18.
The basic unit of a worksheet into which you enter data is called a ____.
 A: tab
 B: cell
 C: box
 D: range
19.
You view the portion of the worksheet displayed on the screen through a(n) ____.
 A: active window
 B: worksheet window
 C: cell
 D: active cell menu
20.
The ____ command in the AutoCalculate area displays the highest value in the selected range.
 A: Large
 B: Highest
 C: Most
 D: Maximum

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