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: Advanced Excel
Exercise: Use IF functions in Microsoft Excel 2007 to rate movies as a flop or success based on their profit.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Relatively easy
Course: Advanced Excel
Exercise: Use an If function in Microsoft Excel 2007 to rate the players in a game of poohsticks.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Relatively easy
Course: Advanced Excel
Exercise: Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values using Poohsticks.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Average difficulty
Course: Advanced Excel
Exercise: Use Vlookup functions in Microsoft Excel 2007 to calculate a total labour bill for different rates.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Average difficulty
Course: Advanced Excel
Exercise: Use an If function in Microsoft Excel 2007 to calculate total values based on different charge rates.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Average difficulty
Course: Advanced Excel
Exercise: Use Vlookup functions in Microsoft Excel 2007 to quickly calculate car tax bands for a list of vehicles.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Average difficulty
Course: Advanced Excel
Exercise: Create database lookup functions in Microsoft Excel 2007 to return specific items from a list.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Average difficulty
Course: Advanced Excel
Exercise: Use an If function in Microsoft Excel 2007 to calculate a bonus based on whether targets have been met.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Average difficulty
Course: Advanced Excel
Exercise: Pracises using nested =IF to decide on the fine a player gets.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Average difficulty
Course: Advanced Excel
Exercise: Use Vlookup functions in Microsoft Excel 2007 to create an enquiry system for a simple database.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Average difficulty
Course: Advanced Excel
Exercise: Use an If function in Microsoft Excel 2007 to calculate different order totals based on the quantity of items ordered.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Average difficulty
Course: Advanced Excel
Exercise: Use a vlookup function in Microsoft Excel 2007 to calculate unit costs based on order quantities.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Harder than average
Course: Advanced Excel
Exercise: Use a nested If function in Microsoft Excel 2007 to translate codes into full text descriptions.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Harder than average
Course: Advanced Excel
Exercise: Create nested If functions in Microsoft Excel 2007 to categorise lists of data.

Go to exercise ...

Category: Excel 2010
Topic: IF and LOOKUP functions
Level: Harder than average
Course: Advanced Excel
Exercise: Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values - Teletubbies.

Go to exercise ...