WorksheetsFormulas in Excel
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
Any formula in Excel begins with...
a)
=
b)
*
c)
(
d)
"
2.
Match each symbol with its operation
a)
+
1.
addition
b)
-
2.
subtraction
c)
*
3.
multiplication
d)
/
4.
division
e)
^
5.
power
3.
What is the result of the formula
= A1 + B1
a)
18
b)
11
c)
29
d)
-7
4.
What is the result of the formula
= A1 - B1
a)
18
b)
11
c)
7
d)
-7
5.
What is the result of the formula
= A1 * B1
a)
18
b)
11
c)
29
d)
-7
6.
What is the result of the formula
= A3 / B3
a)
6
b)
15
c)
61
d)
54
7.
What is the result of the formula
=A4 - (B4 - C4)
a)
9
b)
1
c)
15
d)
−4
8.
What is the result of the formula
=C1 ^ 2
a)
9
b)
6
c)
5
d)
4
9.
Which formula would find the total of the numbers on row 1?
a)
A1 + B1 + C1
b)
= A1 + B1 + C1
c)
= A1 + A2 + A3 + A4
d)
= A1 * B1 * C1
10.
Which formula would find the total of the numbers in column A?
a)
A1 + A2 + A3 + A4
b)
= A1 + B1 + C1
c)
= A1 + A2 + A3 + A4
d)
= A1 * A2 * A3 * A4
100 %
