> > >

Excel MCQs

What is a quick way of viewing the underlying data of any cell of a PivotTable?

Select a cell, then on the PivotTable - Design tab of the Ribbon, click New Report.

Double-click the cell to display the data in a new worksheet.

Select a cell, then press Ctrl + Shift + D.

Select a cell, then on the PivotTable - Analyze tab of the Ribbon, click Show Detail.

Answer

Correct Answer: Double-click the cell to display the data in a new worksheet.

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