562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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:
Britain's Got Talent
Strictly Come Dancing
Good in a post-ironic way
Great British Bake-Off
Feel free to disagree with these comments and figures and use your own!
Create lookup formulae in the yellow cells on the Calculations sheet to show the credibility and multiplier for your chosen show:
These are the results if you win the Great British Bake-Off, for example.
Check this gives the correct data for all possible choices of game show, then save your workbook as With multiplier and close it down.
You can find other training resources for the subject of this exercise here:
25 Aytoun Street