Which Is an Effective Way to Change a SUM of Price

question 29

Multiple Choice

Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?

• A)Select the appropriate cell in the PivotTable and type =AVERAGE(Price).
• B)Click the AVERAGE button on the Analyze tab.
• C)Right click the appropriate cell and select AVERAGE from the mini-tool bar.
• D)Click the field's arrow in the VALUES area and select Value Field Settings.

---

Definitions:

Internal Rate

Often referred to as the internal rate of return (IRR), it is the discount rate that makes the net present value (NPV) of all cash flows from a particular project zero.

Net Present Value

A financial metric used to evaluate the profitability of an investment or project, calculated by subtracting the present value of cash outflows from the present value of cash inflows over a period of time.

Payback Period

The amount of time it takes for an investment to generate cash flows sufficient to recover its initial cost.

Cash Receipts

Money received by a business during a given period, from operations, investments, and financing.