SC_EX_4_Mortgage_RileyKneisl_Report_2
xlsx
keyboard_arrow_up
School
Minnesota State Community and Technical College *
*We aren’t endorsed by this school
Course
1124
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
xlsx
Pages
3
Uploaded by SuperHawk2942
Shelly Cashman Excel 2019 | Module 4: Textbook Project
Riley Kneisl
GE ver. 17.0.1-rc0000
1.
To Apply a Theme to a Worksheet
3/3
To Enter the Section and Row Titles and the System Date
3/3
To Adjust the Column Widths and Row Heights
3/3
To Change the Sheet Tab Name
3/3
2.
To Format Cells Before Entering Values
3/3
To Enter the Loan Data
3/3
To Create Names Based on Row Titles
3/3
To Enter the Loan Amount Formula Using Names
3/3
To Enter the PMT Function
3/3
To Determine the Total Interest and Total Cost
3/3
To Enter the Original Loan Data
3/3
3.
To Enter the Data Table Title and Column Titles
3/3
To Create a Percentage Series Using the Fill Handle
4/4
To Enter the Formulas in the Data Table
4/4
To Define a Range as a Data Table
4/4
4.
To Change Column Widths and Enter Titles
4/4
To Create a Series of Integers Using the Fill Handle
4/4
To Enter the Formula in the Amortization Schedule
4/4
Copy the Formulas to Fill the Amortization Schedule
4/4
To Enter the Total Formulas in the Amortization Schedule
4/4
To Format the Numbers in the Amortization Schedule
4/4
To Add Custom Borders to a Range
4/4
To Add Borders to the Varying Interest Rate Schedule
4/4
To Add Borders to the Amortization Schedule
0/4
To Use Borders and Fill Color to Visually Define and Group the Financial Tools
4/4
To Add a Pointer to the Data Table Using Conditional Formatting
4/4
5.
To Set Up a Worksheet to Print
4/4
6.
To Protect a Worksheet
4/4
7. Non-graded - Formula Checking
SUBMISSION #2 | SCORE IS: 96
OUT OF 100
Project: Mortgage Payment Calculator with Data Table and Amortization Schedule
Creating Cell Names
Using a Data Table to Analyze Worksheet Data
Creating an Amortization Schedule
In the Mortgage Payment Calculator worksheet, cells in the range H20:L20 should be formatted using a Green, Accent 2 color Light Top cell border.
Printing Sections of the Worksheet
Protecting and Hiding Worksheets and Workbooks
Textbook
Mortgage Payment Calculator
Amortization Schedule
Varying Interest Rate Schedule
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help