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.
The workbook in the above folder allows you to calculate someone's BMI (body mass index) from imperial measurements:
You could type your name into C2 if you want to use your data
Note that the workbook contains a module containing some built-in constants, to make life easier:
'number of kg in one pound
Const KgRate As Double = 0.45359237
'number of pounds in one stone
Const PoundsInStone As Integer = 14
'number of inches in one foot
Const InchesInFeet As Integer = 12
'number of centimetres in an inch
Const CmsInInch As Double = 2.54
Although you know there are 12 inches in a foot, it makes for clearer coding if you use constants instead.
Write as many of the following functions to go in the pink cells shown above as you have time for:
A function to turn inches and feet into metres, to be used to calculate cell C7
A function to turn stones and pounds into kilograms, to be used to calculate the figures in column E
A function to turn height in metres and weight in kilograms into Body Mass Index, using the formula (Weight in kilograms) / (Height in metres squared)
As a guideline, your BMI should be about 20-25. Anything over 25 is considered overweight.
Save this workbook as BMI, and close it down.
25 Aytoun Street