Exercise: Functions for weight, height and BMI

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 answer to the exercise will be included and explained if you attend the Wise Owl course listed below!

Category ==> Excel VBA Macros  (38 exercises)
Topic ==> Functions  (1 exercise)
Level ==> Average difficulty
Course ==> Excel VBA macros
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

The workbook in the above folder allows you to calculate someone's BMI (body mass index) from imperial measurements:

Excel VBA Macros exercise - Functions (image 1)

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:

Excel VBA Macros exercise - Functions (image 2)

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.

This page has 0 threads Add post