WGU C268 Spreadsheets with Complete Solution
WGU C268 Spreadsheets with Complete Solution 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) 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) How do we use the OR function? =OR(One condition, another condition) How do we use the IF function? IF(logical test, value if true, value if false) Comments section on four J's painting =IF(AND(E16=C16),"Good Job",IF(H161,"Poor Quality",IF(E16C16,"Too Much Time","Poor Quality")))
Información del documento
- Subido en
- 3 de julio de 2023
- Número de páginas
- 5
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
