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 ____ command in the AutoCalculate area displays the highest value in the selected range.
 A: Large
 B: Highest
 C: Most
 D: Maximum
2.
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
3.
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
4.
You press the ____ key on the keyboard to display a Key Tip badge.
 A: ESC
 B: CTRL
 C: ALT
 D: HOME
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.
The default view in Excel is ____ view.
 A: Work
 B: Auto
 C: Normal
 D: Roman
7.
The range of cells receiving a copy is called the ____ area.
 A: source
 B: destination
 C: copy
 D: reference
8.
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
9.
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
10.
Excel opens a new workbook with ____ worksheets.
 A: one
 B: two
 C: three
 D: five
11.
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
12.
The ____ is a central location for managing and sharing workbooks.
 A: Ribbon
 B: Office Button
 C: ScreenTip
 D: Share toolbar
13.
____ cells involves creating a single cell by combining two or more selected cells.
 A: Formatting
 B: Merging
 C: Embedding
 D: Splitting
14.
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
15.
To emphasize certain entries and make the worksheet easier to read and understand, you ____ the worksheet.
 A: format
 B: edit
 C: print
 D: proofread
16.
____ allow users to enter, calculate, manipulate, and analyze data.
 A: Charts
 B: Lists
 C: Worksheets
 D: Databases
17.
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
18.
A column letter above the grid, also called a ____, identifies each column.
 A: column heading
 B: column reference
 C: cell heading
 D: table reference
19.
To split a merged cell, select the cell and click the ____ button.
 A: Split
 B: Center
 C: Merge and Center
 D: Split and Merge
20.
The ____ on a Worksheet is one in which you can enter data.
 A: cell
 B: active cell
 C: home cell
 D: reference cell

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