Term
|
Definition
| operator used for addition |
|
|
Term
|
Definition
| operator used for subtraction |
|
|
Term
|
Definition
| operator used for multiplication |
|
|
Term
|
Definition
| operator used for division |
|
|
Term
|
Definition
| operator used for exponentiation |
|
|
Term
| parentheses - exponentiation - multiplication - division - addition - subtraction |
|
Definition
| standard order of operations |
|
|
Term
|
Definition
| this characteristic of [multiplication and division] and [addition and subtraction] causes the operations to be evaluated as they are encountered from left to right |
|
|
Term
|
Definition
| software application used for manipulating and analyzing tables of numbers |
|
|
Term
|
Definition
| an Excel document containing one or more sheets |
|
|
Term
|
Definition
| a single page in an Excel workbook |
|
|
Term
|
Definition
| a new Excel workbook contains this many sheets by default |
|
|
Term
|
Definition
| a data "space" formed by the intersection of a row and a column |
|
|
Term
|
Definition
| Excels columns are labeled with these |
|
|
Term
|
Definition
| Excel rows are labeled with these |
|
|
Term
|
Definition
| this button on the Home ribbon inserts automatic SUM (and other) function for the adjacent range |
|
|
Term
|
Definition
| displays the address or assigned name of the active cell |
|
|
Term
|
Definition
| the currently selected cell |
|
|
Term
|
Definition
| heavy border identifying the active cell |
|
|
Term
|
Definition
| displays the contents of the currently selected cell |
|
|
Term
|
Definition
| displays the name of the worksheet |
|
|
Term
|
Definition
| the calculated value of the expression =6*(4+6)/(3-2) |
|
|
Term
|
Definition
| the calculated value of the expression =6*4+6/3-2 |
|
|
Term
|
Definition
| a rectangular group of cells, such as might be used in a SUM function |
|
|
Term
|
Definition
| addressing method for a range |
|
|
Term
|
Definition
| keypress that moves the cell pointer to the first cell in the current row |
|
|
Term
|
Definition
| keypress that moves the cell pointer to the last occupied cell in the current row |
|
|
Term
|
Definition
| keypress that moves the cell pointer to cell A1 |
|
|
Term
|
Definition
| keypress that moves the cell pointer to the identified cell |
|
|
Term
|
Definition
| appearance of these symbols in a cell signifies a number that is too big to be displayed in the current cell width |
|
|
Term
|
Definition
| default alignment for text in a cell |
|
|
Term
|
Definition
| default alignment for numbers in a cell |
|
|
Term
|
Definition
| keypress that copies the current selection to the Clipboard |
|
|
Term
|
Definition
| keypress that "cuts" (moves) the current selection to the Clipboard |
|
|
Term
|
Definition
| keypress that pastes the contents of the Clipboard to the current cell or range of cells |
|
|
Term
|
Definition
| symbol that identifies the following text as a formula |
|
|
Term
|
Definition
| Excel function that adds the values in the identified range |
|
|
Term
|
Definition
| Excel function that determines the minimum (smallest) value in the identified range |
|
|
Term
|
Definition
| Excel function that determines the maximum (largest) value in the identified range |
|
|
Term
|
Definition
| Excel function that determines the number of cells with values in the identified range |
|
|
Term
|
Definition
| Excel function that calculates the average value of the identified range |
|
|
Term
|
Definition
| Excel option that allows you to lock identified rows and/or columns in place so that they remain visible while you scroll through the sheet |
|
|
Term
|
Definition
| default page view that shows an editing view of the workbook |
|
|
Term
|
Definition
| page view that shows a sheet as it will appear on a printed sheet |
|
|
Term
|
Definition
| page view that allows you to adjust the position of page breaks in printed output |
|
|
Term
|
Definition
| information that appears at the top of each page of printed output |
|
|
Term
|
Definition
| information that appears at the bottom of each page of printed output |
|
|
Term
|
Definition
| Excel option that combines multiple cells into one to hold a sheet title |
|
|
Term
|
Definition
| numeric format that includes a left-aligned dollar sign, comma separators, and two decimal places by default |
|
|
Term
|
Definition
| numeric format that includes a dollar sign, comma separators, and two decimal places by default |
|
|
Term
|
Definition
| numeric format that includes comma separators and two decimal places by default |
|
|
Term
|
Definition
| numeric format that multiplies a cell's value by 100 and appends a percent sign |
|
|
Term
|
Definition
| automatic formatting (e.g., shading) applied to cells whose values meet specified criteria |
|
|
Term
|
Definition
| limiting the display to cell values that meet a specified criteria |
|
|
Term
|
Definition
| a visual representation of spreadsheet data |
|
|
Term
|
Definition
| chart used to compare similar types of data |
|
|
Term
|
Definition
| chart used to illustrate the changes in data over time |
|
|
Term
|
Definition
| chart used to represent the relative contributions (percentages) components contribute to a whole |
|
|
Term
|
Definition
| worksheet data associated with an individual chart element, such a line, column, or pie "slice" |
|
|
Term
|
Definition
| key that defines the colors, patterns, and symbols used in a chart |
|
|
Term
|
Definition
| the horizontal (bottom) boundary of a chart |
|
|
Term
|
Definition
| the vertical (left) boundary of a chart |
|
|
Term
|
Definition
| a single cell value plotted in a chart |
|
|
Term
|
Definition
| pull out one or more "slices" of a pie chart for additional emphasis |
|
|
Term
|
Definition
| chart inserted on the same sheet as the originating data |
|
|
Term
|
Definition
| cell address that is not updated when a formula is copied to another cell |
|
|
Term
|
Definition
| cell address that is updated when a formula is copied to another cell |
|
|
Term
|
Definition
| format for typing an absolute address |
|
|
