Paper 3 Spreadsheets

ICT IGCSE Practical – Revision Presentation
Spreadsheets
• 20.1 Create a Data Model
• 20.2 Test the Data Model
• 20.3 Manipulate Data
Chapter 20: Data Analysis




• 20.4 Present Data




WWW.YAHMAD.CO.UK

, ICT IGCSE Practical – Revision Presentation
Spreadsheets
Cell References

Columns
Yellow Cell Reference
Chapter 20: Data Analysis




– B2

Green Cell Reference –
Column D3
Rows
Reference G

This is a range of cells. More than one
cell has been selected. G6:G11

A range will be typically used when you
From are calculating values from a number of
Row 6 cells.
To
11

WWW.YAHMAD.CO.UK

, ICT IGCSE Practical – Revision Presentation
Spreadsheets
Named cells >> Right Click on the Cell >> Select Define Name >> Enter New Name for Cell
Chapter 20: Data Analysis




Named ranges >> Right Click on the Cell >> Select Define Name >> Enter New Name for Range




WWW.YAHMAD.CO.UK

, ICT IGCSE Practical – Revision Presentation
Spreadsheets
Formatting

Adjusting Text formatting including
Column and alignment and wrapping.
Rows
Chapter 20: Data Analysis




Merging Cells




Borders and
Shading


Currency



WWW.YAHMAD.CO.UK