Calc Guide

A B C D E F G
8
Ilsub 70
85 97 79 82.75
9
James
45 65 97 85 73
10
Lisa
100 97 100 93 97.5
11
Michelle 100
97 100 65 90.5
12
Ravi
87 92 86 93 89.5
13
Sal
45 65 100 92 75.5
14
Ted
100 97 100 85 95.5
15
Tom
70 85 93 65 78.25
16
Whil
70 85 93 97 86.25
Tip
Although the choice to associate a row to a record rather than a
column is arbitrary, it is almost universal. In other words, you are
not likely to hear someone refer to a column of data as a single
database record.
Associating a range with a name
In a Calc document, a range refers to a contiguous group of cells
containing at least one cell. You can associate a meaningful name to a
range, which allows you to refer to the range using the meaningful
name. You can create either a database range, which has some
database-like functionality, or a named range, which does not. A name
is usually associated with a range for one of three reasons:
1) Associating a range with a name enhances readability by using a
meaningful name.
2) If a range is referenced by name in multiple locations, you can
point the name to another location and all references point to the
new location.
3) Ranges associated to a name are shown in the Navigator, which is
available by pressing the F5 key or clicking on the icon. The
Navigator allows for quick navigation to the associated ranges.
Named range
The most common usage of a named range is, as its name implies, to
associate a range of cells to a meaningful name. For example, I created
Chapter 13 Calc as a Simple Database 359