WorksheetsExcel Formulas
Total questions: 10
Worksheet time: 4mins
Name
Class
Date
1.
What's the Operation?
/
a)
Subtraction
b)
Multiplication
c)
Addition
d)
Division
2.
What's the Operation?
-
a)
Subtraction
b)
Multiplication
c)
Addition
d)
Division
3.
What's the Operation?
+
a)
Subtraction
b)
Multiplication
c)
Addition
d)
Division
4.
What's the Operation?
*
a)
Subtraction
b)
Multiplication
c)
Addition
d)
Division
5.
What is the symbol that lets Excel know that we are entering a formula into a cell?
a)
-
b)
=
c)
_
d)
(
6.
Which of the following shows the accurate formula to determine the total budget?
a)
=1+2
b)
=B3
c)
=A1+A2
d)
=B1+B2
7.
What cell contains an Excel formula?
a)
A4
b)
B4
c)
C4
d)
D4
8.
What is the cell range of the yellow highlighted cells?
a)
C1:C3
b)
C1:D3
c)
D3:C1
d)
D1:D3
9.
What cell contains the word Excel?
a)
A4
b)
B4
c)
C4
d)
D4
10.
What cell contains a combination of text and numerical data?
a)
A1
b)
A4
c)
B2
d)
D4
100 %
