Q.1
What name is given to the text at the top of a column?
  • Function
  • Label
  • Sum
  • Value
Q.2
A cell contains the characters Total. This is called a .......
  • datum
  • label
  • output
  • result
Q.3
A cell contains a number or date. This is called a .......
  • input
  • numeric
  • output
  • value
Q.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
Q.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
Q.6
Which of these is not a commonly used function?
  • MAX
  • MIN
  • MINGIN
  • MOD
Q.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
Q.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
Q.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
Q.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
0 h : 0 m : 1 s