WISE OWL EXERCISES
EXCEL EXERCISES
EXCEL EXERCISES
- Creating formulae (5)
- Formatting worksheets (7)
- Basic printing (8)
- Charts (10)
- Absolute references (9)
- Range names (13)
- Conditional formulae (16)
- Conditional formatting (7)
- Basic tables (6)
- Formatting numbers and dates (3)
- Working with dates (1)
- Data validation (6)
- Protection (1)
- Advanced IFs (5)
- Lookup functions (14)
- Advanced lookup functions (9)
- Text functions (1)
- Advanced charts (4)
- Multiple worksheets (1)
- Advanced tables (2)
- Pivot tables (3)
- Advanced pivot tables (3)
- Scenarios (2)
- Data tables (2)
- Array formulae (2)
- Building models (2)
- Masking (2)
- Cashflow calculations (1)
- Investment appraisal (1)
Excel exercises on LOOKUP FUNCTIONS
This page lists the 14 exercises about Lookup functions in Excel on our website:
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Lookup functions |
| Level: | Relatively easy |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values using Poohsticks. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Use Vlookup functions in Microsoft Excel 2007 to calculate a total labour bill for different rates. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Use Vlookup functions in Microsoft Excel 2007 to quickly calculate car tax bands for a list of vehicles. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Create database lookup functions in Microsoft Excel 2007 to return specific items from a list. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Using a Lookup Table To display a curry rating in text. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Using a VLOOKUP to display a text message (dog jacket size). |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Using exact match look-ups to search on ISBN codes. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Using exact match on site codes to return matching data. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Use Vlookup functions in Microsoft Excel 2007 to create an enquiry system for a simple database. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Using lookup formulae to calculate staff bonuses. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Using a lookup table to calculate different discounts. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Use a vlookup function in Microsoft Excel 2007 to calculate unit costs based on order quantities. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Lookup functions |
| Level: | Harder than average |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Using an exact match lookup and HLOOKUP with music exam data. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Lookup functions |
| Level: | Harder than average |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values - Teletubbies. |
You can search our full list of Excel exercises here, or why not have a look at our other Excel training resources?
This page has 0 threads
Add post