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 - Credit payments

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 D2 create a formula using the following information: Payment  =  Cost / Period
3)	Copy the formula down the column to work out the other Payments.
4)	In cell B8, create a formula that will add together all the Costs.
There is a special button on the toolbar for totals.
5)	Copy the total formula across the row to calculate the other column totals.
6)	Save the file with the name:     Credit Repayments

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

Return to the list of exercises for this topic