Q.1
Which of these is not a formula?
  • =C3+F2*H5
  • =C3-F2*$H5
  • -C3/F2*H5
  • =C3*F2*H5
Q.2
Models represent real life situations using .......
  • data and analysis
  • data and intuition
  • data and rules
  • data and statistics
Q.3
Spreadsheet models use ....... to represent rules.
  • cells
  • conditional formatting
  • formulae
  • symbols
Q.4
The values in the spreadsheet cells act as .......
  • information
  • input
  • macros
  • reports
Q.5
The formulae in the models act as .......
  • enquiries
  • calculations
  • data
  • processes
Q.6
The formulae can create output as charts and graphs.
  • Charts and graphs are the only form of output possible
  • Charts and graphs are vital to understand predictions
  • Charts and graphs can improve understanding of results
  • Charts and graphs make the output more accurate
Q.7
Spreadsheets are good at doing ....... analysis of data.
  • how-why
  • what-else
  • what-if
  • why-when
Q.8
A model rule is: profit = number sold x saleprice - cost.
  • A suitable formula might be: =D5x(C5-B5)
  • A suitable formula might be: =D5x(C5/B5)
  • A suitable formula might be: =D5*(C5-B5)
  • A suitable formula might be: =D5^(C5-B5)
Q.9
Models often include many rules because .......
  • a single formula can only handle simple rules
  • real world situations are often very complicated
  • results can be achieved much quicker with more rules
  • the more rules used, the more accurate the results
Q.10
Predictions made by models are usually .......
  • approximate
  • correct
  • exact
  • wrong
0 h : 0 m : 1 s