This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Excel VBA Macros (52 exercises)
Topic ==>	Functions (1 exercise)
Level ==>	Average difficulty
Subject ==>	VBA training

Create functions to turn feet/inches into kilograms, stones/pounds into metres and then calculate body mass index

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.

Before you can do this exercise, you'll need to download and unzip this file .

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 unzip this file to see the answers to this exercise, although please remember this is for your personal use only.

You can find other training resources for the subject of this exercise here:

This page has 0 threads

Add a new post