Everything!!

To print certain things - set print area

To stop cells changing - cell protection

To find the highest

= max(b2:b4)

to find the lowest

= min (b2:b4)

to find the average

= average (b2:b4)

to find the total

= sum (b2:b4)

to subtract

= b2 - b4

to add

= b2+b4

to divide
=b2/b4


Four Labels of a fully labelled chart

x axis
y axis
title
key / legend

IF STATEMENTS!!!

= if (b2>b3, "True", "False")

= if(age >=18, "DRINK!!!!", "No drinking")

=if(age <=16, "No Lottery", if(age >=65, "BINGO!", "Play the lottery!"))

Spreadsheets!

What does Replication mean!?
Copying! (when you copy a formula!)

There are two types of replication (two ways we can copy a formula)

Relative Referencing
* When you copy a formula, the formula will change to suit the new cells it is copied into

Absolute Referencing
Absolute means the formula will not change when replicated and it uses the $$$$$$ to show it is absolute!