Font size
S
M
L
XL
WorksheetsExel Formulas
Total questions: 12
Worksheet time: 7mins
Name
Class
Date
1.
What formula needs to be inserted into cell B6?
a)
=TOTAL(B1:B5)
b)
=(B1:B5)TOTAL
c)
=SUM(B1:B5)
d)
=(B1:B5)SUM
2.
Which formula has been entered into cell D10?
a)
=2*£0.25
b)
=D10*C10
c)
=B10*C10
3.
Which formula is being used in cell D6?
a)
=4*£1.00
b)
C6+B6
c)
=D6*B6
d)
=B6*C6
4.
Which formula is being used in cell D2?
a)
=D2*C2
b)
=B2*C2
c)
=10*£0.25
5.
Which formula is being used in cell D11?
a)
SUM(D10 to D2)=
b)
=SUM(D2,D10)
c)
=(D2:D10)SUM
d)
=SUM(D2:10)
6.
What is the cell range for A?
a)
B2 to B6
b)
A4:A5
c)
A4,A5
d)
A4 to A5
7.
What is the cell range for B?
a)
B2,B6
b)
A4:A5
c)
A8, D8
d)
B2:B6
8.
What is the cell range for C?
a)
C1:E1
b)
C1:D3
c)
C1,D3
d)
C1:E3
9.
What is the cell range for D?
a)
D4:H9
b)
E5,H9
c)
E5:H9
d)
D4,H9
10.
What is the cell range for E?
a)
A8:D8
b)
A8,D7
c)
D7,A8
d)
A8:D9
11.
Type in the symbol to multiply in excel
(a)
12.
Type in the symbol to divide in excel.
(a)
Reset
