Which menu path leads to the creation of a pivot table?

• A. Data -> Create pivot table
• B. View -> Pivot
• C. Tools -> Pivot table
• D. Insert -> Pivot table -> Create

Answer: (D)

Creating a pivot table starts with choosing the option that inserts a new pivot table, then proceeding to configure it. The sequence Insert -> Pivot table -> Create matches the standard workflow: you first insert a new pivot table, then go to the Pivot table option to specify its settings and finally confirm the creation. This makes the action explicit and direct.

The other paths don’t fit the typical creation flow: View is about changing what you see, not about creating new data analysis objects; Tools usually houses utilities rather than the primary creation command for pivot tables; Data paths often involve data operations, but the explicit final step to create a pivot table isn’t usually under Data.