Spreadsheets and Data Modelling: revision quiz and key terms
Free practice for Spreadsheets and Data Modelling in KS3 Computing (Years 7–9). It covers: cells, references and ranges, formulas and functions (SUM, AVERAGE, MAX, MIN, COUNT, IF), absolute references, sorting, filtering, charts, conditional formatting, validation and 'what if' models. Try the questions, then check the key terms.
Try 5 free questions
What happens when you change a number that a formula uses?
A cell reference such as B3 gives the column and the row of a cell.
A shop owner changes the price in her spreadsheet to see how her profit would change. What is this called?
=COUNT(A1:A10) adds up all the numbers in cells A1 to A10.
Why might you sort test results from highest to lowest?
In RADevo, this topic has fill-in-the-blank, matching, multiple-choice and true or false activities, and every question you get wrong comes back in Revise today until you've learnt it.
Key terms for Spreadsheets and Data Modelling
- AVERAGE
- Adds up a group of numbers and divides by how many there are.
- Bar chart
- Compares amounts in separate categories using rectangles of different lengths.
- COUNT
- Tells you how many boxes in a group contain numbers.
- Data validation
- Rules that only let sensible values be typed into a box, such as ages from 11 to 18.
- Filter
- Hides rows that don't match a rule so you only see the ones you want.
- Formula
- A calculation typed into a box that starts with an equals sign.
- MAX
- Gives the largest value in a group of boxes.
- Sorting
- Arranging a list in order, such as A to Z or smallest to largest.
Teaching KS3 Computing (Years 7–9)?
Set this topic as homework in two clicks, see who has done it and which questions your class got wrong, and start every lesson with a Do Now built from their mistakes.
Start a free 2-week trialRevising for this?
If your school uses RADevo, sign in to do the full quizzes and keep your progress. If it doesn't, show this page to your Computing teacher.
Log in to RADevo