Microsoft Office
Basic formulae exercise
Harder than average exercise

This Microsoft Office BASIC FORMULAE exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl INTRODUCTION TO EXCEL course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: Basic Formulae - weight loss exercise

1)	On a new workbook, type in the text and numbers in the same cells as shown below:
	You will need to change the column widths
2)	In cell E2 create a formula using the following information: Weekly Loss (kg)  =  (Current - Target) / Weeks
3)	Copy the formula down the column to work out the other Weekly Losses.
4)	In cell F2 create a formula using the following information: Weekly Loss (lb)  =  Weekly Loss (kg) * 2.2
5)	Copy the formula down the column to work out the other Weekly Losses.
6)	In cell B6, create a formula that will add together all the Current (weights).
There is a special button on the toolbar for totals.
7)	Copy the total formula across the row to calculate the other column totals.
8)	Save the file with the name:     Healthy Eating

Thank you for showing an interest in this Introduction to Excel training course!

Return to the list of exercises for this topic