13
QuizMultiple Choice

Pivot Tables and Pivot Charts — Unit test

Question 13 • Computer Applications - Office 2016 - EL3520 A

When a user inserts a PivotTable, where will it be inserted?

Answer
A
below the last row of data in the worksheet
B
next to the last column of data in the worksheet
C
above the first row of data in the worksheet
D
depends on whether the PivotTable is inserted into the current worksheet or a new worksheet and the current location of the cursor

Explanation

When you insert a PivotTable, you can choose to place it on a new worksheet or on an existing worksheet. If you choose the current worksheet, its location depends on the cell location you specify, such as the cursor’s current position. Therefore, the correct choice is “depends on whether the PivotTable is inserted into the current worksheet or a new worksheet and the current location of the cursor.”

AI-written and checked against the verified answer.