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

Question

Quizplus · Accepted Answer

The active cell should be positioned anywhere in the range that contains the data to ensure that Excel recognizes the data range for creating the PivotTable.

When Creating a PivotTable Report, the Active Cell Should Be