There are a number of functions and formulae that you must be able to use confidently. This page contains exercises to help you consolidate your abilities and practice using the functions and formulae that you will need in your exam.

This is what the syllabus says you must be able to do:
spreadsheetsyllabus1.pngspreadsheetsyllabus2.png

Spreadsheet Basics

SP1Intro.png
SP1Intro.png

Task 1: Sales.csv
Task 2: Pay.csv
Task 3: Project.csv
Task 4: ChristmasCharts.xls
Task 5: Staff.csv
blue-b.gif
blue-b.gif

VLookUp

Using Excel to look up values in a table of data.
Starter:
For this lesson you will need
(right)
spreadsRev1.png
spreadsRev1.png


blue-b.gif
blue-b.gif