Formatting
A series of Symbols used to describe exavtly how Excel should display a number, date, time, or text string.
Format Code
A function that displays the date of a weekday that is a specified number of weekdays past a starting day
WEEKDAY Function
A type of fill series in which you use the Fill button and Series dialog box to fill cells with data.
Linear Series
3-D Reference
To combine data on multiple worksheets and display the result on another worksheet
Consolidation
The default style that is applied to all text or cells when you start the program
Normal Style
A type of fill series in which you use the Fill button and Series dialog box to fill cells with dates.
Date Series
A feature that creates a series with the same results as dragging the fill handle
Auto Fill Series
The entire drive path, folder, worksheet name, and cell reference for a workbook
Absolute Path
To consolidate data from separate workbooks
Link
A small number placed below the normal text line, such as those used in scientific and chemical notations
Subscript
A date function that returns the day of the week from a serial date
WEEKDAY Function
A type of fill series that multiplies values by a constant factor
Growth Series
A data type that refers to a rectangular block of cells (which can be just one cell), or in some cases, a number of noncontiguous blocks of cells.
Worksheet Reference
The consolidated main wokrbook that contains the links to the separate workbooks
Dependent Workbook
A small number placed above the normal text line to indicate exponentiation
Superscript
A datae and time Excel stores that represents the number of days since January 1900, followed by a fractional portion of a 24-hour day
Serial Number
The function that rounds a value to the nearest digit
ROUND Function
An exclamation point (!) used in a formula to indicate that a referenced cell is outside the active sheet.
External Reference Indicator
A technique that allows you to insert a copy of an object into a destination document, with the object maintaining a connection to the source file
Linking
A line preview that updates as you insert new data
Cell Animation
A function that returns only the current date, which updates each time a worksheet is opened
TODAY Function
A feature that lets you enter a number in the same cell through all selected worksheets
Drilling an Entry
A range that spans two or more worksheets in a workbook
3-D Range
Workbook from which you copy or link data
Source Workbooks