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

below the last row of data in the worksheet

next to the last column of data in the worksheet

above the first row of data in the worksheet

depends on whether the PivotTable is inserted into the current worksheet or a new worksheet and the current location of the cursor

Question

Guest

Computers & Technology

15 January, 01:04

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

below the last row of data in the worksheet

next to the last column of data in the worksheet

above the first row of data in the worksheet

depends on whether the PivotTable is inserted into the current worksheet or a new worksheet and the current location of the cursor

+4

Answers (1)

Know the Answer?

Holden Johnson · Answer 1

depends on whether the Pivot Table is inserted into the current worksheet or a new worksheet and the current location of the cursor.

Explanation:

Pivot tables are short tables with few columns and rows out of the original set of rows and columns. And they are being governed by the report filter, and column labels can also be added, as well as rules can be applied to value, but for formulas, we need to create the formula field. However, it can be placed in the current worksheet or a new worksheet and the current location of the cursor.