Back to quiz

6. consists of data about a thing and rules that control what the data does.

  • formula
  • model
  • spreadsheet

7. calculates the smallest value in a range of data

  • MIN
  • MAX
  • IF

8. a function that calculates the total of a range of cells

  • MAX
  • SUM
  • AVERAGE

9. more complicated formulae that are built in to the computer and use words as instructions to work out a calculation

  • varible
  • functions
  • formulae

10. an instruction to a computer to process data in specific cells, using simple mathimatical calculations to find the value of those cells eg C4+D5

  • varible
  • formulae
  • function

11. calculates the largest value in a range of data

  • MAX
  • MIN
  • AVERAGE