Excel Vocabulary
Cell Style
A defined combination of formatting characteristics—such as number, alignment, font, border, and fill.
Data Marker
A dot, a bar, or a symbol used to represent one number from the worksheet.
Auto Fill
A feature that can be used to automatically fill in worksheet data in any direction
Range
A group of cells
Fill Handle
A little black square in the lower-right corner of the selected cell
Embedded Chart
A newly created chart that is saved as a graphic object and is saved as part of the worksheet
Workbook Window
Area of the program window displaying the worksheets
Fill
Background color or pattern
Functions
Built-in formulas that enable you to perform complex calculations easily.
Columns
Cells that display vertically and are labeled from left to right beginning with A through Z, then AA through AZ, and so on.
Workbook
Collection of related worksheets
Chart Area
Complete chart and all its elements
Mixed Reference
Contains both relative and absolute cell references
Sheet Tab
Displays the name of each sheet in the workbook
Chart
Graphic representation of worksheet data
Worksheet
Grid with columns and rows where you enter and summarize data.
Error Value
Indicates when a formula you have entered results in an error
Vertical Axis
Line on chart used for plotting values, also called Y-axis
Horizontal Axis
Line on chart used for showing categories, also called X-axis.
Gridlines
Lines extending from the vertical or horizontal axes across the plot area of a chart
Legend
List that identifies the patterns or colors of the data series or categories in a chart
Name Box
Located below the ribbon and displays the call reference of the active cell
Formula Bar
Located next to the Name box and displays the value or formula of the active cell
Drag-and-Drop Method
Method to move or copy a selection to a new location in your worksheet
Constants
Numbers entered directly into formulas that do not change
Absolute Reference
Permanent reference to a cell; does not change in relation to the location of the formula.
Data Source
Range of cells that contain the data for the chart
Sheet
See worksheet
Chart Sheet
Separate sheet in a workbook containing a chart
Data Series
Series of related values from the worksheet graphically represented by a unique color or pattern
Formula
Set of instructions used to preform calculations on values in a worksheet
Drawing Objects
Shapes, curves, or lines that are part of your worksheet
Order of Operations
Specific sequence used to calculate the value of a formula
Active Cell
The cell that is selected in a worksheet.
Cell Refrence
The column letter followed by the row number that identifies a cell, such as B5
Font
The design of a set of letters and numbers
Cell
The rectangle where a column and row intersect
Relative Reference
The reference to a cell that changes in relation to the location of the formula
Spreadsheet Software
Used to calculate, analyze, and visually represent numerical data.
Font Style
Variations in the shape or weight of a font's characters.