Lesson 12

Preview

Customizing a Table – Using Formulas in Tables; Practice Exercise 11

Practice Exercise 11: Customize a table by applying formulas

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

In cell D2 enter: =C2-B2 and press Enter (FIGURE 2).

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 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

END OF LESSON

Back to: Intermediate Excel 2016 > Module 2 – Intermediate Excel 2016

Leave a Reply