Font size
WorksheetsExcel Formula
Total questions: 15
Worksheet time: 10mins
What symbol must be at the beginning of every formula you write in a spreadsheet?
(a)
=SUM(A1,A3,A4)
What is the purpose of this formula?
To add up the values referenced inside the brackets.
To multiply the values referenced inside the brackets
To compare the values referenced inside the brackets.
To find a value in the cells referenced inside the brackets.
=ROUND(AVERAGE(B2:B7), 0)
Select all statements that apply.
[Maximum: 3]
This formula includes cell referencing
This formula will find the mean number in the range selected.
This formula will round the answer to 2 decimal places.
The formula will produce a whole number as an answer.
Which formulas below will count the number of items with a cost above £1.50?
=COUNT(IF(B2>1.5))
COUNTIF(B2-B7, >1.5)
=COUNTIF(B2:B7, ">1.5")
COUNTIF(B2:B7, ">1.5")
=ROUND(A1*$C$3, 2)
Select all that apply.
[Maximum: 2]
This formula includes absolute referencing
This formula will add the values in the two cells.
This formula will round the answer to 2 decimal places.
The formula will produce a whole number as an answer.
Write a formula to find calculate the total stock level in the bakery for all of its products combined.
Your formula MUST include cell references.
(a)
Which mathematical function does the symbol below represent?
*
To the Power of
Multiplication
Division
Which mathematical function does the symbol below represent?
/
To the Power of
Multiplication
Division
Which mathematical function does the symbol below represent?
^
To the Power of
Multiplication
Division
Which of the formula's would correctly output Yes/No in column D.
=IF(D2 < 10) "Yes", "No"
=IF(D2 < 10, "Yes", "No")
=IF(D2 > 10, "Yes", "No")
IF(D2 > 10, "Yes", "No")
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)
A teacher is creating a formula to calculate the value to convert the scores from a recent test to percentage to look like the image.
Select all options that apply.
=(B2/35*100)
=(Results[@[Score]]/$D$2)
Change number format to Percentage
Select all statements that apply to a cell.
[Maximum: 2]
A single block in a table/spreadsheet where we enter data.
Can be referenced in a formula by using the column and row id (e.g. A2)
Does not allow text to be entered.
Can be used to trigger macros.
Which of the formula's would output the price of the cheapest item in the bakery?
=MAX(B2:B7)
=HIGH(B2:B7)
=LRG(B2:B7)
=TOP(B2:B7)
Which of the formulas below are conditional formulas.
Select all that apply. [Maximum: 2]
=SUM()
=IF()
=COUNTIF()
=AVERAGE()
