Practice and test work
Answers are for parents and teachers.
1
Find the price of a 90 000 so‘m product with 12% VAT added.
100800
2
If B2 = 55, C2 = 62 and D2 = 71, write the formula that calculates their mean.
=(B2+C2+D2)/3
3
Find the value of y = 3x – 1 at x = 4.
11
4
A1 holds the text “Excel”. What does =REPT(A1,2) give?
ExcelExcel
5
List five things to check before handing in the test.
starting with “=”; paired brackets; the $ signs; text in quotation marks; the chart title.