g
Printer Friendly Version

editor   Chris Curtis
BellaOnline's Desk Top Publishing Editor
 

Glossary of Spreadsheet Terms

Active cell
The cell that is currently selected

Arguments
The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numeric values, text values, cell references, ranges of cells, names, labels, and nested functions.

Auto Sum
A built-in function that will add up a column or row of numbers

Cell Address
The column letter and row number of a cell

Cell Reference
Use of another cell address in a formula

Cell
The intersection of a column and row

Column
The vertical reference on the spreadsheet

Column Indicator
The gray column header above a spreadsheet column that identifies the column address

Fill
To fill a cell with color using the paint bucket tool

Fill handle
The square at the lower right corner of the active cell

Filter
A procedure that extracts certain information based on your criteria

Formula
An equation that performs operations on worksheet data

Formula Bar
An area on the application window that displays the entry in the active cell. It is used to create equations in the form of formulas or functions.

Function
Pre-established formula where you supply the information (called arguments) needed to make the calculation. Excel has 200 built-in functions.

Function Pallet
Dialog box that leads you through identifying the appropriate arguments for a function.

Graph
A visual representation of data

Grid Lines
The horizontal and vertical lines on the spreadsheet

Name Box
An area on the formula bar that displays the cell addresses of the current selection. Also used to create Named Ranges. Is an effective tool for navigating within the workbook.

Range
A selection of cells

Row
The horizontal reference on the spreadsheet

Row Indicator
The gray header to the left of each row that identifies the row address.

Selecting
To highlight a set of cells

Sheet
One page of a spreadsheet

Sheet tabs
Tabs that identify the worksheets in a workbook

Spreadsheets
A grid that organizes data and performs calculations

Value
A number that can be entered into a cell

Workbook
A spreadsheet file

Worksheet
One page in the Workbook

Desk Top Publishing Site @ BellaOnline
View This Article in Regular Layout

Content copyright © 2008 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact Chris Curtis for details.



| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2008 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor