Excel 2016 Tips and Tricks

Lesson – Working with Tables

Excel 2016

Steps

Practice Data

1. Select any cell in the column you want to use as a calculated column. The cell is selected. The formula appears in the cell and in the Formula Bar as you create it. 3. Press [Enter] to complete the formula. The result is displayed in the current cell and the formula is immediately copied to the other cells in the column. 2. Create the desired formula.

Click cell I3

Follow the instructions shown below the table before continuing to the next step

Press [Enter]

Type = (equal sign) to begin the formula. Click on cell F4 . Notice that Excel enters a reference in the formula to the Column Name ( [Sales] ).

Type * (asterisk). Type 20% .

Return to the table and continue to the next step (step 3).

Practice the Concept: Click on several different cells in the Profit column and view the formula in the Formula Bar . Notice that the formula is the same in each cell.

S ELECTING P ARTS OF A T ABLE  D ISCUSSION Excel provides several methods for selecting parts of a table. These methods are particularly useful for large tables. You can quickly select an entire row or column. You can select just the data in a column without the Header and Total Rows, which is useful if you want to format the column data without changing Headers and Totals. You can also select all the table data or the entire table including the Header Row and Total Row, which is useful if you want to copy or delete the data or the whole table.

Page 38

OFFICEPRO, Inc.