Click any cell in the sheet, and then click PivotTable on the insert tab. The Excel insert a pivot table for the continuous data in the sheet.Question 26Select one:a.Trueb.False

Pivot tables must show the pivot table on the same sheet as the data, otherwise Excel cannot do pivot charts automatically True False

You can freeze a row or column in order to:Always keep it stationary and in sight while viewing that sheet. Stop it from being included in your calculations.Include data from that section in a pivot table.

Question 1When you create a Pivot Table, your data must be in a Table beforehand.

Where do we find the option of a pivot table?Select one:A.HomeB.DeveloperC.InsertD.Formulas

Q44. Pivot table option are located in .............. menu. Data Tools Insert Format