Question

when creating a pivottable report, the active cell should be positioned ______.

• anywhere in the range that contains the data
• in cell a1
• anywhere outside the range that contains the data
• there is no active cell in a pivottable report.

Explanation:

Analyze PivotTable creation requirements

When creating a PivotTable in Excel, the application automatically detects the data range to be used for the report. For this automatic detection to work seamlessly, the active cell must be positioned anywhere within the continuous range of cells that contains the source data.

Evaluate the given options

• anywhere in the range that contains the data: Correct. Placing the active cell inside the data range allows Excel to automatically select the entire contiguous table.
• in cell A1: Incorrect. While cell A1 might be part of the data, it is not a requirement to select cell A1 specifically.
• anywhere outside the range that contains the data: Incorrect. If the active cell is outside the data range, Excel will not be able to automatically detect the source data and will prompt an error or require manual range selection.
• There is no active cell in a PivotTable report: Incorrect. An active cell always exists in the spreadsheet interface.

Answer:

• anywhere in the range that contains the data (Correct answer)
• in cell A1
• anywhere outside the range that contains the data
• There is no active cell in a PivotTable report.