Syllabus Detail

  • Simple formulae (addition, subtraction, multiplication and division) 11 GEN

Background

 

Basic Formula: [+] Addition

  • To add cell values together, use the + character
  • Example: Cell A3 must equal the sum of B1 and D9
  • Formulae: = B1 + D9

 

Basic Formula: [-] Subtraction

  • To subtract a cell's value from another call, use the - character
  • Example: Cell F5 must equal the sum of D3 minus A6
  • Formulae: = D3 - A6

 

Basic Formula: [*] Multiplcation

  • To multiply the values of two or more cells, use the * character
  • Example: Cell C4 must equal the product of H8 and J4
  • Formulae: = H8 * J4

 

Basic Formula: [/] Division

  • To divide a value by another cell's value, use the / character
  • Example: Cell B9 must equal the value of E5 divided by E3
  • Formulae: = E5 / E3

 

Further Research

  • Excel formulae cheatsheet by PCWorld here
  • Excel functions and formulas list by Tech On The Net here
  • Watch Excel Spreadsheet Basics on YouTube here

 

Worksheet and Practice (yet to be added)

Found an error or have an enhancement? Please let us know via this contact form