# Excel 2010 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.
This page has 0 threads