> > >

Excel MCQs

John inserts a PivotTable in a worksheet, as shown in figure 1 of the given image. There are three columns in the data source: Employee, Product and Sales. Now John wants to show the list of products under the employee names as shown in figure 2 of the given image. Where should he double-click on the PivotChart in figure 1, so that he should be able to select the Product column?

On the header of the Employee column.

On the values of the Sum of Sales column.

On the values of the Employee column.

On the header of the Sum of Sales column.

Answer

Correct Answer:

On the values of the Employee column.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it