WorksheetsG-8 Spreadsheet Formula and Functions
Total questions: 10
Worksheet time: 14mins
Name
Class
Date
1.
What do all formulas begin with?
a)
%
b)
[ ]
c)
=
d)
:
2.
What symbol do we use for multiplication in a Spreadsheet program?
a)
/
b)
=
c)
^
d)
*
3.
What symbol do we use for division in a Spreadsheet program?
a)
/
b)
*
c)
+
d)
=
4.
Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?
a)
A4-A3=
b)
A3-A4=
c)
=A4-A3
d)
=A3-A4
5.
Which of the following tells a Spreadsheet to Divide the value in cell A3 by 27?
a)
=27/A3
b)
= A3/27
c)
= 27^A3
d)
=A3*27
6.
Which of the following formulas will add cells A1 thru A5?
a)
=SUM(A2+A5)
b)
=A1+A2+A3+A4+A5
c)
=A1:A5
d)
=A1-A2-A3-A4-A5
7.
Which of the following is a formula that will multiply cells A1 and A2?
a)
A1*A2
b)
=A1:A2
c)
=A1*A2
d)
=Multiply(A1:A2)
8.
Which of the following is a formula that will divide cell D10 by 2?
a)
=D10/A2
b)
10/2
c)
=D10*2
d)
=D10/2
9.
Which of the following is a correct example using the AUTOSUM function?
a)
sum(D14:D19)
b)
=D14:d19
c)
=sum(D14:D19)
d)
=D14+D15+D16+D17+D18+D19
10.
__________ function that counts the number of cells that contains numeric value.
a)
IF
b)
MAX
c)
COUNT
d)
LEN
100 %
