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 column letter above the grid, also called a ____, identifies each column.
A:
column heading
B:
column reference
C:
cell heading
D:
table 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.
A(n) ____ chart is drawn on the same worksheet as its data.
A:
3D Pie
B:
embossed
C:
embedded
D:
local
4.
To enter a number as text, start the entry with a(n) ____.
A:
asterisk
B:
hyphen
C:
semicolon
D:
apostrophe
5.
The ____ on a Worksheet is one in which you can enter data.
A:
cell
B:
active cell
C:
home cell
D:
reference cell
6.
By default, Excel positions text in a cell ____.
A:
left-aligned
B:
right-aligned
C:
centered
D:
justified
7.
The mouse pointer turns to a ____ whenever you move it outside the worksheet.
A:
hand
B:
block arrow
C:
double-headed arrow
D:
crosshair
8.
A printed version of a worksheet is called a ____.
A:
hard copy
B:
copy
C:
file
D:
worksheet copy
9.
The basic unit of a worksheet into which you enter data is called a ____.
A:
tab
B:
cell
C:
box
D:
range
10.
The vertical axis of a chart is called the ____ axis.
A:
long
B:
range
C:
value
D:
floating
11.
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
12.
Excel's ____ function allows you to add all of the numbers in a range of cells.
A:
MIN
B:
MAX
C:
SUM
D:
ADD
13.
Which of the following is not a valid entry into a cell that requires numbers?
A:
+
B:
E
C:
#
D:
$
14.
The ____ feature of Excel works behind the scenes, correcting common mistakes.
A:
AutoCorrect
B:
Spelling
C:
Help
D:
Ribbon
15.
A ____ is a list of commands.
A:
tab
B:
Key Tip
C:
menu
D:
dialog box
16.
The ____ command in the AutoCalculate area displays the highest value in the selected range.
A:
Large
B:
Highest
C:
Most
D:
Maximum
17.
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
18.
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
19.
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
20.
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
Enter your name and click the 'Grade Test' button.