Syllabus Detail
- Simple formulae (addition, subtraction, multiplication and division) 11 GEN
Background
- Spreadsheet software is very good at crunching numbers
- It is capable of many simple and complex calculations
- Some software provide preset templates such as financial sheets for businesses and budget documents for individuals
- Read The Computing Teacher's article on Simple Functions here
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