William Parker School
Home
>>
Subjects
>>
ICT
>>Learning to use Excel
Excel Practice
For each exercise there are images of the example data and the target result. The original Excel file and help or instructions can be downloaded.
tall buildings
: Only formatting is required, no calculations
fuel consumption
: Only division required. The rest is formatting
invoice
: Multiplying and adding needed. Replication optional
burger bar
: Multiplying and adding needed. Replication optional
four kinds of graphs
: Column, pie, scatter with trend line
heart rate
: A challenging graph
show time
: Introducing some simple functions
easter bonus
: Opportunity to try semi-absolute cell references
car hire calculations
: Date calculations and lookup tables
mark book
: More functions and lookups
pivot tables
: Coming soon