NEW
Font size
S
M
L
XL
Worksheetsgrade 5- spreadsheet for a purpose review
Total questions: 27
Worksheet time: 16mins
Name
Class
Date
1.
Columns go
a)
across
b)
diagonally
c)
up and down
2.
A column in a spreadsheet is designated by a
a)
picture
b)
letter
c)
number
3.
These go from side to side (horizontally)
a)
rows
b)
columns
c)
tables
4.
If something is in column B and row 5, what would it's cell address be?
a)
5B
b)
B5
c)
CBR5
5.
True of false: Spreadsheet columns may have titles to show what type of data they contain
a)
true
b)
false
6.
The small boxes on a spreadsheet are called
a)
cells
b)
boxes
c)
rows
d)
columns
7.
What is the cell address of fish?
a)
A3
b)
3D
c)
5C
d)
C5
8.
Which of these is a spreadsheet?
a)
b)
c)
9.
In what cell would you find the cost of the phone bill in February?
a)
C2
b)
C5
c)
1C
d)
A2
10.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize
d)
fill
11.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
12.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
13.
What does cell A1 contain?
a)
Sweet
b)
Mars
c)
A1
d)
Cost
14.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
15.
What formula is used in cell D3?
a)
B3*C3
b)
B3+C3
c)
=B3*C3
d)
11.50
16.
What formula is used in cell D8?
a)
=D3*D4*D5*D6
b)
SUM(D3:D6)
c)
=69.10
d)
=SUM(D3:D6)
17.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
18.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
19.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
20.
What is the formula in B9?
a)
=SUM(B3:B7)
b)
=AVERAGE(B3:B7)
c)
=AVERAGE(B3:B6)
d)
=B3+B4+B5+B6+B7/5
21.
When you key a formula in a spreadsheet what do you key in first?
a)
Subtraction sign
b)
Equal Sign
c)
Addition sign
d)
Division sign
22.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
23.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
24.
You can present your data graphically, using a
a)
chart
b)
print
c)
font
d)
sort
25.
Which formula would subtract D12 from D13?
a)
=D13-D12
b)
=D12-D13
c)
=sum(D12-D13)
d)
=sum(D13-D12)
26.
What Excel feature did we use to quickly apply this formatting feature?
a)
Data scenario formatting
b)
What-if analysis
c)
Conditional formatting
d)
PivotTables
27.
Changing the appearance of a cell based on a rule is called?
a)
Conditional Formatting
b)
Validation Formatting
c)
Filter Formatting
d)
Sort Formatting
Reset
