Classic Computer Magazine Archive COMPUTE! ISSUE 138 / FEBRUARY/MARCH 1992 / PAGE S16

Spreadsheet glossary. (Compute's Getting Started with Spreadsheets) (Glossary)

address. The location of an individual cell, usually given in A1 address style (A1, A2, A3, and so on) or R1C1 address style (R1C1, R1C2, R1C3). Also known as reference. See also column heading and row heading.

cell. The basic unit of a spreadsheet. Cells are formed by the intersection of rows and columns and can hold data, formulas, or both.

column heading. A heading that identifies a vertical group of cells. The heading is placed at the top of the cells. Column headings are usually labeled in A1 style (A, B, C) or R1C1 style (C1, C2, C3, or 1, 2, 3). See also row heading.

formula. A statement that describes a mathematical calculation. Formulas in spreadsheets are linked to individual cells, though they often refer to data and formulas in other cells, allowing a user to perform what-if calculations.

function. Calculation tool that allows you to perform decision-making and value-returning operations automatically. For example, SUM is a function that sums a group of numbers. IF is a function that permits you to test a value and take action based on the result of that test.

label (text). A text string often used as a column or row heading.

macro. A series of commands recorded and saved for future playback. Use of macros can improve the speed and accuracy of spreadsheet work.

row heading. A heading that identifies a horizontal group of cells. The heading is placed to the left of the cells. Row headings are usually labeled in A1 style (1, 2, 3) or R1C1 style (R1, R2, R3 or 1, 2 3). See also column heading.

work sheet. A spreadsheet document in which you can store, manipulate, calculate, and analyze data.