Spreadsheets

One exercise will be set. The tasks set will depend on the spreadsheet product in use. The exercise consists of basic and advanced tasks.

Basic Tasks

• Open a spreadsheet file, make changes to it, add rows calculate new values.
• Insert rows and columns -- create a new row or column in a specific place.
• Create a spreadsheet and enter data
  • Numbers
  • Text
  • Formulae
• Format cells -- e.g. size, decimal points, currency, etc.
• Adjust column widths and format columns and rows.
• Sort the spreadsheet
• Use the basic functions of a spreadsheet, such as
  • Totalling
  • Averaging
• Print and save a spreadsheet
• Create a header and footer
• Use Help Functions

Advanced Tasks

• Understand and use absolute and relative cell referencing in formulae.
• Produce different types of charts and graphs from a spreadsheet figures to analyse the data.
• Retrieve graphs from disc
• Print graphs with titles and labels
• Use 3--dimensional graphics
• Move information between spreadsheets
• Work with more than one spreadsheet
• Use integrated software

Assessment

One exercise will be set, which will contain 8--10 tasks.

The five basic tasks must be completed correctly and the advanced tasks must be attempted. The pass mark is 100% for the basic tasks and 50% for the advanced tasks.

45 minutes is allowed for the test.