Matching Pairs Excel Chapter 5Online version Vocabulary for Excel Chapter 5 by Melissa Busbin 1 Subscript 2 serial number 3 Consolidation 4 source workbooks 5 3-D range 6 date series 7 TODAY function 8 Normal style 9 3-D reference 10 worksheet reference 11 Superscript 12 ROUND function 13 format code 14 absolute path 15 linear series 16 auto fill series 17 Linking 18 Link 19 drilling 20 leader line 21 growth series The entire drive path, folder, worksheet name, and cell reference for a workbook. The process of summarizing data gathered from multiple worksheets onto one worksheet. Internal code for every format style listed in the Format Cells dialog box. Function that is used to round numbers to a specified number of decimal places. The default style that is applied to all cells when you start Excel. A data type that refers to a rectangular block of cells (which can be just one cell), or in some cases, a number of disjoint blocks of cells Chart element that connects a data label with its data point in order to help identify individual elements of a chart. A reference to a cell, or range of cells, in another workbook. A date and time Excel stores that represents the number of days since January 1900, followed by a fractional portion of a 24-hour day. an entry Excel feature that allows you to enter a number in the same cell through all selected worksheets Separate, individual workbooks from which you need data. Creates a series that produces the same results as dragging the fill handle Consolidating data from separate workbooks. Type of fill series in which you use the Fill button and Series dialog box to fill cells with dates. A small number placed above the normal text line to indicate exponentiation. Type of fill series that multiplies values by a constant factor. A range that spans two or more worksheets in a workbook. A reference to a 3-D range, or a range located on another worksheet within the workbook. A small number placed below the normal text line such as those used in scientific and chemical notations. Function that returns only the current date, which updates each time a worksheet is opened. Type of fill series in which you use the Fill button and Series dialog box to fill cells with data.
New game