# CIS 2010 sierra Pacific commu

Sierra Pacific Community College District (SPCCD) consists of four individual community colleges. The workbook for this project includes an amortization schedule for student loans and a fee and credit hour summary for several departments.

[Student Learning Outcomes 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7]

File Needed: SierraPacific-02.xlsx (Available from the Start File link.)

### Skills Covered in This Project

• Name cell ranges.
• Create and copy formulas.
• Set mathematical order of operations.
• Use absolute references in formulas.
• Insert the current date as a function.
• Use the PMT
• Audit formulas.
• Use SUMIF and SUMPRODUCT.

NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.

1. Set range names for the workbook.

2. Enter a PMT function.

1. Figure 2-91-Mac Pv argument is negative in the PMT function
3. Create a total interest formula.

4. Create the total principal formula and the total loan cost.
5. Set order of mathematical operations to build an amortization schedule.

6. Fill data and copy formulas.

7. Build a multiplication formula.

8. Use SUMIF to calculate fees by department.

9. Copy a SUMIF function.