After creating a PivotTable, you can refresh its data, but you cannot change the data source.

Ricki wants to apply a particular chart style to a PivotChart she has created. Which of these tabs will help her apply it?

How are Excel tables and PivotTables similar?

Che has a Pie PivotChart that he wants to display in a three-dimensional format. Which of the following should he do?

Smith created SmartArt that illustrates four steps in a process. How can he add a fifth step?

Colin inserted SmartArt using an Organizational Chart layout. How can he make the SmartArt look more distinctive?

The subtotals in Chastity’s PivotTable make the PivotTable too large and difficult to use. Which option can she select to make the PivotTable more compact?

Before importing data into Excel, you can use the Power Query Editor to remove columns.

Jenny inserted two types of SmartArt in a worksheet and wants to make them look more similar. Which of the following can she do?

Lindsay wants to filter a PivotTable to display only June revenue data. Which of the following fields should she add to the Filters area?