Simple Formulae
You will make a spreadsheet today that will accurately perform a calculation with two numbers.
You would have expected the answer to be 10. Did it work? Try changing the numbers in cells A1 and B1. Did you get the answers you expected?
Ready for a bigger challenge?
Activity Time
Try conquering the three levels in the activity called ‘The Gold Mine’ by Simon Haughton. Each level (on separate sheets) has pairs of numbers to perform calculations on. The cells turn gold if the correct formulae are entered to reach the correct answer:
Writing simple formula follow these steps:
Download the worksheet and save it in your class folder.
You will make a spreadsheet today that will accurately perform a calculation with two numbers.
- Open Microsoft Excel and follow these directions to add two numbers together. In cell A1, type the number 2
- In cell B1, type the number 8
- Click in cell C1
- In the formula bar, type this formula =A1+B1
- Press return/enter
You would have expected the answer to be 10. Did it work? Try changing the numbers in cells A1 and B1. Did you get the answers you expected?
Ready for a bigger challenge?
Activity Time
Try conquering the three levels in the activity called ‘The Gold Mine’ by Simon Haughton. Each level (on separate sheets) has pairs of numbers to perform calculations on. The cells turn gold if the correct formulae are entered to reach the correct answer:
- Level 1 – Just addition calculations (+)
- Level 2 – A mixture of addition and subtraction calculations (+ -)
- Level 3 – A mixture of additions, subtractions, divisions and multiplications (+ - / *)
Writing simple formula follow these steps:
- Type =
- Type the first cell reference
- Type the calculation sign + - * /
- Type the second cell reference
- Press return/enter
- Check the answer is sensible
Download the worksheet and save it in your class folder.
|