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
Tag: Vlookup
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