Edwin Wants to Insert a Pivot Chart to Summarize Raw

question 4

Multiple Choice

Edwin wants to insert a Pivot Chart to summarize raw data.Which of the following combination of clicks/selections/entries should he use to do this?

• A) Select Cell > Insert > PivotChart > OK
• B) Select Cell > Insert > Recommended PivotTables > OK
• C) Select Cell > PivotTable Tools > Analyze > PivotChart > Select a chart > OK
• D) Select Cell > Insert > Table > Create Table dialog box > Fill data in Where is the data for your table? box > OK

---

Definitions:

Net Taxes

The total amount of taxes collected by the government minus any transfer payments and subsidies.

GDP

Gross Domestic Product, a measure of the economic performance of a country, evaluating the total value of all goods and services produced over a specific time period.

Government Purchases

Expenditures by government agencies on goods and services that directly satisfy public consumption or are invested in public infrastructure.

Full Employment

An economic condition where every available workforce is employed in the most effective way achievable.