WorksheetsEXCEL TEST
Total questions: 23
Worksheet time: 3hrs 51mins
Name
Class
Date
1.
WHAT IS THE GRID MADE UP OF?
a)
BLOCKS
b)
CELLS
c)
SECTIONS
d)
TABS
2.
WHICH ONE OF THESE IS NOT A FORMULE
a)
sum=(D5+E5)
b)
MAX=(D5:D7)
c)
B1*B2
d)
MIN=(D5:D7)
3.
EACH PAGE IS CALLED A SPREADSHEET
a)
TRUE
b)
FALSE
4.
Aligns the text to the right, left, or center.
a)
Orientation
b)
Indenting
c)
Alignment
d)
Wrapping
5.
Move the text several places to the right or left.
a)
Wrapping
b)
Orientation
c)
Indenting
d)
Alignment
6.
=A1+5
a)
Formula
b)
Function
7.
To select a group of cells, you must click each cell individually until all cells in the range are selected.
a)
True
b)
False
8.
What is the cell in the worksheet in which you can type data?
a)
Main Cell
b)
Open Cell
c)
Active Cell
d)
Absolute Cell
9.
You can enter functions ________.
a)
with the keyboard or mouse
b)
using the Sum menu
c)
using the Insert Function box
d)
all the choices
10.
____________ is the process of finding and correcting errors in a worksheet.
a)
Debugging
b)
Fixing
c)
Checking
d)
Editing
11.
Use the ___ function to display the highest value in a range.
a)
MAX
b)
MIN
c)
both choices
d)
none of the choices
12.
Why would you want to change the column width?
a)
to make sure the title is visible
b)
to make sure headings are always visible
c)
to make sure all of the numbers are visible
d)
All of the Above
13.
Numbers in Excel are automatically aligned ____.
a)
Right
b)
Left
c)
Center
d)
Justify
14.
Text in Excel is automatically aligned ____.
a)
Right
b)
Left
c)
Center
d)
Justify
15.
The dark screen square in the bottom right corner of the active cell.
a)
Phil Handley
b)
Fill Handle
c)
Option rotator
d)
Square link
16.
The horizontal placement of cells in a table or worksheet.
a)
range
b)
row
c)
column
d)
cell
17.
What is a vertical section of a spreadsheet
a)
row
b)
addition
c)
column
d)
format
18.
I totally messed up what I was working on. I need to press ________ to Undo what I did.
a)
Ctrl + Z
b)
Ctrl + U
c)
Ctrl + Y
d)
Ctrl + R
19.
I went back too far. I need to press ________ to Redo what I need.
a)
Ctrl + Z
b)
Ctrl + U
c)
Ctrl + Y
d)
Ctrl + R
20.
I am finished and ready to print. I can use _______ to get to the print screen.
a)
Ctrl + D
b)
Ctrl + O
c)
Ctrl + P
d)
Ctrl + W
21.
What reasons would I not print a hard copy?
a)
To serve as a backup
b)
For proofreading
c)
To put on a flash drive
22.
If I want to format rows, then I can use _________ Styles.
a)
Table
b)
Cell
c)
Formula
d)
Sum
23.
How do I get my Net total?
a)
Income + Expense
b)
Expense - Income
c)
Income x Expense
d)
Income - Expense
100 %
