Spreedsheets
Insert Function
A button loacted on the formula bar that allows quick access to the Insert Function dialog box.
Absolute Reference
A cell reference that does not adjust when the formula is pasted to a new location.
Range
A colon inserted between two cell references.
Auto Fill
A feature that enables you to fill in a series of numbers, dates, or other items automatically in a specified range.
Auto Sum
A feature that you can use to insert a formula that sums a range of cells automatically.
Data Series
A group of related data points plotted in a chart that originates from rows or columns on a single worksheet.
Sheet Tab:
A means to access the different sheets in a workbook, located at the bottom of the spreadsheet.
Function
A predefined function in Excel.
Formula
A sequence of values, cell references and operators used to produce a new value from existing cells.
Toolbars
A series of buttons and menus in an application, which allows the user to perform functions quickly using the mouse.
Chart Wizard
A series of dialog boxes that lets you create a chart and customize it as you create it.
Spreadsheet
A table of values arranged in rows and columns.
Worksheet
A work area comprised of rows and columns, also known as a spreadsheet.
Workbook
An Excel file that contains one or more worksheets.
Bar Chart
Compares individual items. Categories are organized vertically, values horizontally to place more emphasis on comparing values than on time.
Formula Bar
Displays the contents of the current or active cell, located above the worksheet column headings.
Chart
Graphic representation of worksheet data.
Cell Reference
Identifies a particular cell
Data Label
Identifies specific points or series.
Chart Title
Identifies the purpose of the chart.
Legend
Key to the data represented by a chart.
Operators
Operators: Addition (+), Subtraction (-), Multiplication (*), and Division (/), also the colon (:) that separates cells in a range.
Gridlines
Optional lines on a chart.
Task Pane
Provides a quick means to execute commands. Displays when you start Excel and and enables you to create new workbooks or open and existing one.
Column Chart
Shows changes in data over a period of time or illustrates comparisons among items.
Pie Chart
Shows the relationship of items that make up data series to the sum of the items.
Line Chart
Shows trends in data at equal intervals.
Cell
The intersection of a row and column.
Value
The number resulting from the execution of a formula.
Order of Precedence
The order in which excel processes operations in a formula with more than one operation.
Alignment
The placement of cell data in a cell.
Fill Handle
The small black square on the bottom right corner of a selected cell.
Active Cell
The worksheet cell with a dark border; text or numbers you type appear in this cell and in the formula bar.
Merge and Center
To combine adjacent, or contiguous, cells into one large cell and center the data.
Templates
ready-made pages format, complete with margins, fonts, headers and footers, numbering, logos or any other kind of formatting the designer wants to appear on each page.