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