Question: The SUMIF function combines the SUM function with the logical criteria component of the IF function.

Answer: true

Question: An IF function can test if monthly revenue is above or below average and display “Yes” or “No” in the cell.

Answer: true

Question: The answer to the mathematical expression 3 + (2 + 4) * 4 is 27.

Answer: true

Question: The cell address $R$6 is an absolute cell reference.

Answer: true

Question: The PMT function assumes the borrower makes regular payments and the loan has a constant interest rate.

Answer: true

Question: A cell displays the result of the formula and the Formula bar displays the formula.

Answer: true

Question: In Excel, a worksheet is also referred to as a spreadsheet or a sheet, and you can use these terms interchangeably.

Answer: true

Question: VLOOKUP and HLOOKUP are examples of LOOKUP functions.

Answer: true

Question: A “print title” is a row or column of data that is repeated on each printed page.

Answer: true

Question: By default, Excel 2016 workbooks are saved as .xlsm files.

Answer: false