Microsoft Excel
Number formatting exercise
Harder than average exercise

This Microsoft Excel NUMBER FORMATTING 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: Wacky Races Qualifying - Conditional Formats Including Functions

A full answer to this exercise is provided as part of the training course!

1) Download the files needed to start this exercise: exercise-241.zip (and click here if you experience any problems unzipping this file after downloading it).
2) Calculate the final qualifying time for each of the Wacky Racers by taking the average of the two sessions.
3) Apply the following conditional formats:
  • The fastest final time should appear in green text
  • Final times slower than the average appear in red text
Training exercise hint The fastest time will be the MINIMUM of the final times.
4) The final answer should look something like this:
Exercise screen-shot 397 Why do Dastardly and Muttley never win?
5) Save the file with the same name.

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.

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