Example assignment for Spreadsheet Unit
Category: Advanced 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