When creating a PivotTable report, the active cell should be positioned ____.
A) anywhere in the range that santains the data
B) in cell A1
C) anywhere outside the range that santains the data
D) There is no active cell in a PivotTable report.

Question

Quizplus · Accepted Answer

The active cell should be positioned anywhere within the range that contains the data you want to analyze with the PivotTable. This allows Excel to automatically detect the data range for the PivotTable creation.

When Creating a PivotTable Report, the Active Cell Should Be