modelling features in a spreadsheet

mindmap on the key features of spreadsheets

HideShow resource information
View mindmap
  • modelling features of spreadsheets
    • formula
      • instruction for a computer to preform a specific calculation on some data
      • use cell refernces, cell names, mathematical operators, table names
      • simple formulas can look like this C4+C5
      • complex formula can use functions e.g (SUM F5:F9)*costs!D21
    • function
      • standard rountines built in to the computer
      • use reserved word like SUM
      • make complex formulas that are too long for the user to type in
    • variable
      • identifier (cell reference or name)
      • appear in formulas and can be used in what if questions

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »