NEW
Font size
S
M
L
XL
WorksheetsModeling
Total questions: 8
Worksheet time: 4mins
Name
Class
Date
1.
In Excel - What is the correct formula for multiplying two numbers together?
a)
=A2*A3
b)
=A2-A3
c)
=A2+A3
d)
=A2/A3
2.
In Excel - What is the correct function formula to calculate the average?
a)
=MAX(E2:E6)
b)
=AVERAGE(E3+E4)
c)
=AVERAGE(E2:E6)
d)
=COUNT(E2:E6)
3.
In Excel - What function formula would I use to calculate the highest number?
a)
=AVERAGE(F5-F7)
b)
=MIN(F5:F10)
c)
=MAX(F5:F10)
d)
=F5:F10
4.
In Excel - What is wrong with the below function formula?COUNT(F4:F10)
a)
Nothing, Formula is correct
b)
Missing an (equals sign) =
c)
There is no COUNT function
d)
Wrong Brackets
5.
In Excel - What is the correct formula to divide two numbers by each other?
a)
=A12/A13
b)
=A12<A13)
c)
=A12++A13
d)
A12/A13
6.
In Excel - Is an IF Statement True or False?
a)
Yes
b)
No
7.
In Excel - Which of the below is a correct IF Statement?
a)
=IF 400<"IN BUDGET"
b)
=IF(E24<=400, "IN BUDGET", OVER BUDGET")
c)
= 400
d)
=AVERAGE(E24:E34)
8.
What is the below function formula calculating?=AVERAGE(E24:E26)
a)
Calculate the Highest number between cells E24 & E26
b)
Calculate the Average of the numbers between cells E24 & E26
c)
It does nothing, incorrect formula
d)
To add up cells E24 & E26
Reset
