In Google Sheets, which option completes the path to create a pivot table?

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

Answer: (B)

When you’re adding a pivot table in Google Sheets, you start by inserting a new object. The Insert menu is where you find options to add new elements to your sheet, including pivot tables. So the quickest path is Insert, then Pivot table, then Create. This sequence opens the pivot table setup where you can select the data range and choose where the new pivot table will live. After creation, you’ll use the Pivot table editor to place fields into Rows, Columns, Values, and Filters to build your analysis. Other menus aren’t designed as the starting point for creating a pivot table, so they don’t fit the flow as well.