Setting up, editing, formatting and using worksheets

 

Disco Task (2012 new version*)

Skills covered:

  • enter data
  • widen columns
  • text formatting
  • wrap text
  • merge cells
  • rename tabs
  • delete worksheets
  • insert worksheet
  • copy worksheet
  • multiplication formula
  • SUM formula
  • format as currency
  • insert rows
  • absolute cell reference
  • insert footer
  • borders
  • cell alignment
  • format date
  • find and replace
  • Undo
  • format painter
  • sort data

* The 2003 task is the old version. The 2007 task has been rewritten and updated.

download file

(Excel 2010)

download file

(Excel 2007)

 

download file

(Excel 2003)

 

Burgers Task (2012 brand new version*)

Skills covered:

  • rename tabs
  • delete worksheet
  • column widths
  • text formatting
  • SUM, AVERAGE, MIN, MAX formula
  • replicate formula
  • cell formatting - colours, borders, underline
  • insert rows
  • merge and centre
  • decimal places
  • select non adjacent columns
  • column chart
  • change chart style
  • change chart colour
  • add titles, axis labels
  • move, resize chart
  • undo, redo

* this is NOT the same as the 2003 version of the burgers task. It is a completely new task.

download file

(Excel 2010)

download file

(Excel 2007)

 

absolute cell reference video tutorial

burgers.xls

 

Teddy Tots Greetings Cards Task

Skills covered:

  • Create a structure and layout within a spreadsheet application
  • Enter a list of prices into a spreadsheet
  • Write simple formula with a single operator
  • Write a SUM function using a cell range
  • Format data to currency
  • Use appropriate number of decimal places
  • Write a formula to calculate a percentage
  • Ensure work fits on one A4 sheet
  • Set gridlines to show on printing
  • Set row and column headers to show on printing
  • Show formulas

 

download file

(Excel 2010)

download file

(Excel 2007)

download file

(Excel 2003)

 

Car Sales

Skills covered:

  • Write a SUM formula
  • Write a formula to calculate percentages
  • Format cells as a percentage
  • Format cells to 1 decimal place
  • Write and use an absolute cell reference
  • Replicate formulae
  • Write a formula to calculate the differences between to different percentages
  • Ensure work fits on one A4 sheet
  • Add name to footer
  • Set gridlines to show on printing
  • Set row and column headers to show on printing
  • Show formulas

 

download file

(2010)

download file

(2007)

download file

(2003)

absolute cell reference video tutorial

car sales.xls

absolute cell reference video tutorial

car sales answers.xls

 

Ringtones Task

Skills covered:

  • Setting up a basic spreadsheet
  • Basic formulae
  • Basic functions
  • Basic formatting
  • Format painter
  • Formatting currency
  • Merging cells
  • Adding and removing toolbars
  • Freezing panes
  • Hiding a column
  • Creating a copy of the workbook
  • Switching between windows
  • Saving as a template
  • IF formula
  • Column chart
  • Chart formatting
  • Setting printing options
  • Find and replace tool
  • Sorting data in a table

 

download file

2007

download file

2003

 

absolute cell reference video tutorial

ringtones.xls

Skiing Task

Skills covered:

  • Setting up a spreadsheet
  • Basic formula and functions
  • Formatting a spreadsheet
  • Inserting rows
  • Borders
  • Headers and footers
  • Printing options
  • Sorting data
  • Hiding a column

 

download file

Suitable for all versions

absolute cell reference video tutorial

skiing.xls

Supermarket Comparisons Task

Skills covered:

  • Setting up a spreadsheet
  • Basic formula and functions
  • Formatting a spreadsheet
  • Resizing columns
  • Footers

 

download file

Suitable for all versions

Groovy Music

Skills covered:

  • merge cells
  • wrap text
  • align titles
  • basic formulae
  • basic functions
  • formatting cells
  • borders
  • gridlines
  • sort data
  • auto filter
  • footers
  • hiding cells
  • freeze pane
  • print area
  • show formulas
  • IF formula
  • VLOOKUP
  • charts
  • absolute cell reference

 

download file

Suitable for all versions

Online auctions

This spreadsheet exercise provides students with an opportunity to practise:

  • adjusting column widths
  • basic formatting and cell alignment
  • inserting new columns and rows
  • MIN, MAX and AVERAGE formulae

Extension tasks are provided

Contributed by Jon Bridgeman of Finham Park School

absolute cell reference video tutorial

auctions.xls

(2003)

Spreadsheet test

A test which should take most of an ICT lesson.

A good way to check the level of your students' skills

download file

test instructions

download file

test marksheet

download file

completed spreadsheet

 

Suitable for all versions