Find the assignment below
Access to HE – Spreadsheet Example Assignment
Example assignment for Spreadsheet Unit
Level 1 Spreadsheets
Spreadsheets – Conditional Formatting & Protection
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
Spreadsheets Vlookup Formulas
Lesson Aim
- Create Vlookup formulas
- Create Nested IF formulas
- Sort Data tables
Task
Download the worksheets below and complete the tasks
Example completed task
Help on formulas
Spreadsheets – IF formulas
Lesson Aim
- Re-inforce creation of formulas
- Create IF Formulas
- Created Nested IF Formulas
Task
Download the worksheets below and complete the tasks
Extension
Spreadsheet Exercises
Lesson Aim
Introduce Spreadsheet Terminology
Learn to Create Formulas in Spreadsheets
Tasks
Download the files below and work through the exercises
Extension