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:

Planning Period

A defined time frame over which planning activities, including forecasts, resource allocation, and scheduling, are conducted.

Transportation Method

A linear programming technique used to find the most efficient and cost-effective way of distributing products from several suppliers to multiple destinations.

Linear Programming

A mathematical method for determining the best outcome in a model whose requirements are represented by linear relationships, widely used in operations research and economics to maximize or minimize an objective function.