You want to create a PivotTable based on the source data below
SELECT ONLY ONE
A. Create a new column summing Sales and Profit
B. Delete the negative numbers in the Profit column
C. Delete the Home category
D. Insert an empty row below Row 105
E. Insert a title for Column B
The correct answer is: E. Insert a title for Column B.
Blank column title is not valid for creating pivot table. To create a pivot table report, must use data that is organised as a list with labeled columns.
All other given options are wrong.