EXCEL EXERCISE #3: Mortgage Worksheet
1. Enter the labels below in the cells indicated.
A1: MORTGAGE CALCULATION TABLE
A4: House Price
A5: Down Payment
A6: Amount Borrowed
A8: Monthly Payments
A9: Total Amount Paid
A12: Breakdown of Payment:
A13: Payment Period
A14: Principal Paid
A15: Interest Paid
D6: Interest Rate
D7: Years
D8: Payment Periods
E4: Terms of
E5: Loan
E9: (months)
2. Bold the text in cells A1, A12, E4, and E5. Select these cells and click on the BOLD button.
3. Center the text in cells E4 and E5. Select these cells and click on the CENTER button.
4. Format the numbers in cells B5 through B9 to show dollars and cents. Follow the steps below.
Step 1: Select cells B5 through B9 by moving the cursor to cell B5, click and
hold down the mouse button, and drag the cursor to cell B9. The cells from B5 to
B9 should now be highlighted (i.e., dark).
Step 2: Open the FORMAT menu.
Step 3: Select the CELLS option.
Step 4: The NUMBER option automatically should be selected (if not, click on
the tab labeled NUMBER).
Step 5: Under the Category label, select the option CURRENCY.
Step 6: Under the Format Codes label, select the format -$1,234.10 which is the
first choice.
Step 7: Click on <OK>.
5. Repeat Steps 1-7 above for cells B14 and B15.
6. Format cell E6 to show percent. Repeat Steps 1-7 above except for Steps 5 and 6, select the
Category label PERCENTAGE. The default is two decimal places, which is fine. Click on OK
1
1. Enter the labels below in the cells indicated.
A1: MORTGAGE CALCULATION TABLE
A4: House Price
A5: Down Payment
A6: Amount Borrowed
A8: Monthly Payments
A9: Total Amount Paid
A12: Breakdown of Payment:
A13: Payment Period
A14: Principal Paid
A15: Interest Paid
D6: Interest Rate
D7: Years
D8: Payment Periods
E4: Terms of
E5: Loan
E9: (months)
2. Bold the text in cells A1, A12, E4, and E5. Select these cells and click on the BOLD button.
3. Center the text in cells E4 and E5. Select these cells and click on the CENTER button.
4. Format the numbers in cells B5 through B9 to show dollars and cents. Follow the steps below.
Step 1: Select cells B5 through B9 by moving the cursor to cell B5, click and
hold down the mouse button, and drag the cursor to cell B9. The cells from B5 to
B9 should now be highlighted (i.e., dark).
Step 2: Open the FORMAT menu.
Step 3: Select the CELLS option.
Step 4: The NUMBER option automatically should be selected (if not, click on
the tab labeled NUMBER).
Step 5: Under the Category label, select the option CURRENCY.
Step 6: Under the Format Codes label, select the format -$1,234.10 which is the
first choice.
Step 7: Click on <OK>.
5. Repeat Steps 1-7 above for cells B14 and B15.
6. Format cell E6 to show percent. Repeat Steps 1-7 above except for Steps 5 and 6, select the
Category label PERCENTAGE. The default is two decimal places, which is fine. Click on OK
1
