Project Steps:

1. Printing Preparation: Liam wants to print parts of the Loan Calculator workbook. Follow these steps for proper setup:
   • Set row 3 as the print title for the worksheet.
   • Define the print area as F3.
2. Hide the Properties Worksheet: Liam wishes to keep this worksheet private, so ensure it’s hidden.
3. Correct Errors in the Equipment Loan Worksheet:
   • Navigate to the Equipment Loan worksheet, which details a loan for computer network equipment.
   • Ensure all error types are being checked in Excel, and fix the following:
     • For cell C2, display the error solutions and choose “convert to number.”
     • In cell I9, trace precedents to the formula (this formula should calculate the product of the scheduled payment amount and the number of scheduled payments). Correct the error if present.
4. Highlight Optional Payments: Draw attention to the optional extra payments in C10by applying a thick outside border using the Orange, Accent 3 shape outline color.

The workbook should look like the provided final figures. Save your changes, close the workbook, and submit the project according to the instructions on the SAM website.

Final Figure 1: Loan Calculator Worksheet

Final Figure 2: Equipment Loan Worksheet