Sum

=A1+A2+A3+A4+A5+A6+A8+A9+A10
=sum(A1:A10)

• What is the difference between the 2 formula?
• Which is better?
• Why?

Self Marking Spreadsheet

Practical uses of Excel and using speed techniques such as copy down.
Self Marking Spreadsheet Task

Copy Down

On the corner the white cross to change to a black cross

Then pull the formula down

Function Magic Task

Practice more functions (Average, Min, Max, Count)
Function Magic Spreadsheet Task

If Function

Change a cell’s contents depending on a certain condition

More Detailed Explanation

Insert Row

or right click the row number (4)

Youtube Video Help Second half shows how to insert multiple rows

Absolute References

$ (the dollar sign) anchors the following character ...
so it doesn't change when you copy down.

Extra Task – Brain Teaser

Create a single formula to calculate all the times tables

Answer But don’t cheat yourself. Why not try solving it with a class mate first.

See Also

Geek Link Interesting Resource

Range Names

• Can make it easier to understand formula
• are an alternative to absolute references

How to create range names

Google: Excel Range Names (… About.com is recommended)