What are 3 benefits of using a spreadsheet?
Automatic recalculation
Graphs and charts can be drawn using the data
Replication: Once the data is correctly entered you can drag it down
Spreadsheets can take a long time to complete
What is a cell?
A cell is each individual rectangle in the spreadsheet
A cell is a point in a graph
A cell is a title of a piece of work
What are the 4 main formulae in a spreadsheet?
Add
Subtract
Multiply
Divide
IF
CountIF
What data types may you need when formatting cells?
Currency, number, date, text
Day, month, year, time
Place, food, time, year
A cell reference can be written as follows, (B4) or (G5:M6)
You can make a scatter graph on a spreadsheet
