Which Spreadsheet Feature Would Allow One to Find the Total

question 15

Multiple Choice

Which spreadsheet feature would allow one to find the total number of customers in a certain region from a list containing details of all the customers of a company?

• A)Goal Seeking
• B)Data analysis
• C)Conditional formatting
• D)Pivot table

---

Definitions:

Future Value

Future value is the value of a current asset at a specified date in the future based on an assumed rate of growth over time.

Present Value

The current worth of a future sum of money or cash flows, given a specified rate of return.

Interest Rate

The percentage of a sum of money charged for its use, indicating the cost of borrowing or the return on savings.

Present Value

The current financial value of a future financial sum or sequences of payments, assessed with a predefined rate of earnings.