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:

Departmentalization

The method by which an organization divides its operations into separate units or departments based on function, product, geographic location, or customer base.

Matrix Structure

An organizational structure that combines two or more types of departmentalization, typically project and functional, to facilitate the horizontal flow of information.

Functional Structure

An organizational design where the company is divided into departments based on function or specialization, such as marketing, finance, and human resources.

Organic Structure

An organizational configuration that is flexible, decentralized, and has low levels of formalization, allowing it to adapt quickly to changes.