WorksheetsQUIZ#1 COMPUTER 6
Total questions: 25
Worksheet time: 27mins
SOLVE!
=(A1+B3+C3)
(a)
SOLVE!
=(C3-A5)+ E6
(a)
SOLVE!
=(A3+E3+B1+B2+B3)
(a)
SOLVE!
=(A1+A2) + (A3-D4)
(a)
SOLVE!
=(C4*D7)
(a)
SOLVE!
=(A1+A2+A3)-(B1-A4)
(a)
SOLVE!
=(B1-A1)*(A2+D2)
(a)
SOLVE!
=(A8+B8+D8+C8+E8)
(a)
SOLVE!
=(A8+B8+D8+C8+E8)-D5
(a)
SOLVE!
=(A8+B8)+(A2+C6)+(C5+E5)
(a)
It calculates the sum of the values of a range of cells.
=sum
=add
=total
=all
It calculates the arithmetic mean of a range of cells or values.
=arithmetic
=add
=average
=base
It gives the maximum value in a range of cells or values
=big
=max
=large
=base
It counts the number of cells in a range of cells or values.
=number
=count
=counting
=many
F (a) are built-in formulas you can use to make your worksheet construction easier.
Solve:
=sum(A1:D1)
(a)
Solve:
=sum(B1:E1)
(a)
Solve:
=sum(A1:A5)
(a)
Solve:
=COUNT(A1:A5)
(a)
Solve:
=MAX(A1:A5)
(a)
Solve:
=MAX(B1:B5)
(a)
Solve:
=MIN(C1:C5)
(a)
Solve:
=MIN(E1:E5)
(a)
Solve:
=AVERAGE(E1:E4)
(a)
Solve:
=AVERAGE(E2:E5)
(a)
