Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
546 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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
Search our website
We also send out useful tips in a monthly email newsletter ...
Software ==> | Excel VBA Macros (52 exercises) |
Topic ==> | Functions (1 exercise) |
Level ==> | Average difficulty |
Subject ==> | VBA training |
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.
You can find other training resources for the subject of this exercise here:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.