Which of these is not a formula?
  • =C3+F2*H5
  • =C3-F2*$H5
  • -C3/F2*H5
  • =C3*F2*H5
Models represent real life situations using .......
  • data and analysis
  • data and intuition
  • data and rules
  • data and statistics
Spreadsheet models use ....... to represent rules.
  • cells
  • conditional formatting
  • formulae
  • symbols
The values in the spreadsheet cells act as .......
  • information
  • input
  • macros
  • reports
The formulae in the models act as .......
  • calculations
  • data
  • enquiries
  • processes
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
Spreadsheets are good at doing ....... analysis of data.
  • how-why
  • what-else
  • what-if
  • why-when
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)
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
Predictions made by models are usually .......
  • approximate
  • correct
  • exact
  • wrong
0 h : 0 m : 1 s

Answered Not Answered Not Visited Correct : 0 Incorrect : 0