Spreadsheet Exercise #3

For this exercise, we will use the spreadsheet loans2.xls: The following are step by step instructions to complete this spreadsheet.

This exercise gives you practice in using spreadsheets, but it also demonstrates how a spreadsheet can be used to assist people in decision making. e.g. You are about to purchase a car and are confused by all the payment options. You can enter formulas into a spreadsheet so that you can see the total cost for each option. Another important aspect of this exercise is to learn about the use of Absolute vs Relative References. Make sure to observe the different uses of these two types of references.

Step #1: Formatting Text:


Select the cells B1 through C1 by using the shift key. Then, open the Formatting Menu by clicking the small arrow in the bottom right corner of the Font toolbar. Use the Formatting Menu to Underline and Bold the title. Then, change the colour to Blue and the font size to 16. Next, click on the "Fill" Tab, and Select both a Fill Pattern and a Background Colour.

Step #2: Entering Data:

Step #3: Entering Formulas: (Absolute and Relative References)

Don't forget to use the = sign before entering a formula.
The letters do not need to be capital letters.

Step #4: Entering a Function:


Now you should be finished editing your spreadsheet and it should look something like this:

Spreadsheet Exercise Index Page