NEW
Font size
WorksheetsS1 Spreadsheets Functions/Formulae
Total questions: 14
Worksheet time: 7mins
Which symbol is used at the beginning of all formulae and functions?
+
-
=
$
Which symbol is used in a formula for adding?
*
-
/
+
Which symbol is used in a formula for subtracting?
*
-
/
+
Which symbol is used in a formula for multiplying?
*
-
/
+
Which symbol is used in a formula for dividing?
*
-
/
+
What is the formula to add up A1 and B1?
=SUM(A1:B1)
=A1+B1
A1+B1
=ADD(A1:B1)
What is the formula to work out A2 take away B2?
A2-B2
=A2-B2
=SUB(A2:B")
=A2MINUSB2
What is the formula to multiply A3 by B3?
=MULTIPLY(A3:B3)
=A3xB3
=A3*B3
=A3TIMESB3
What is the formula to divide A4 by B4?
=A4÷B4
=A4DIVIDEB4
=A4\B4
=A4/B4
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)
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)
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.
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)
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)
