CGS 2518 FINAL EXAM QUESTIONS WITH VERIFIED ANSWERS

CGS 2518 FINAL EXAM QUESTIONS
WITH VERIFIED ANSWERS
What is the keyboard shortcut to create an absolute reference?
(a)F2
(b)F3
(c)F4
(d)Alt - Answer-(c) F4

The date 8/3/2021 is stored in cell C1. What function is used to extract just 3?
(a)=YEAR(C1)
(b)=MONTH(C1)
(c)=DAYS(B1,C1)
(d)=DAY(C1) - Answer-(d) =DAY(C1)

What function would you use to calculate the total interest paid for the first year of a
mortgage?
(a)CUMIPMT
(b)PMT
(c)PPMT
(d)CUMPRINC - Answer-(a) CUMIPMT

You constructed a loan amortization table with beginning balance, monthly payment,
interest paid, principal repayment, and ending balance columns. If all the formulas are
correct, which is the only column that shows an increase in value throughout the term of
the loan?
(a)Beginning Balance
(b)Monthly Payment
(c)Interest Paid
(d)Principal Repayment - Answer-(d) Principal Repayment

What function would you use to calculate the total number of periods in a loan or
investment?
(a)NPER
(b)RATE
(c)PV
(d)FV - Answer-(a) NPER

You want to apply a subtotal to a dataset containing names, departments, and salaries.
What is the first step you need to do?
(a)Filter the dataset by salaries
(b)Select the function to be used for the subtotal
(c)Insert new rows where you want the subtotal rows within the dataset