NEW
Font size
S
M
L
XL
WorksheetsCalculation in Excel
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
What is the result of the formula =3^2 in Excel?
a)
9
b)
6
c)
8
d)
10
2.
If you have the formula =A1+B1 in Excel and A1 is 5 and B1 is 3, what will be the result?
a)
8
b)
2
c)
15
d)
3
3.
What does the formula =4*5-7 calculate in Excel?
a)
13
b)
15
c)
12
d)
20
4.
What will the formula =10/2+3 result in Excel?
a)
8
b)
6
c)
7
d)
5
5.
What is the outcome of the formula =2^3+4 in Excel?
a)
12
b)
8
c)
10
d)
6
6.
If you use the formula =A2-B2*2 in Excel and A2 is 10 and B2 is 3, what will the result be?
a)
4
b)
8
c)
16
d)
12
7.
What is the result of the formula =5+3*2 in Excel?
a)
11
b)
8
c)
13
d)
10
8.
If you enter the formula =3^4 in Excel, what will be the result?
a)
81
b)
64
c)
27
d)
12
9.
What is the output of the formula =7-2^2 in Excel?
a)
3
b)
5
c)
7
d)
4
10.
What will the formula =8/4+2*3 yield in Excel?
a)
10
b)
6
c)
8
d)
12
11.
What formula in Excel would you use to calculate 3 raised to the power of 4?
a)
=3^4
b)
=3*4
c)
=3-4
d)
=3+4
12.
If cell A1 contains the value 5 and cell A2 contains the value 3, what formula would you use in Excel to find the result of A1 minus A2?
a)
=A1-A2
b)
=A1+A2
c)
=A1/A2
d)
=A1*A2
13.
What is the result of the formula =2^3 in Excel?
a)
8
b)
4
c)
5
d)
6
14.
Which of the following formulas correctly multiplies the value in cell B1 by 10 in Excel?
a)
=B1*10
b)
=B1+10
c)
=B1-10
d)
=10/B1
15.
If cell C1 has a value of 12 and you want to divide this value by 4 using Excel, what formula would you use?
a)
=C1/4
b)
=C1*4
c)
=C1-4
d)
=C1+4
16.
What is the formula to calculate the sum of the values in cells D1 and D2 in Excel?
a)
=D1+D2
b)
=D1/D2
c)
=D1-D2
d)
=D1*D2
17.
If you want to calculate the square of the number in cell E3 in Excel, which formula should you use?
a)
=E3^2
b)
=E3*2
c)
=E3-2
d)
=E3+2
18.
Which of the following Excel formulas would correctly calculate 10 divided by the value in cell F5?
a)
=10/F5
b)
=10*F5
c)
=10-F5
d)
=10+F5
19.
What formula would you use in Excel to calculate the difference between the values in cells G1 and G2?
a)
=G1-G2
b)
=G1*G2
c)
=G1+G2
d)
=G1/G2
20.
If you want to raise the number in cell H3 to the power of 5 in Excel, which formula should you enter?
a)
=H3^5
b)
=H3+5
c)
=H3-5
d)
=H3*5
Reset
