26 terms

Microsoft Excel Terminology

BCA
STUDY
PLAY
Spreadsheet
A type of software for evaluating information
Workbook
The name of a document in Excel
Sheet
A page in an Excel workbook
Cell/active cell
A cell is the rectangular area where a row and column intersect
Formula Bar
Found directly above column headings; shows location in spreadsheet and what was typed in cell
Sheet tab
Tabs you use to select different sheets
Values
Numbers that represent a quantity
Formulas
An arithmetical expression used to calculate values
Functions
A prewritten formula that provides a shortcut to common calculations
Range
A single cell or any rectangular block of cells
Input
Data that is to be entered into a worksheet
Output
The information the worksheet is designed to generate
Order of precedence
The rules for determining how to perform calculations containing multiple arithmetical operators
Relative cell reference
Cell reference which changes according to the location of the cell in which the reference occurs
Absolute cell reference
Cell reference which remains fixed even if the cell in which the reference occurs is moving to a new location
Argument
The specific values on which the function is to operate
AutoFormat
A feature that allows you to change a worksheet's overall appearance by choosing from predefined formats
Border
Lines used to distinguish different zones on a worksheet
Chart
A graphic representation of data
Plot area
The area defined by the X and Y axes of a chart
Data point
A single value originating in a worksheet
Data marker
A graphic representing a single value (bar, slice, etc.)
Data series
A group of related data points
Embedded chart
A chart which is positioned as part of an existing worksheet
Chart sheet
A special worksheet which contains a single chart only
Nonadjacent range
A group of individual cells or ranges of cells that are not next to each other