Excel | Advanced lookup functions exercise | Excel 2007 choosing type of celebrity - look up

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Software ==> Excel  (151 exercises)
Version ==> Excel 2010 and later
Topic ==> Advanced lookup functions  (9 exercises)
Level ==> Relatively easy
Subject ==> Excel training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Different types of celebrity have different earning powers (politicians command less fees than footballers, for instance) - we want to build this fact into our model.  As a first step, open the workbook in the folder shown above.

Create a new worksheet listing the different possible types of celebrity and the fee multiplier for each - here is a suggestion:

Excel 2010 exercise - Advanced lookup functions (image 1)

You can add your own celebrity types if you like ...

Add a new input cell to the Inputs sheet, allowing you to choose a type for your celebrity:

Excel 2010 exercise - Advanced lookup functions (image 2)

Use data validation to limit the choices to those in the first column of your factors spreadsheet

Amend your revenue calculations to include a celebrity factor:

Excel 2010 exercise - Advanced lookup functions (image 3)

You need to put a VLOOKUP formula in the cell shown selected

Check that your formula works for different celebrity types, then save and close the workbook.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post