- 3-D reference
A pattern for referring to the workbook, worksheet, and cell from which a value should be read
- active cell
The cell that is currently selected and open for editing
- Add-In
A supplemental program that can be used to extend Excel's functions
- alignment
The manner in which a cell's contents are arranged within that cell (for example, centered)
- arguments
The specific data a function requires to calculate a value
- aspect ratio
The relationship between a graphic's height and width
- auditing
The process of examining a worksheet for errors
- AutoComplete
The ability to complete data entry for a cell based on similar values in other cells in the same column
- AutoFill
The ability to extend a series of values based on the contents of a single cell
- AutoFilter
A Microsoft Excel tool you can use to create filters
- AutoRepublish
An Excel technology that maintains a link between a Web document and the worksheet on which the Web document is based and updates the Web document whenever the original worksheet is saved
- browser
A program that lets users view Web documents
- cell
The box at the intersection of a row and a column
- cell range
A group of cells
- cell reference
The letter and number combination, such as C16, that identifies the row and column intersection of a cell
- charts
Visual summaries of worksheet data, also called graphs
- columns
Cells that are on the same vertical line in a worksheet
- conditional formats
Formats that are applied only when cell contents meet certain criteria
- conditional formula
A formula that calculates a value using one of two different expressions, depending on whether a third expression is true or false
- data consolidation
Summarizing data from a set of similar cell ranges
- data list
One or more columns of data depicting multiple instances of a single thing (such as an order)
- data table
A new Microsoft Office Excel 2007 object that enables you to store and refer to data based on the name of the table and the names of its columns and rows
- dependents
The cells with formulas that use the value from a particular cell
- driver
A program that controls access to a file or device
- dynamic-link library
A file with programming code that can be called by a worksheet function
- embed
To save a file as part of another file, as opposed to linking one file to another
- error code
A brief message that appears in a worksheet cell, describing a problem with a formula or a function
- Extensible Markup Language (XML)
A content-marking system that lets you store data about the contents of a document in that document
- field
A column in a data list
- fill handle
The square at the lower right corner of a cell you drag to indicate other cells that should hold values in the series defined by the active cell
- Fill Series
The ability to extend a series of values based on the contents of two cells, where the first cell has the starting value for the series and the second cell shows the increment
- filter
A rule that Excel uses to determine which worksheet rows to display
- formats
Predefined sets of characteristics that can be applied to cell contents
- formula
An expression used to calculate a value
- Formula AutoComplete
The ability to enter a formula quickly by selecting functions, named ranges, and table references that appear when you begin to type the formula into a cell
- freeze
To assign cells that will remain at the top of a worksheet regardless of how far down the worksheet a user scrolls
- function
A predefined formula
- Goal Seek
An analysis tool that finds the value for a selected cell that would produce a given result from a calculation
- graphs
Visual summaries of worksheet data, also called charts
- hyperlink
A reference to a file on the Web
- Hypertext Markup Language (HTML)
A document-formatting system that tells a Web browser such as Internet Explorer how to display the contents of a file
- landscape mode
A display and printing mode whereby columns run parallel to the short edge of a sheet of paper
- link
A formula that has a cell show the value from another cell
- locked cells
Cells that cannot be modified if their worksheet is protected
- macro
A series of recorded automated actions that can be replayed
- mailto
A special type of hyperlink that lets a user create an e-mail message to a particular e-mail address
- Merge and Center
An operation, initiated by clicking the Merge and Center toolbar button, that combines a contiguous group of cells into a single cell. Selecting a merged cell and clicking the Merge and Center toolbar button splits the merged cells into the original group of separate cells.
- metadata
Data that describes the contents of a file
- named range
A group of related cells defined by a single name
- Open DataBase Connectivity (ODBC)
A protocol that facilitates data transfer between databases and related programs
- Paste Options
A button, which appears after you paste an item from the Clipboard into your workbook, that lets you control how the item appears in the workbook
- Pick from List
The ability to enter a value into a cell by choosing the value from the set of values already entered into cells in the same column
- pivot
To reorganize the contents of a PivotTable
- PivotChart
A chart that is linked to a PivotTable and that can be reorganized dynamically to emphasize different aspects of the underlying data
- PivotTable
A dynamic worksheet that can be reorganized by a user
- portrait mode
A display and printing mode whereby columns run parallel to the long edge of a sheet of paper
- precedents
The cells that are used in a formula
- primary key
A field or group of fields with values that distinguish a row in a data list from all other rows in the list
- property
A file detail, such as an author name or project code, that helps identify the file
- query
A statement that locates records in a database
- range
A group of related cells
- refresh
To update the contents of one document when the contents of another document are changed
- relative reference
A cell reference in a formula, such as =B3, that refers to a cell that is a specific distance away from the cell that contains the formula. For example, if the formula =B3 were in cell C3, copying the formula to cell C4 would cause the formula to change to =B4.
- report
A special document with links to one or more worksheets from the same workbook
- rows
Cells that are on the same horizontal line in a worksheet
- scenarios
Alternative data sets that let you view the impact of specific changes on your worksheet
- schema
A document that defines the structure of a set of XML files
- sharing
Making a workbook available for more than one user to open and modify simultaneously
- sheet tab
The indicator for selecting a worksheet, located in the lower left corner of the workbook window
- smart tags
A Microsoft Office technology that recognizes values in a spreadsheet and finds related information on the Web
- sort
To reorder the contents of a worksheet based on a criterion
- split bar
A line that defines which cells have been frozen at the top of a worksheet
- subtotals
Partial totals for related data in a worksheet
- tables
Data lists in a database
- tags
Marks used to indicate display properties or to communicate data about the contents of a document
- template
A workbook used as a pattern for creating other workbooks
- theme
A predefined format that can be applied to a worksheet
- trend line
A projection of future data (such as sales) based on past performance
- validation rule
A test that data must pass to be entered into a cell without generating a warning message
- what-if analysis
Analysis of the contents of a worksheet to determine the impact that specific changes have on your calculations
- workbook
The basic Excel document, consisting of one or more worksheets
- worksheet
A page in an Excel workbook
- workspace
An Excel file type (.xlw) that allows you to open several files at once
|