Term
|
Definition
| A cell reference that refers to cells by their fixed position in a worksheet, an absolute cell reference remains the same when the formula is copied. |
|
|
Term
|
Definition
| The Excel number format that appies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places and leaves a small amount of space at the right edge of the cell to accomodate a parenthesis for negative numbers. |
|
|
Term
|
Definition
| The cell surrounded by a black border. |
|
|
Term
|
Definition
| The symbols =, -, *, /, % and ^ |
|
|
Term
|
Definition
| A feature that displays three calculations in the status bar by default - Average, Count, and Sum - when you select a range of numerical data. |
|
|
Term
|
Definition
| The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis |
|
|
Term
|
Definition
The labels that display along the bottom of a chart to identify the categories of data; Excel uses the row titles as the category names.
|
|
|
Term
Cell reference
or
Cell address |
|
Definition
| The identification of a specific cell by its intersecting column letter and row number. |
|
|
Term
|
Definition
| A defined set of formatting characteristics such as font, font size, font color, cell borders, and cell shading. |
|
|
Term
|
Definition
| A button that enables you to add, remove, or change chart elements such as the title, legend, fridlines, and data labels. |
|
|
Term
|
Definition
| A button that enables you to change which data displays in the chart |
|
|
Term
|
Definition
| The overall visual look of a chart in terms of its graphic effects, colors, and backgrounds; for example, you can have flat or beveled columns, colors that are solid or transparent, and backgrounds that are dark or light. |
|
|
Term
|
Definition
| A button that enables you to set a style and color scheme for your chart |
|
|
Term
|
Definition
A group of predesigned chart styles that you can apply to an Excel chart. |
|
|
Term
|
Definition
| Various chart formats used in a way that is meaningful to the reader; common examples are column charts, pie charts, and line charts. |
|
|
Term
|
Definition
| A chart in which the data is arranged in columns and that is useful for showing how data changes over a period of time or for illustrating comparisons among items. |
|
|
Term
|
Definition
A command associated with the currently selected or active object; often activated by right-clicking a screen item. |
|
|
Term
|
Definition
| A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points form a data series. |
|
|
Term
|
Definition
A value that originates in a worksheet cell and that is represented in a chart by a data marker. |
|
|
Term
|
Definition
| Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend. |
|
|
Term
|
Definition
The default format that Excel applies to numbers; this format has no specific characteristics—whatever you type in the cell will display, with the exception that trailing zeros to the right of a decimal point will not display. |
|
|
Term
|
Definition
| The cell format in which characters align at the left edge of the cell; this is the default for text entries and is an example of formatting information stored in a cell |
|
|
Term
|
Definition
| A chart element that identifies the patterns or colors that are assigned to the categories in the chart. |
|
|
Term
|
Definition
The area along the top edge of a worksheet that identifies each column with a unique letter or combination of letters. |
|
|
Term
|
Definition
| A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell. |
|
|
Term
|
Definition
An element of the Excel window that displays the name of the selected cell, table, chart, or object. |
|
|
Term
|
Definition
| The area along the left edge of a worksheet that identifies each row with a unique number. |
|
|
Term
|
Definition
| The symbols with which you can specify the type of calculation you want to perform in an Excel formula. |
|
|
Term
|
Definition
A screen view in which you can use the rulers to measure the width and height of data, set margins for printing, hide or display the numbered row headings and the lettered column headings, and change the page orientation; this view is useful for preparing your worksheet for printing. |
|
|
Term
|
Definition
| A point of light measured in dots per square inch on a screen; 64 pixels equals 8.43 characters, which is the average number of characters that will fit in a cell in an Excel worksheet using the default font. |
|
|
Term
|
Definition
| A tool that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas. |
|
|
Term
|
Definition
| An Excel feature that displays a customized set of charts that, according to Excel's calculations, will best fit your data based on the range of data that you select. |
|
|
Term
|
Definition
| In a formula, the address of a cell based on the relative positions of the cell that contains the formula and the cell referred to in the formula. |
|
|
Term
|
Definition
| The process of shrinking the width and/or height of printed output to fit a maximum number of pages. |
|
|
Term
|
Definition
| A box in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet. |
|
|
Term
|
Definition
| A group of things that come one after another in succession; for example, January, February, March, and so on. |
|
|
Term
| Sheet tab scrolling buttons |
|
Definition
| Buttons to the left of the sheet tabs used to display Excel sheet tabs that are not in view; used when there are more sheet tabs than will display in the space provided. |
|
|
Term
|
Definition
| The labels along the lower border of the Excel window that identify each worksheet. |
|
|
Term
|
Definition
| A command that displays the formula in each cell isntead of the resulting value. |
|
|
Term
|
Definition
| A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious. |
|
|
Term
|
Definition
| The area along the lower edge of the Excel window that displays, on the left side, the current cell mode, page number, and worksheet information; on the right side, when numerical data is selected, common calculations such as Sum and Average display |
|
|
Term
|
Definition
A charting command to swap the data over the axis—data being charted on the vertical axis will move to the horizontal axis and vice versa. |
|
|
Term
|
Definition
| The formula entered in a cell and visible only on the Formula Bar. Underlying value The data that displays in the Formula Bar. |
|
|
Term
|
Definition
| A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the Y-axis. |
|
|
Term
|
Definition
| The primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines. |
|
|
Term
|
Definition
| The values that an Excel function uses to perform calculations or operations. |
|
|
Term
|
Definition
An Excel function that adds a group of values, and then divides the result by the number of values in the group. |
|
|
Term
|
Definition
| Symbols that evaluate each value to determine if it is the same (—), greater than (>), less than (<), or in between a range of values as specified by the criteria. |
|
|
Term
|
Definition
| A format that changes the appearance of a cell—for example, by adding cell shading or font color—based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted. |
|
|
Term
|
Definition
A statistical function that counts the number of cells in a range that contain numbers. |
|
|
Term
|
Definition
A statistical function that counts the number of cells within a range that meet the given condition and that has two arguments—the range of cells to check and the criteria. |
|
|
Term
|
Definition
| A cell format consisting of a shaded bar that provides a visual cue to the reader about the value of a cell relative to other cells; the length of the bar represents the value in the cell—a longer bar represents a higher value and a shorter bar represents s lower value. |
|
|
Term
|
Definition
The worksheets that contain the details of the information summarized on a summary sheet. Drag and drop The action of moving a selection by dragging it to a new location. |
|
|
Term
|
Definition
| The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify. |
|
|
Term
|
Definition
Recognizes a pattern in your data, and then automatically fills in values when you enter examples of the output that you want. Use it to split data from two or more cells or to combine data from two cells. |
|
|
Term
|
Definition
| An Excel feature that, after typing an = (equal sign) and the beginning letter or letters of a function name, displays a list of function names that match the typed letter(s), and from which you can insert the function by pointing to its name and pressing the Tab key or double-clicking. |
|
|
Term
|
Definition
| A command that enables you to select one or more rows or columns and freeze (lock) them into place; the locked rows and columns become separate panes. |
|
|
Term
|
Definition
| A function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false. |
|
|
Term
|
Definition
A group of functions that test for specific conditions and that typically use conditional tests to determine whether specified conditions are true or false. |
|
|
Term
|
Definition
| Any value or expression that can be evaluated as being true or false. |
|
|
Term
|
Definition
| An Excel function that retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell. |
|
|
Term
|
Definition
| An Excel command that enables you to specify rows and columns to repeat on each printed page. |
|
|
Term
|
Definition
| Excel commands that enable you to stretch or shrink the width, height, or both, of printed output to fit a maximum number of pages. |
|
|
Term
|
Definition
| Splits the window into multiple resizable panes that contain views of your worksheet This is useful to view multiple distant parts of your worksheet at one time. |
|
|
Term
|
Definition
Excel functions, including the AVERAGE, MEDIAN, MIN, and MAX functions, which are useful to analyze a group of measurements. |
|
|
Term
|
Definition
| A worksheet where totals from other worksheets are displayed and summarized. |
|
|
Term
|
Definition
A term used to describe an Excel function that is subject to change each time the workbook is reopened; for example the NOW function updates itself to the current date and time each time the workbook is opened. |
|
|
