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

Count, total, decide

Week 16 · 2.1 Spreadsheets and analysing data · 3 lessons
Answers are for parents and teachers.
1
Four classes recorded the points they earned in a reading challenge. Write the formulas for the total, the highest and the lowest of the points in B2:B5, and for the number of classes with more than 20 points. The points are 18, 25, 31 and 12.
AB
1ClassPoints
2A18
3B25
4C31
5D12
2
A column has these seven cells: 6, 9, the word none, an empty cell, 14, 3, 9. Work out COUNT, COUNTA, COUNTIF with "=9" (or 9) and MAX for the seven cells.
3
Write the range that covers the cells that are highlighted, and work out the sum of its numbers.
ABCD
1ItemQ1Q2Q3
2a158
3b436
4c972
4
A formula in E2, =D2*B10, multiplies a sales figure by a rate in B10. It is filled down to E4, and only the first answer is right. Explain what has gone wrong and repair the formula.
5
A model of a bake sale totals the sales and shows the best-selling item with MAX. Write two conclusions you could draw from the figures, and one limitation of the model. Invent suitable figures first.