Have an account?
Skip to Content
Build your own quiz
Suggestions for you
14 questions
Show Answers
See Preview
- 1. Multiple Choice
Which symbol is used at the beginning of all formulae and functions?
+
-
=
$
- 2. Multiple Choice
Which symbol is used in a formula for adding?
*
-
/
+
- 3. Multiple Choice
Which symbol is used in a formula for subtracting?
*
-
/
+
- 4. Multiple Choice
Which symbol is used in a formula for multiplying?
*
-
/
+
- 5. Multiple Choice
Which symbol is used in a formula for dividing?
*
-
/
+
- 6. Multiple Choice
What is the formula to add up A1 and B1?
=SUM(A1:B1)
=A1+B1
A1+B1
=ADD(A1:B1)
- 7. Multiple Choice
What is the formula to work out A2 take away B2?
A2-B2
=A2-B2
=SUB(A2:B")
=A2MINUSB2
- 8. Multiple Choice
What is the formula to multiply A3 by B3?
=MULTIPLY(A3:B3)
=A3xB3
=A3*B3
=A3TIMESB3
- 9. Multiple Choice
What is the formula to divide A4 by B4?
=A4÷B4
=A4DIVIDEB4
=A4\B4
=A4/B4
- 10. Multiple Choice
What is the function to add up A1 to B5?
=A1+A2+A3+A4+A5+B1+B2+B3+B4+B5
=(A1:B5)
=SUM(A1:B5)
=ADD(A1:B5)
- 11. Multiple Choice
What is the function to find out the average of A1 to B5?
=(A1+A2+A3+A4+A5+B1+B2+B3+B4+B5)/10
=SUM(A1:B5)/10
=A1:B5)AVERAGE
=AVERAGE(A1:B5)
- 12. Multiple Choice
What is the difference between a formula and a function?
Nothing. They are exactly the same.
a formula uses words and functions use mathematical symbols.
A formula is input entirely by the user using cell references and mathematical symbols. A function uses a predefined formula, usually in the form of a word.
A formula starts with an = sign but a function doesn't.
- 13. Multiple Choice
What is the function to find out the lowest number in cells A1 to B5?
=LOWEST(A1:B5)
=LOW(A1:B5)
=MIN(A1:B5)
=MAX(A1:B5)
- 14. Multiple Choice
What is the function to find out the highest number in cells A1 to B5?
=HIGHEST(A1:B5)
=HIGH(A1:B5)
=MIN(A1:B5)
=MAX(A1:B5)
- Answer choicesTagsAnswer choicesTags