Models 03

1. What name is given to the text at the top of a column?

   • Function
   • Label
   • Sum
   • Value

2. A cell contains the characters Total. This is called a .......

   • datum
   • label
   • output
   • result

3. A cell contains a number or date. This is called a .......

   • input
   • numeric
   • output
   • value

4. A formula is not normally displayed in a cell. It is found .......

   • in the address bar
   • in the formula bar
   • in the formulae bar
   • in the rule bar

5. Functions are pre-programmed formulae which .......

   • have to be learned by heart
   • perform tasks a user could not create a formula to do
   • save the user having to type in regularly used formulae
   • work better than formulae created by a user

6. Which of these is not a commonly used function?

   • MAX
   • MIN
   • MINGIN
   • MOD

7. Which is not an advantage of using models?

   • Is cheaper than doing the real thing, e.g. car crashes
   • Models usually give only approximate answers
   • They can be used for making predictions
   • Training people to do dangerous jobs without any risk

8. Why are computer models sometimes unreliable?

   • Real life often has unpredictable events occur
   • The models might be processing too much information
   • The rules were probably entered incorrectly
   • They have been run on old computers

9. A spreadsheet model might be tested by .......

   • changing the input data and looking at the predictions
   • changing the rules used and looking at the predictions
   • comparing the model predictions with real life results
   • It is a computer model and doesn't need testing

10. Spreadsheets are good at answering what-if questions.

    • You can change input values and check the results
    • You can change the rules and check the results
    • You can change the rules and data and check the results
    • None of the above will work

Quiz written by D. Daish