NEW
Font size
WorksheetsExcel Formulas
Total questions: 15
Worksheet time: 8mins
Which of the following is not an arithmetic operator?
=
+
s
^
Why do you start a formula with an = sign?
to tell Excel you are entering a formula
just because
you are entering text
Where does Excel return the result of a formula
the same cell where the formula is entered
A1
in your head
What is the answer to the following formula: =2^4 + 7
13
71
23
123
What is the answer to the following formula: =25% * 40
140
25
75
10
In the following formula, what gets done first: =6+2*(6-2)
6+2
2*6
2*(6+2)
(6-2)
Which arithmetic operator is being used in the following formula: =T75- AA45
addition
multiplication
subtraction
format
What is the answer if the value in cell A5 is 75; C10 is 20; B23 is 15; E15 is 100; G20 is 5 and the formula is: =C10 + (A5 * G20)/ B23
43
55
49.6
45
What is the answer to the following formula: -(P45/Q14) where the value in cell P45 is 25, and in cell Q14 is 5?
5
15
-30
-5
Does Excel allow the use of numbers in formulas?
yes
no
What order does the order of operations follow?
right to left
left to right
up to dow
middle outwards
List the following in order of operations: addition (+), division (/), multiplication (*), subtraction (-).
/,+,-,*
*,/,+,-
^,s,r,t
Using exponentiation, what does = 3^4 do?
raises 3 to the fourth power
3 times 4
nothing
Do you need an = sign to start a formula?
no
yes
never
What is the next school break?
Easter break
summer break
spring break
labor day
