A list containing customer and customer purchase information has the following columns: customer name,location (of the customer,i.e. ,North,South,East,and West),customer income,customer age,and mode of payment during last purchase (cash or card).A pivot table to find the number of customers in each location and containing age,income,and purchase information of customers needs to be created.Where must the "location" field be dropped in the pivot table skeletal structure to create such a table?
A)Report Field
B)Column Labels
C)Row Labels
D)"Values" area

Question

Quizplus · Accepted Answer

Since a pivot table needs to be created summarizing information on the basis of customer region,the "location" field must be dropped in the "Row Labels" region of the skeletal structure.

A List Containing Customer and Customer Purchase Information Has the Following