Exercise: Tables

What are the steps for displaying table rows that have grades lower than a C in a column titled Grade

Click the arrow in the Grade header and then click Number Filters and then Less Than

What does a worksheet Total Row display

The Total Row displays the results of column-specific calculations and provides you with access to some of Excel's built-in table summary function capabilities

What is one way a PivotTable could combine the following data

There are two possible ways a PivotTable could combine the data, but the most logical way would be to combine the Unit Sales

Name at least three actions that can be done with the Quick Analysis button

You can use the Quick Analysis button to format data, create a chart, add a total, create a PivotTable, and add Sparklines

How can you add a new row to a table after you've created it

Add a new row to a table by selecting the last cell and then pressing Tab

What two Sort functions are available in Excel to sort cell ranges

Quick Sort or Custom Sort