Online Course Support | Problem Solving with Excel

In the list below what are the correct steps for creating a pivot table?

 

  1. Click on the Pivot table function
  2. Highlight your data
  3. Click on the area where you want the table

  1. Highlight your data
  2. Click on the Pivot table function
  3. Click on the area where you want the table placed
  4. Drag the items from the list to the filter, row or column

  1. Highlight your data
  2. Right click
  3. Select Pivot table
  4. Click on the area where you want the table placed
  5. Drag your items from the list to the filter, row or column

  1. Click on the Pivot table function
  2. Highlight your data
  3. Click Ctl +Shift+All
  4. Click on the area where you want the table placed
  5. Drag your items from the list to the filter, row or column
 
 

Correct. First you highlight your data, next you click on the Pivot table function, then click on the area where you want to place your table and finally drag the items from the list to the filter, row or column.

Similar Posts