Advanced and complex formulas and computations

• Spreadsheet


  A powerful software tool used for organizing analyzing and storing data in a tabular format
• Microsoft excel


  A powerful spreadsheet application software that integrates graphic and data management. It is intended to be used to calculate and add formula, analyze numerical information such as household budgets, company finances, inventories, and more
• Simple formulas


  Those with only one mathematical operation
• Complex formula


  Those that involve more than one mathematical operation
• Elements of a formula

  • = - indicates that what follows is a formula
  • The operator
  • Cell reference
• Parts of a formula

  • Functions - the PI function: 3.1416
  • References - a8 returns the value in cell a8
  • Constants - number or text values enter directly into a formula
  • Operators - caret (^), etc
• Built-in formulas in excel

  • Sum
  • Average
  • Max
  • Min
  • Count
  • If