Spreadsheets & Modelling

13 min read

Cells and formulae, functions, relative and absolute references, and using models.

Spreadsheets handle numbers, perform calculations and build models.

Cells and formulae

Data goes in cells referenced by column and row (e.g. B3). A formula starts with $=$ , e.g. =A1+A2. Functions are built-in calculations:

=SUM(A1:A5) adds a range.

=AVERAGE(A1:A5) finds the mean.

=IF(B1>50,"Pass","Fail") makes a decision.

=MAX, =MIN, =COUNT.

Read the full note — free

Create a free account to read this note in full. Every free account gets 2 complete revision notes — no card needed.

More Information And Communication Technology notes

Computer Systems & Storage

Input, Output & Data Handling

Networks & the Internet

Databases

← Information And Communication Technology notes

Edexcel IGCSE·Information And Communication Technology·IGCSE ICT