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