Getting Started - Spreadsheet Terminology
There are many features of AppleWorks spreadsheet that you will learn
as you go along. To get started with the program you should be familiar
with the spreadsheet terminology:
row
column
cell
address
data entry bar
formula
|
Spreadsheet Terminology
Spreadsheet data is organized in horizontal rows and vertical columns. Each
intersection of a row and column is called a cell.
Each cell in the spreadsheet has a specific address. A cell address
consists of the row letter and the column number, for example A4. Information
in the form of text, numbers, and formulas is entered in cells.
Data Entry Bar - the area at the top of every spreadsheet window
between the ruler and menu bar. This space shows the address and contents
of the active cell, the one seen outlined on the screen. Typed characters
first appear on the data entry bar and then move to the active cell when
the user taps the ENTER key.
Formula - a set of instructions typed into a cell that tells the
computer how to perform a specific calculation. The results of the formula
will be displayed in the cell, not the formula itself. For example, a formula
can calculate the sum of the contents of two cells in a spreadsheet:
=B6+B8
Or, a formula might add, subtract, multiply or divide the contents of a
cell by a value you specify:
=E9+7.5, =E9-5, =C6*8, =G7/3.5
| Technology Integration
Document |
| P.E.I. Department of
Education, 2000 |
|
|
| Spreadsheet terminology |
 |
| Hint: When entering a formula, always remember
the equal sign. |
|