ITDAB 12 July Data Management

How do you create a PivotTable in Excel?

• Click on the Insert tab and then the PivotTable button

• Click on the Analyse tab and then the PivotTable button

• Click on the Design tab and then the PivotTable button

• Click on the Home tab and then the PivotTable button

Where can you place the PivotTable in Excel?

• In a new worksheet

• In the same worksheet as the data

• In a new Excel file

• In the header of the data table

How can you add data to a PivotTable in Excel?

• By copying and pasting from another worksheet

• By typing the data manually

• By using the AutoSum function

• By dragging the fields from the field list to the drop-down areas

How do you change the design of a PivotTable in Excel?

• By clicking on the Insert button

• By clicking on the Format as Table button

• By clicking on the Analyse button

• By clicking on the Design button

Where can you find the PivotChart button in Excel?

• Under the Analyse tab

• Under the Data tab

• Under the Insert tab

• Under the Design tab

How do you format data as an Excel Table?

• By clicking on the PivotTable button

• By clicking on the Insert tab

• By clicking on the Analyse tab

• By clicking on the Format as Table button

What appears after formatting data as an Excel Table?

• PivotTable buttons

• Filter buttons

• Sort buttons

• Chart buttons

How can you remove filtering from an Excel table?

• By clicking on the Filter button under the Analyse tab

• By clicking on the Sort button under the Data tab

• By clicking on the PivotTable button

• By clicking on the specific dropdown and clearing the filter

Where can you find functions like average, count, max, min, etc. for filtered data in Excel after creating a table?

• At the left of the column

• At the bottom of the column

• At the right of the column

• At the top of the column

What is the function of a pivot table in excel?

• Easy to read

• Easy to analyze

• Quickly summarizes large amounts of data interactively

• Looks neater