Excel 2016 Tips and Tricks

Lesson – Working with Tables

Excel 2016

Steps

Practice Data

4. Select the cell in the total row for the field you want to calculate. A list arrow appears to the right of the cell.

Click in the Total row for the Sales field (cell F26)

5. Select the list arrow.

Click

A list of functions is displayed.

6. Select the desired function.

Click Sum

The selected calculation appears in the cell.

Practice the Concept: Select the cell in the Total row for the Purchaser column (column H) and click the list arrow. The Count function is displaying a count of entries. Select None to remove the calculation for this column.

Select the Year Filter button and choose Clear Filter From “Year” . Notice that the total for the Sales column recalculates. Change the function in the Total row for the Sales column to display the highest sale ( Max ).

Hide the total row by clicking the Total Row button on the Design tab. Redisplay the total row. Notice that Excel remembers which type of calculation was used for the Sales column.

Close the file TABLE.XLS.

A DDING T ABLE R OWS AND C OLUMNS  D ISCUSSION

While some lists may be used for information that is static and unchanging, other tables may grow as new information is added. You can easily add new rows or columns to a table.

As new data is typed or pasted into the row below the table, the table automatically resizes to include the new row of data. If you are using the total row, you must temporarily hide it to add new data rows in this way; you can redisplay it after adding the new data rows. The formulas in the total row will automatically include the new data in their calculations.

Similarly, as new data is typed or pasted into the column to the right of the table, the table automatically resizes to include the new column.

Page 32

OFFICEPRO, Inc.