2.4 Customizing a Table – Using Formulas in Tables – Practice Exercise 11 – Intermediate Excel 2016

STEP 1:  Still using data file, FIRST_RANGE_TO_TABLE_EXERCISE, CREATE TABLE TAB
 
Adding the new column header:
Make cell D1 the active cell. Enter “Difference” into the cell and press Enter. The table has added a new column (FIGURE 1).

FIGURE 1

​STEP 2: Entering the formula:
In cell D2 enter: =C2-B2 and press Enter (FIGURE 2).
 
The power of entering a formula into a table is that you only need to enter 1 formula. When you press Enter to execute the formula, the entire column is calculated, as shown in FIGURE 3. This will occur when entering a formula into any cell in Column D.
 
You can edit the formula using any cell. And the editing results will propagate to all of the other cells in the column automatically.

FIGURE 2

                                                                                                       FIGURE 3

STEP 3: Smart Tag Information: This symbol that appears next to a table formula results, is known as a Smart tag. When you click on it, an arrowhead shows, which when clicked on, provides a drop-down menu.
Click on the Smart tag symbol with the mouse. Click on the arrow to see the drop-down menu (FIGURE 4).

Drop down menu options include undoing the calculation, stop automatically calculating the formula results for that column. Selecting the Control AutoCorrect Options takes you to the AutoCorrect dialog box; selecting the More Actions button takes you to helpful info, which gives other choices.

                      FIGURE 4