Datasheet

17
Chapter 1: Tapping into Formula and Function Fundamentals
Figure 1-10:
Using the
Name Box
to find the
named area.
Tables work in much the same manner as named areas. Tables have a few
features that are unavailable to simple named areas. With tables you can indi-
cate that the top row contains header labels. Further, tables default to have
filtering ability. Figure 1-11 shows a table on a worksheet, with headings and
filtering ability.
Figure 1-11:
Trying a
table.
With filtering, you can limit which rows show, based on which values you
select to display.
The Insert Ribbon contains the button to use for inserting a table.
Formatting your data
Of course you want to make your data look all spiffy and shiny. Bosses like
that. Is the number 98.6 someone’s temperature? Is it a score on a test? Is it
ninety-eight dollars and sixty cents? Is it a percentage? Any of these formats
is correct:
✓ 98.6
✓ $98.60
✓ 98.6%
05_568163-ch01.indd 1705_568163-ch01.indd 17 4/2/10 1:37 PM4/2/10 1:37 PM