1. What function in Excel can be used to calculate the monthly payment of a loan with a fixed interest rate? - A) SUM() - B) PMT() - C) AVG() - D) MAX() Answer: B) PMT() Rationale: The PMT function is used to calculate the payment for a loan based on constant payments and a constant interest rate. 2. In a spreadsheet, what does the term 'relative reference' refer to? - A) A reference that does not change when the formula is copied to another cell. - B) A reference that adjusts to its new location when the formula is copied to another cell. - C) A direct link to a web page. - D) A fixed point on a chart. Answer: B) A reference th