Question: To create this PivotTable, drag the _ field to the Rows area and the _ field to the Values area?

  1. Total Sales This Year; Total Sales This Year
  2. Total Sales This Year; Market Region
  3. Representative ID Number; Total Sales This Year
  4. Market Region; Total Sales This Year

Answer: The correct answer of the above question is Option D:Market Region; Total Sales This Year