Activity 2

Print Press the Print option to print off a task to try in the real Excel program.

Some complex processes

Some of the tasks in this activity will let you practise what you learned in Activity 1. If you need to, look back over the last activity for help with any of the tasks.

Class 5B have just completed their end-of-term exams. The table below shows the marks for each student.

  Maths English French
John 45 45 56
Mary 44 76 65
David 56 34 58
Amy 67 74 80
Ann 46 47 54
  • Enter this information on a worksheet.

The teacher has made mistakes and some of the marks need to be changed. Make the following changes to your worksheet:

  • David’s English mark should be 54.
  • Mary’s Maths mark should be 64.
  • Adam’s marks need to be added. He scored 76 for Maths, 67 for English and 78 for French.
  • John is not part of this class. Delete the row with his marks.
The worksheet is to be made part of a report to parents. The teacher wants to improve the appearance of the worksheet. Carry out the following formatting:
  • Make the subject headings size 16 Times New Roman, bold and underlined.
  • Make the pupils’ names size 14 Times New Roman bold.
  • Widen columns if necessary.