The Cell Address $R$6 Is An Absolute Cell Reference

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

Donation Page

Support Our Work

Do you appreciate the value this website provides? If so, please consider donating to help keep it running. Your donation will go a long way in helping us continue to provide the same quality of content and services. Every bit helps, and your support is greatly appreciated. Thank you for your generosity.