AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Computing

Formulas that do the sums

Week 17 · Unit 7.4: The power of data · 3 lessons
Answers are for parents and teachers.
1
Draw a small grid on paper with columns A to E and rows 1 to 6. Write the cell reference of (a) the cell in the third column and the fourth row, (b) the cell in the last column and the first row.
2
What does the formula in B7 show? Work it out by hand.
B7fx=SUM(B2:B6)
AB
1MonthPages read
2Jan6
3Feb4
4Mar9
5Apr1
6May5
7Total?
3
Zoe says: ‘I will type the total instead of using a formula, because it is quicker.’ Explain to her why a formula is better. Use the word ‘change’ in your answer.
4
A teacher’s sheet has a quiz mark in each of the cells B2 to B9 and the formula =B2/10*100 in C2 that is copied down to C9. Write the formula that appears in C5. Is this a relative or an absolute reference?
5
Write a conditional formatting rule (cells, condition and format) for a sheet of fruit stock in cells B2:B10, so that the shop owner sees at once which fruits are almost sold out (fewer than 5 left). Which numbers in 12, 5, 4, 0, 9 get the format?