WorksheetsExcel Formula
Total questions: 20
Worksheet time: 10mins
A simple formula always starts with :
+
=
-
*
+ is a symbol for:
Multiplication
Addition
Subtraction
Dividing
* is a symbol for:
Multiplication
Addition
Subtraction
Dividing
/ is a symbol for:
Multiplication
Addition
Subtraction
Dividing
- is a symbol for:
Multiplication
Addition
Subtraction
Dividing
What formula CANNOT calculate the total stock level in the bakery for all of its products combined.
=SUM(C2:C7)
=SUM(C2,C3,C4,C5,C6,C7)
=C2+C3+C4+C5+C6+C7
=SUMC2+C3+C4+C5+C6+C7
Which of the formula's would output the price of the CHEAPEST item in the bakery?
=MIN(B2:B7)
=LOW(B2:B7)
=SML(B2:B7)
=BOTTOM(B2:B7)
Which of the formula's would output the price of the MOST EXPENSIVE item in the bakery?
=MAX(B2:B7)
=HIGH(B2:B7)
=LRG(B2:B7)
=TOP(B2:B7)
Excel will display _______________________ if the cell is not wide enough.
******
^^^^^
######
>>>>>
To edit a formula you
Double-click the cell
Click in the formula bar
Press Esc
Both A & B
Answer =2+3*3-2
9
10
11
12
Answer =3+5*(6-2)
23
32
31
64
Which formula will calculate the average?
average
countif
averageif
sumif
An error that occurs when a formula is not spelt correctly
#NAME?
#VALUE!
#DIV/0!
#####
What feature is particularly useful when you want to add all numbers in a row or column
Autosum
Product
Operators
Hierarchy
What is error value that is displayed on the excel when the formula contains invalid data
Autosum
#VALUE!
Arguments
operators
