KS3 ICT Quiz
Models 02
Formulae can create output as charts and graphs like a pie chart.

Models 02

This KS3 ICT quiz is our second on models. Spreadsheets are frequently used for financial information because of their ability to re-calculate the entire sheet automatically after a change to a single cell is made. This is a simple way for businesses to see how small changes to prices or sales could affect their profits and losses.

Models work by taking a set of data and using rules to see how things change. The rules are represented using formulae, for example, profit is equal to the total sales minus the total cost of the wages, raw materials and other expenses. The data required to calculate the result of this formula will be contained in other cells. These can be read into the formula by making reference to the addresses of the other cells. In our example above, if the total sales is in cell B1, the wages figure in cell F8 and the total of the raw materials and other expenses in cell G14, the formula would be =B1-(F8+G14). The parentheses tell the spreadsheet to add the wages and expenses before subtracting them from the total sales.

Did you know...

You can play all the teacher-written quizzes on our site for just £9.95 per month. Click the button to sign up or read more.

Sign up here
  1. Which of these is not a formula?
    Doesn't start with =
  2. Models represent real life situations using .......
    The rules decide what happens to the data
  3. Spreadsheet models use ....... to represent rules.
    The formulae need to be set up very carefully to avoid incorrect results
  4. The values in the spreadsheet cells act as .......
    These can be entered manually or calculated from data that has been entered into other cells
  5. The formulae in the models act as .......
    These are effectively the rules that dictate how a model works. If just one of these is wrong, the whole model will fail
  6. The formulae can create output as charts and graphs.
    Use them when they are useful - not just for looks
  7. Spreadsheets are good at doing ....... analysis of data.
    For example: What happens to sales if tax rates increase?
  8. A model rule is: profit = number sold x saleprice - cost.
    The 'rule' is represented by a formula entered in a cell
  9. Models often include many rules because .......
    Even simple situations can need many rules to model
  10. Predictions made by models are usually .......
    Rules are rarely perfect and may not have complete data

Author: Duncan Daish

The Tutor in Your Computer!

Quiz yourself clever - 3 free quizzes in every section

  • Join us (£9.95/month) to play over 4,000 more quizzes
  • Reinforce your school learning in the comfort of home
  • Build your confidence in National Curriculum subjects
  • Test yourself to identify gaps in learning
  • Revise fast for tests and exams

© Copyright 2016-2017 - Education Quizzes
TJS - Web Design Lincolnshire

Valid HTML5

We use cookies to make your experience of our website better.

To comply with the new e-Privacy directive, we need to ask for your consent - I agree - No thanks - Find out more