Work for Mr Ali's Classes
Lesson Aims
Be able to conditional format a spreadsheet
Be able to protect a worksheet
Be able to validate data on a spreadsheet
Task 1
Download the spreadsheets below and practice Conditionally formatting the spreadsheet and protecting cells within the spreadsheet
Task
Download the worksheets below and complete the tasks
Example completed task
Help on formulas
You need to download the spreadsheet worksheets below and then complete the task sets in MS Excel.
Lesson Aim
Task
Download the worksheets below and complete the tasks
Extension
Lesson Aim
Introduce Spreadsheet Terminology
Learn to Create Formulas in Spreadsheets
Tasks
Download the files below and work through the exercises
Extension