This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Excel (113 exercises)
Topic ==>	Lookup functions (10 exercises)
Level ==>	Harder than average
Subject ==>	Excel training

Create a VLOOKUP formula to multiply celebrity earnings by a factor depending on which talent contest you have won

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.

Before you can do this exercise, you'll need to download and unzip this file .

This exercise practises the VLOOKUP function. First open the file in the folder shown above: your task is to work out what multiplier you should use on your income, according to which talent show you won:

The aim is to make the yellow cell into a dropdown, so you can choose which show you won

The Shows worksheet contains a range name (also called Shows) which lists out all of the shows you could win. Apply data validation to the CoverComp range on the Cover sheet, so that you can only choose one of the items in this Shows range. The settings you should choose are as follows:

If you type in the range name in the Source box, remember the = sign!

Create a lookup table which contains for each show the credibility it bestows on the winner and the income multiplier it generates. Suggested details are:

Show	Credibility rating	Income multiplier
Love Island	None whatsoever	2.5
Britain's Got Talent	Iffy	2.0
Strictly Come Dancing	Good in a post-ironic way	1.8
Great British Bake-Off	Good	1.2
Naked Atraction	Negative impact	0.8