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