AppleWorks Spreadsheet: A Guide for Island Teachers
Previous Page Home Next Page

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

previous page || page 1 || next page

Technology Integration Document
P.E.I. Department of Education, 2000
Spreadsheet terminology
Hint: When entering a formula, always remember the equal sign.