WGU C268 Spreadsheets 100% Pass
Question 1 Main Concept ✔✔Payment How to find Interest Amount How to find Principal Amount How to find Balance Amount Total Amount Paid Total Interest Paid Sum Check Calculation
How to find monthly interest amount? ✔✔Previous balance X Monthly Interest Rate
How to find monthly principal amount? ✔✔Monthly payment - monthly interest amount
How to find balance amount? ✔✔Previous balance - principal
How to find total amount paid? ✔✔Payment times term (months)
- / 2
How to find total interest paid? ✔✔Add all of the monthly interest charges
How to do Sum Check Calulation? ✔✔Total amount paid - initial balance (Checking to make sure the result for total interest paid is correct)
Question #2 Main Concept ✔✔H Look Up V Look Up AND OR IF
How to do we use H look up? Why do we use it? ✔✔We use it to transfer table data into the active spreadsheet.
=HLookup(what were looking up, where the information lies, which row we are extracting the information from, )
How do we use the AND function? ✔✔AND(One condition, another condition)
- / 2