Blog

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

Sam inserted SmartArt arranged as a horizontal series of shapes. He wants to change the SmartArt to group blocks of information in a pyramid. What should he do?

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.

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

Which of the following can you insert in a SmartArt Shape?

  You can import text data into Excel and save the imported data in Excel format.

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

Helen wants to resize slicer buttons to exact dimensions. She selects the slicer, then clicks the Slicer tab. What should she select next to reset the slicer buttons to exact dimensions?

Jada has a worksheet listing the first and last names of her students in a single column. Which Excel tool can she use to split the names into separate columns?

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