Excel in 30 Minutes Analyzing Data with Tables and Formatting

Which of the following are benefits to creating a table object in Excel?

Quick formatting

Automatic filters

Column headers freeze at the top of the table

All of the above

What do you need to do first when using the Quick Analysis tool?

Select a range of cells

Select charts or tables

Select the Quick Analysis button

If a cell meets the criteria for two conditional formatting rules, which one will take precedence?

The one closer to the top of the list in the Conditional Formatting Rules Manager

The one closer to the bottom of the list in the Conditional Formatting Rules Manager

Information