Excel Terminology (excel 专用术语)

Excel TerБайду номын сангаасinology
Absolute reference: In a formula, a reference to a cell that does not change if the formula is copied to a different cell. An absolute reference uses two dollar signs, such as $A$15 for cell A15. Active cell: The cell whose contents appear in the formula bar. You can enter information into the active cell and also edit its contents. Argument: In a worksheet function, information (enclosed in parentheses) that provides details as to what you want the function to do. Autofilter: To display only the rows in a list that meet certain criteria. Autoformat: Predefined formatting that you can quickly apply to a range of cells in a worksheet or a pivot table. Also refers to predefined formats that you can apply to a chart. AutoShape: A graphic object that you place on the draw layer using one. of the Excel drawing tools. . Cell: A single addressable unit in a worksheet, defined by the intersection of a row and a column. Cell comment: A comment that is attached to a cell. Cell pointer: The dark border that surrounds the active cell. You move the cell pointer with the mouse or the keyboard. Cell reference: Identifies a cell by giving its column letter and row number. For example, C5 refers to the cell at the intersection of column C and row 5. If you're referring to a cell on a different sheet, you need to precede it with the sheet name and an exclamation point. These can be relative references (most common), absolute references, or mixed references. Chart: A graphic representation of values in a worksheet. A chart can be embedded on a worksheet or stored on a separate chart sheet in a workbook. Chart sheet: A type of sheet in a workbook that holds a single chart. Circular reference: In a formula, a reference to the cell that contains the formula (either directly or indirectly). If cell A10 contains =SUM(A1:A10), a circular reference exists because the formula refers to its own cell. Column: Part of a worksheet that consists of 65,536 cells arranged vertically. Each worksheet has 256 columns. Conditional formatting: Formatting (such as color or-bold text) that is applied to a cell depending on the cell's contents. Consolidation: The process of merging data from multiple worksheets or multiple workbook files. Criteria range: A special type of range that holds specifications used by an advanced filter or for a database worksheet function. Data table: A table, calculated by Excel, that shows the effects on one or more formulas when one or more input cells take on different values. Excel supports one-way and two-way data tables. Data validation: The process of ensuring that data of the correct type is entered into a cell. For example, if the entry is outside of a specified range of values, you can display a message to the user. Default workbook template: A template that is used as the basis for new workbooks. This template is named book.xlt and is stored in your XLStart folder. Default worksheet template: A template that is used as the basis for new worksheets that you insert into a workbook. This template is named sheet.xlt and is stored in your XLStart folder. Dependent cell: A cell that contains a formula that refers to the active cell. In other words, the formula depends on the value in the active cell. Draw layer: An invisible layer on top of all worksheets. The draw layer contains embedded charts, maps, and drawn objects. Embedded chart: A chart that's placed on a worksheet's draw layer (as opposed to residing on a separate chart sheet). Field: In a database, information that is contained in columns. Fill handle: The small square object that appears at the lower-right corner of the active cell or a selected range of cells. Filter: To hide rows in a list such that only the rows that meet a certain criteria are displayed. Formula: An entry in a cell that returns a calculated result. Formula bar: The area of Excel, just below the toolbars, that displays the contents of the active cell. You can edit the cell in the formula bar. Formula palette: A tool that helps you create and edit formulas and worksheet functions. Frozen titles: The process of keeping certain top rows and/or left columns always displayed, no matter where the cell pointer is. You can set this with the Windows,->_Freeze Panes command. Function: A special keyword used in a formula to perform a calculation. Use the Function Wizard to enter a function in a formula. Goal seeking: The process of determining the value of a cell that results in a specific value returned by a formula. Gridlines: Lines that delineate the cells in a worksheet. In a chart, gridlines are extensions of the tick marks on the axes. Handles: On graphic objects, these are the small squarish things at the corners and on the sides. You can drag handles with a mouse to change the size of the graphic object. Legend: In a chart, the small box that describes the data series. In a map, the small box that describes the map's contents.