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