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