Which steps insert a Recommended PivotTable and choose Sum of Bonus by Employee?

Which steps insert a Recommended PivotTable and choose Sum of Bonus by Employee?

• A. Data tab, PivotTable, Create New
• B. Insert tab, Tables group, PivotTable
• C. Review tab, Changes group, Pivot
• D. On the Insert tab, in the Tables group, click the Recommended PivotTables button. Click the Sum of Bonus by Employee option. Click OK.

Answer: (D)

Using the Recommended PivotTables feature gives you a quick, guided way to create a PivotTable with a sensible layout based on your data. On the Insert tab, in the Tables group, you find the Recommended PivotTables button. When you click it, Excel shows layout options derived from your fields. Selecting the option that places employees as rows and sums the Bonus field as values (Sum of Bonus by Employee) and then clicking OK inserts the PivotTable with that arrangement. This approach is the fastest way to get a meaningful PivotTable without manually dragging fields into the Rows and Values areas.

Using the Recommended PivotTables feature gives you a quick, guided way to create a PivotTable with a sensible layout based on your data. On the Insert tab, in the Tables group, you find the Recommended PivotTables button. When you click it, Excel shows layout options derived from your fields. Selecting the option that places employees as rows and sums the Bonus field as values (Sum of Bonus by Employee) and then clicking OK inserts the PivotTable with that arrangement. This approach is the fastest way to get a meaningful PivotTable without manually dragging fields into the Rows and Values areas.