Microsoft Office
Basic formulae exercise
Average difficulty

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 - telephone call stats

1)	On a new workbook, type in the text and numbers in the same cells as shown below:
	You might need to change the column widths
2)	In cell D2 create a formula using the following information: Calls per hour  =  No. calls / Hours worked
3)	Copy the formula down the column to work out the other Calls per Hour.
4)	In cell E2 create a formula using the following information: Bonus = Calls per Hour *  1.75
5)	Copy the formula down the column to work out the other Bonuses.
6)	In cell B8, create a formula that will add together all the No. calls.
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:     Telephone Call Stats

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

Return to the list of exercises for this topic