Q.1
What name is given to the text at the top of a column?
  • Function
  • Label
  • Sum
  • Value
Q.2
A cell contains a number. This is called a .......
  • input
  • numeric
  • output
  • value
Q.3
A formula is not normally displayed in a cell. It is found .......
  • in the formulae bar
  • in the address bar
  • in the formula bar
  • in the rule bar
Q.4
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
Q.5
Which of these is not a commonly used function?
  • MAX
  • MIN
  • MINGIN
  • MOD
Q.6
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
Q.7
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
Q.8
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
Q.9
Spreadsheets are good at answering what-if questions. Which of the following statements is true?
  • 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
0 h : 0 m : 1 s