WorksheetsExtreme Sports Homework - Quiz 3
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
=SUM(A5:A8) isvequivalent to A5+A6+A7+A8
a)
True
b)
False
2.
The formula to add data from cell B12 to cell B20 is
a)
=SUM(B12, B20)
b)
=SUM(B12+B20)
c)
=SUM(B12:B20)
d)
=SUM(B12 - B20)
3.
The fill handle - used for copying formula or extending a data series.
a)
b)
c)
d)
4.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
5.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
6.
If B3:J8 is given, what is it referring to?
a)
range of cells B3 through J8
b)
only cell J8
c)
only cells B3 and J8
d)
only cell B3
7.
I can find the lowest number in a range with the ... function
a)
MIN
b)
MAX
c)
AVERAGE
d)
COUNT
8.
What function can be used to find the largest number in a range of numbers?
a)
=MIN
b)
=MAX
c)
=AVERAGE
d)
=SUM
9.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
10.
Which career(s) or places of employment involve the use of a spreadsheet at work?
a)
Accountant
b)
Hospital
c)
All Choices
d)
Shop Keeper
11.
What would you format a cell as when working with amounts of money?
a)
currency
b)
percent
c)
number
d)
scientific
12.
What do you call the box where a row and column intersect?
a)
Jail
b)
Gaol
c)
Cell
d)
Box
13.
To create an absolute cell reference ___________ sign is used before the parts of formula.
a)
#
b)
$
c)
*
d)
=
14.
Cell address $A$4 in a formula means it is a
a)
Absolute cell reference
b)
Mixed cell reference
c)
Relative cell reference
d)
None of these
15.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
100 %
