Microsoft Excel
Reference functions exercise
Relatively easy
This Microsoft Excel REFERENCE FUNCTIONS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl EXCEL BUSINESS MODELLING course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Exercise: Choosing type of celebrity - look up
A full answer to this exercise is provided as part of the training course!
| 1) | Download the files needed to start this exercise: exercise-673.zip (and click here if you experience any problems unzipping this file after downloading it). |
| 2) | 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. |
| 3) | Create a new worksheet listing the different possible types of celebrity and the fee multiplier for each - here is a suggestion: |
You can add your own celebrity types if you like ...
|
|
| 4) | Add a new input cell to the Inputs sheet, allowing you to choose a type for your celebrity: |
Use data validation to limit the choices to those in the first column of your factors spreadsheet
|
|
| 5) | Amend your revenue calculations to include a celebrity factor: |
You need to put a VLOOKUP formula in the cell shown selected
|
|
| 6) | Check that your formula works for different celebrity types, then save and close the workbook. |
Thank you for showing an interest in this Excel Business Modelling training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.
