Luca Wants to Insert a Pivot Table

question 19

Multiple Choice

Luca wants to insert a pivot table.He clicks on a single cell inside the data set,then proceeds to step X,and finally clicks OK in the dialog box that appears after step 2.What can step 2 be?

• A) Select a pivot table under Pivot Chart & Pivot Tables in the Charts group on the Charts tab.
• B) Click PivotTable on the Insert tab,in the Tables group.
• C) Click Recommended PivotTables on the Insert tab,in the Tables group.
• D) Select a pivot table under Pivot Chart in the Charts group on the Charts tab.

---

Definitions:

Adverse Supply Shock

An unexpected event that suddenly decreases the supply of a good or service, leading to increased prices and reduced quantity.

Price Level

An assessment of the standard prices of goods and services in an economy at a particular moment.

Real GDP

The total value of all goods and services produced by a country, adjusted for inflation or deflation.

Expansionary Gap

A situation in macroeconomics when aggregate output is above potential output, often leading to inflationary pressures.