Which Excel Function Averages Cells in a Range Based on a Specified

question 13

Multiple Choice

Which Excel function averages cells in a range based on a specified condition?

• A) AVERAGEIF
• B) AVERAGE
• C) COUNTIF
• D) SUMIF

---

Definitions:

Discounted Payback

is a capital budgeting method that calculates the period of time required for the discounted cash flows from a project to recoup its initial cost.

Wholesale Book Outlet

A distributor that sells books in large quantities at discounted prices, primarily to retailers, libraries, and educational institutions.

Sit-down Restaurant

A dining establishment where customers are seated and served by waitstaff, offering a more formal dining experience compared to fast-food or counter-service restaurants.

Net Present Value

A financial metric that calculates the present value of the expected equity of cash flows, considering the time value of money.