Exercises
The links below provide access to the various files
that can be used on the course. A set of notes is available
under Notes to guide you through the tasks to perform
with the various data provided.
A simple task to help you get used to moving around
a spreadsheet and entering information in cells
Using sheets effectively and protecting original data
Changing the width of columns, alignment of entries
in cells
Use some simple formulae to make automatic calculations
with your data
Sorting data into order and selecting, or filtering
records to display just those required
Printing [use one of the previous
files]
Producing well laid-out printed material from sheets
[you be provided with data - here's an example]
Creating charts and graphs from data
[this is the original file - if you did data management
then your updated copy wil be more useful]
Using some more formulae to gather data from several
sheets and make calculations then create charts from
just selected data
More exercises: Profits
| Staff
Records | The
College Tea Club | Fantasy
Football League
|
