NEW
Font size
S
M
L
XL
WorksheetsExcel Unit Review
Total questions: 31
Worksheet time: 7mins
Name
Class
Date
1.
What is the icon for the Excel program?
a)
Blue W
b)
Green X
c)
Orange P
d)
Red E
2.
What is the file extension for an Excel file?
a)
.jpg
b)
.excl
c)
.doc
d)
.xlsx
3.
What can Excel NOT do?
a)
calculate
b)
use words and numbers
c)
show videos
d)
show pictures
4.
Which of the following are NOT found in the Excel program?
a)
animations
b)
columns
c)
formulas
d)
cells
5.
What is one of the most useful things the Excel program can make?
a)
spreadsheet
b)
slideshow
c)
collage
d)
letter
6.
What does Excel use to make calculations?
a)
words
b)
formulas
c)
formatting
d)
pictures
7.
What is the Excel symbol for multiplying?
a)
/
b)
( )
c)
X
d)
*
8.
What symbol always begins a formula?
a)
IF
b)
#
c)
=
d)
(
9.
Which button will add a column of numbers?
a)
merge and center
b)
Esc
c)
Autosum
d)
Ctrl
10.
To find the total, you ___ the sub-total and tax.
a)
add
b)
subract
c)
multiply
d)
divide
11.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
12.
If I want to add a column of numbers, which button above would I use?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
13.
If I want to make a cell a particular color, which button would I click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
14.
If I want to put a border around a cell, which button would I choose?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
15.
What is the dot in the red circle used for?
a)
highlight cells
b)
wrap text
c)
copy formulas
d)
merge cells
16.
Where do I widen a column?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
17.
Where do I select every cell on the entire worksheet?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
18.
In this spreadsheet, the tax is a % of WHAT?
a)
cost
b)
total
c)
sub-total
d)
price
19.
In this spreadsheet, what would the formula for the COST be?
a)
=A2*D2
b)
=B2*C2
c)
=4.85+7
d)
4.84*7=33.95
20.
What is the formula telling you?
a)
a cell equals the grand total
b)
a cell equals the total tax from all worksheets
c)
a cell equals the amount of a cell on another worksheet
d)
a formula that calculates an Autosum
21.
What was used to create the menu indicated by the arrow?
a)
text box
b)
comment box
c)
formula
d)
merged cells
22.
Which of the following is a correctly written Excel FORMULA?
a)
B3+G4=H5
b)
34*6=
c)
=B3+G4
d)
(G2*Monday!=
23.
How do you delete the tab of a worksheet?
a)
highlight all the cells and press the delete button
b)
choose file, then select delete
c)
highlight all the cells and press the backspace button
d)
right click on the tab, choose delete
24.
In this spreadsheet, what would the formula be for the TOTAL?
a)
=D17+D18
b)
D17+D18=
c)
D17*D18=
d)
=D17-D18
25.
This is an example of a blank ___?
a)
Document
b)
Worksheet
c)
Data Base
d)
Slide
26.
What program created this payroll spreadsheet?
a)
PowerPoint
b)
Word
c)
Excel
d)
Jpeg
27.
What does this picture represent?
a)
cell coordinates
b)
a formula
c)
autosum
d)
a sub-total
28.
What is the red arrow indicating?
a)
expand the column
b)
widen the row
c)
create a formula
d)
make a textbox
29.
What is in the red circle?
a)
text box
b)
formula
c)
comment box
d)
word clue
30.
In making a formula, the word "of" always means to ___?
a)
add
b)
subtract
c)
multiply
d)
divide
31.
Which of the following is true?
a)
cost = price times the sub-total
b)
cost = price times the amount you buy
c)
cost = tax + total
d)
cost = price plus the amount you buy
Reset
