Shelly Cashman Excel 365 | Module 4 Textbook Project | Windshore Bank Mortgage

If you directly want to get the project from us then contact us on our Whatsapp. Link is given below,

https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

1. Introduction
To Apply a Theme to the Worksheet 2/2
To Enter the Section and Row Titles and System Date 0/2
In the Mortgage Payment Calculator, the range C5:F5 should be merged and centered.
To Adjust the Column Widths and Row Heights 3/3
To Change the Sheet Tab Name 3/3
2. Creating Cell Names
To Format Cells before Entering Values 0/3
In the Mortgage Payment Calculator worksheet, the nonadjacent range D7, F6:F10 should be formatted using the Currency number format with 0 decimal places, and a Red negative color.
To Enter the Loan Data 3/3
To Create Names Based on Row Titles 3/3
To Enter the Down Payment Amount Formula Using Names 3/3
3. The PMT Function
To Enter the PMT Function 3/3
4. Other Financial Functions
To Deternmine the Total Interest and the Total Cost 3/3
To Enter New Loan Data 3/3
To Enter the Original Loan Data 3/3
5. Using a Data Table to Analyze Worksheet Data
To Enter the Data Table Title and Column titles 3/3
To Create a Percentage Series Using the Fill Handle 3/3
To Enter the Formulas in the Data Table 3/3
To Define a Range as a Data Table 3/3
6. Creating an Amortization Schedule
To Enter Titles and Change Column Widths 3/3
To Create a Series of Integers Using the Fill Handle 3/3
To Enter the Formulas in the Amortization Schedule 3/3
To Copy the Formulas to Fill the Amortization Schedule 3/3
To Enter the Total Formulas in the Amortization Schedule 3/3
To Format the Numbers in the Amortization Schedule 3/3
7. Formatting the Worksheet
To Add Custom Borders to a Range 3/3
To Add Borders to the Varying Interest Rate Schedule 0/3
In the Mortgage Payment Calculator worksheet, cells in the range C13:F24 should be formatted using a right vertical border.
To Add Borders to the Amortization Schedule 0/3
In the Mortgage Payment Calculator worksheet, cells in the range H6:K24 should be formatted using a right vertical border.
To Add a Title to the Worksheet 3/3
To Use Borders and Fill Color to Visually Define and Group the Financial Tools 3/3
8. Highlighting Cells in the Data Table Using Conditional Formatting
To Add a Pointer to the Data Table Using Conditional Formatting 3/3
To Enter New Loan Data 3/3
To Enter the Original Loan Data 3/3
9. Printing Sections of the Worksheet
To Set Up a Worksheet to Print 3/3
To Name and Print Sections of a Worksheet 3/3
10. Protecting and Hiding Worksheets and Workbooks
To Protect a Worksheet 3/3
To Hide and Unhide a Worksheet 3/3
11. Non-graded - Checking Formulas

#samprojects #cengageassignments #SC_EX365_4 #SC_EXCEL #excel_assignments #excel_sam_projects #Module4SamProject #windshore_bank_mortgage #shelly_cashman_excel #SC_EX365_4_FirstLastName_1.xlsx #SC_EX365_4_FirstLastName_2.xlsx