When you link an Excel chart to a PowerPoint slide, the chart always retains its original formatting.

If a PivotTable displays the Department and Quarter fields as row headings, you can drag the Department field to the Filters area to filter the PivotTable by Department.

Which of the following features provides a way to correct a picture in a worksheet?

Which of these is the default layout for a newly created Pivot table?

You can move the PivotTable Fields pane, but you cannot hide it.

Olivia inserted two pictures in a worksheet and to position their top edges in the same row. Which of the following is an efficient way for her to do this?

To which of the following locations can you move a PivotChart?

Ingrid wants to create a PivotChart based on a PivotTable she added to a worksheet. What should she do before creating the PivotChart?

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

 When you get and transform data from an external source, you must add it to a worksheet without any changes