Excel 2019 Bible

Chapter 9: Introducing Formulas and Functions

9

If you point to a different worksheet or workbook when creating a formula, you’ll notice that Excel always inserts
absolute cell references. Therefore, if you plan to copy the formula to other cells, make sure that you change the cell
references to relative before you copy.

Using Formulas in Tables

A table is a specially designated range of cells, set up with column headers. In this section,

we describe how formulas work with tables.

See Chapter 4, “Working with Excel Ranges and Tables” for an introduction to the Excel table features.

Summarizing data in a table

Figure 9.9 shows a simple table with three columns. We entered the data and then con-

verted the range to a table by choosing Insert ➪ Tables ➪ Table. Note that we didn’t define

any names, but the table is named Table1 by default.

FIGURE 9.9

A simple table with three columns of information

This workbook is available on this book’s website at http://www.wiley.com/go/excel2019bible. It is

named table formulas.xlsx.