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.
To emphasize certain entries and make the worksheet easier to read and understand, you ____ the worksheet.
A:
format
B:
edit
C:
print
D:
proofread
2.
The vertical axis of a chart is called the ____ axis.
A:
long
B:
range
C:
value
D:
floating
3.
To move the insertion point to the beginning of data in a cell, press ____.
A:
Begin
B:
Page Up
C:
End
D:
Home
4.
To save a workbook using the shortcut keys, press ____.
A:
ALT+S
B:
CTRL+S
C:
SHIFT+S
D:
CTRL+F2
5.
A printed version of a worksheet is called a ____.
A:
hard copy
B:
copy
C:
file
D:
worksheet copy
6.
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
7.
____ cells involves creating a single cell by combining two or more selected cells.
A:
Formatting
B:
Merging
C:
Embedding
D:
Splitting
8.
____ allow users to enter, calculate, manipulate, and analyze data.
A:
Charts
B:
Lists
C:
Worksheets
D:
Databases
9.
Which of the following is not a valid entry into a cell that requires numbers?
A:
+
B:
E
C:
#
D:
$
10.
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
11.
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
12.
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
13.
The default view in Excel is ____ view.
A:
Work
B:
Auto
C:
Normal
D:
Roman
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.
The basic unit of a worksheet into which you enter data is called a ____.
A:
tab
B:
cell
C:
box
D:
range
16.
Each worksheet in a workbook has ____ columns.
A:
100
B:
256
C:
16,384
D:
unlimited
17.
The horizontal and vertical lines on a worksheet are called ____.
A:
cells
B:
sheets
C:
blocklines
D:
gridlines
18.
The mouse pointer turns to a ____ whenever you move it outside the worksheet.
A:
hand
B:
block arrow
C:
double-headed arrow
D:
crosshair
19.
You press the ____ key on the keyboard to display a Key Tip badge.
A:
ESC
B:
CTRL
C:
ALT
D:
HOME
20.
The ____ is a central location for managing and sharing workbooks.
A:
Ribbon
B:
Office Button
C:
ScreenTip
D:
Share toolbar
Enter your name and click the 'Grade Test' button.