Answer in one word:
1. Define PivotTable.
2. How to remove subtotals?
3. What is sorting?
4. How can you remove duplicate value from a column?
Answers
Answer:
mark me plase brainliest i neeeddd
Explanation:
1 ans=A pivot table is a table of statistics that summarizes the data of a more extensive table. This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way. Pivot tables are a technique in data processing.
2ans=Step-1 elect a cell in the range that contains subtotals.
Step-2 On the Data tab, in the Outline group, click Subtotal. The Subtotal dialog box is displayed.
Step-3 Click Remove All.
3ans=Sorting is any process of arranging items systematically, and has two common, yet distinct meanings: ordering: arranging items in a sequence ordered by some criterion; categorizing: grouping items with similar properties.
4ans
Step-1 Select the range of cells that has duplicate values you want to remove. Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.
Step-2 Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates. ...
Step-3 Click OK.