# BIS 155 Week 2 Excel s Advanced Formulas & Functions – Quiz

Week 2 Quiz
(TCO 2) An absolute cell reference: (Points : 2)
(TCO 2) Which of the following best describes a circular reference? (Points: 2)
(TCO 2) =\$E2-G\$4 contains examples of _____ cell references. (Points: 2)
(TCO 2) In Excel, an Argument would be best described by which of the following statements? (Points: 2)
(TCO 2) The MEDIAN function would identify the ____. (Points: 2)
(TCO 2) The MAX function identifies the _____. (Points: 2)
(TCO 2) The NOW function would perform which of the following? (Points:2)
(TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. (Points : 2)
(TCO 2) Arithmetic operations, cell references, and ____can be used in Excel formulas. (Points : 2)
(TCO 2) To simplify entering ranges in formulas, you can use _____. (Points : 2)
(TCO 7) A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year. (Points : 2)
(TCO 2) When calculating a PMT function, the PV is best described by which of the following? (Points : 2)
(TCO 7) Before protecting a worksheet, you should __ the cells that you want users to be able to edit. (Points : 2)

# Our guarantees

Study Acers provides students with tutoring and help them save time, and excel in their courses. Students LOVE us!No matter what kind of essay paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcers. Save more time for yourself. Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.