# Microsoft Excel 2010 training exercises | IF and LOOKUP functions

Showing exercises 1-15 (out of 15)

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Relatively easy |

Course: | |

Exercise: | Use IF functions in Microsoft Excel 2007 to rate movies as a flop or success based on their profit. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Relatively easy |

Course: | |

Exercise: | Use an If function in Microsoft Excel 2007 to rate the players in a game of poohsticks. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Relatively easy |

Course: | |

Exercise: | Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values using Poohsticks. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Average difficulty |

Course: | |

Exercise: | Use Vlookup functions in Microsoft Excel 2007 to calculate a total labour bill for different rates. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Average difficulty |

Course: | |

Exercise: | Use an If function in Microsoft Excel 2007 to calculate total values based on different charge rates. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Average difficulty |

Course: | |

Exercise: | Use Vlookup functions in Microsoft Excel 2007 to quickly calculate car tax bands for a list of vehicles. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Average difficulty |

Course: | |

Exercise: | Create database lookup functions in Microsoft Excel 2007 to return specific items from a list. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Average difficulty |

Course: | |

Exercise: | Use an If function in Microsoft Excel 2007 to calculate a bonus based on whether targets have been met. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Average difficulty |

Course: | |

Exercise: | Pracises using nested =IF to decide on the fine a player gets. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Average difficulty |

Course: | |

Exercise: | Use Vlookup functions in Microsoft Excel 2007 to create an enquiry system for a simple database. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Average difficulty |

Course: | |

Exercise: | Use an If function in Microsoft Excel 2007 to calculate different order totals based on the quantity of items ordered. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Average difficulty |

Course: | |

Exercise: | Use a vlookup function in Microsoft Excel 2007 to calculate unit costs based on order quantities. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Harder than average |

Course: | |

Exercise: | Use a nested If function in Microsoft Excel 2007 to translate codes into full text descriptions. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Harder than average |

Course: | |

Exercise: | Create nested If functions in Microsoft Excel 2007 to categorise lists of data. |

Category: | Excel 2010 |

Topic: | IF and LOOKUP functions |

Level: | Harder than average |

Course: | |

Exercise: | Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values - Teletubbies. |

EXCEL 2010 EXERCISES

- Formatting your work (7)
- Basic formulae (5)
- Conditional formatting (5)
- Number formatting (1)
- Printing (5)
- Validation and protection (5)
- Range names and absolute references (9)
- IF and LOOKUP functions (15)
- Advanced lookup functions (6)
- Basic tables (4)
- Pivot tables (2)
- Charts (7)
- Building models (2)
- Cashflow calculations (1)
- Investment appraisal (1)
- Array formulae (2)
- Scenarios (1)
- Data tables (2)
- Masking (2)
- Dates and times (1)

ALL CATEGORIES

- EXERCISES HOME PAGE (674)
- Access 2010 (66)
- Access VBA Macros (17)
- Advanced VBA (26)
- ASP.NET MVC (0)
- ASP.NET webforms - C# (25)
- ASP.NET webforms - VB (27)
- Excel 2010 (83)
- Excel 2013 (7)
- Excel VBA Macros (38)
- Power BI - Excel 2013 (23)
- PowerPivot 2010 (26)
- Report Builder 3.0 (42)
- SQL (75)
- SSAS - multidimensional (21)
- SSAS - tabular (0)
- SSIS Integration Services (18)
- SSRS Reporting Services (53)
- Visual Basic 2010 (42)
- Visual C Sharp 2010 (65)
- WPF - Visual C# (20)