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