Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

Excel 2010 exercises
IF AND LOOKUP FUNCTIONS

Click on any Excel 2010 IF and LOOKUP functions exercise below to try it out!

Exercise Level
Use IF functions in Microsoft Excel 2007 to rate movies as a flop or success based on their profit. Easy
Use an If function in Microsoft Excel 2007 to rate the players in a game of poohsticks. Easy
Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values using Poohsticks Easy
Use an If function in Microsoft Excel 2007 to calculate different order totals based on the quantity of items ordered. Standard
Use an If function in Microsoft Excel 2007 to calculate total values based on different charge rates. Standard
Use an If function in Microsoft Excel 2007 to calculate a bonus based on whether targets have been met. Standard
Use a vlookup function in Microsoft Excel 2007 to calculate unit costs based on order quantities. Standard
Use Vlookup functions in Microsoft Excel 2007 to quickly calculate car tax bands for a list of vehicles. Standard
Create database lookup functions in Microsoft Excel 2007 to return specific items from a list. Standard
Use Vlookup functions in Microsoft Excel 2007 to calculate a total labour bill for different rates. Standard
Use Vlookup functions in Microsoft Excel 2007 to create an enquiry system for a simple database. Standard
Pracises using nested =IF to decide on the fine a player gets Standard
Create nested If functions in Microsoft Excel 2007 to categorise lists of data. Hard
Use a nested If function in Microsoft Excel 2007 to translate codes into full text descriptions. Hard
Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values - Teletubbies Hard

These Excel 2010 exercises are provided to allow potential course delegates to assess their suitability for the relevant Wise Owl course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

All content copyright Wise Owl Business Solutions Ltd 2013. All rights reserved.