Which of the Following Is True

question 23

Multiple Choice

Which of the following is true?

• A)You can create a pivot table from the data in an Excel Data Model,but you must first ensure that Power Pivot is loaded.
• B)You can create a pivot table from the data in an Excel Data Model even if Power Pivot is not loaded.
• C)If your data are stored in an Excel Data Model,not in one or more worksheets,you can view the data regardless of whether Power Pivot is loaded.
• D)Assuming that you want to build a pivot table and Power Pivot has not been loaded,your data should be stored in an Excel Data Model and in one or more worksheets.

---

Definitions:

Price Elasticity

Measures how the quantity demanded of a good changes in response to a change in the price of that good.

Coffee Sales

The volume or quantity of coffee sold within a given period.

Total Revenue

The complete amount of income generated by the sale of goods or services before any costs or expenses are subtracted.

Perfectly Price Elastic

A market situation in which demand or supply responds infinitely to changes in price, meaning any tiny price change results in an infinite quantity demanded or supplied.