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