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.
A printed version of a worksheet is called a ____.
 A: hard copy
 B: copy
 C: file
 D: worksheet copy
2.
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
3.
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
4.
A column letter above the grid, also called a ____, identifies each column.
 A: column heading
 B: column reference
 C: cell heading
 D: table reference
5.
The horizontal and vertical lines on a worksheet are called ____.
 A: cells
 B: sheets
 C: blocklines
 D: gridlines
6.
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
7.
The AutoCorrect feature works behind the scenes correcting which of the following mistakes?
 A: Corrects two initial capital letters by changing the second one to lowercase
 B: Capitalizes the names of the days
 C: Replaces commonly misspelled words with their correct spelling
 D: All of the above
8.
Excel's ____ function allows you to add all of the numbers in a range of cells.
 A: MIN
 B: MAX
 C: SUM
 D: ADD
9.
To split a merged cell, select the cell and click the ____ button.
 A: Split
 B: Center
 C: Merge and Center
 D: Split and Merge
10.
To save a workbook using the shortcut keys, press ____.
 A: ALT+S
 B: CTRL+S
 C: SHIFT+S
 D: CTRL+F2
11.
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
12.
The ____ on a Worksheet is one in which you can enter data.
 A: cell
 B: active cell
 C: home cell
 D: reference cell
13.
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
14.
Excel opens a new workbook with ____ worksheets.
 A: one
 B: two
 C: three
 D: five
15.
Each worksheet in a workbook has ____ columns.
 A: 100
 B: 256
 C: 16,384
 D: unlimited
16.
A ____ is a list of commands.
 A: tab
 B: Key Tip
 C: menu
 D: dialog box
17.
By default, Excel positions text in a cell ____.
 A: left-aligned
 B: right-aligned
 C: centered
 D: justified
18.
A file name can have a maximum of ____ characters.
 A: 25
 B: 100
 C: 255
 D: 32,676
19.
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
20.
To move the insertion point to the beginning of data in a cell, press ____.
 A: Begin
 B: Page Up
 C: End
 D: Home

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