click below
click below
Normal Size Small Size show me how
AR Excel-U3 Part 2
| Question | Answer |
|---|---|
| Cell reference that does not adjust to the new cell location when copied or moved. | absolute cell reference |
| Value, cell reference, range, or text that acts as an operand in a function formula. | argument |
| A function that automatically adds the values in the cells directly above or to the left of the active cell. | autosum |
| Returns the average (arithmetic means) of its arguments. | AVERAGE |
| Returns the number of cells in a range that contains numbers. | COUNT |
| Keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls. | freeze |
| A prewritten formula that makes it easy to perform common calculations. | function |
| Returns the largest value in a set of values. | MAX |
| Returns the smallest value in a set of values. | MIN |
| A cell reference that contains both relative and absolute references. | mixed cell reference |
| A number or cell reference used in a formula. | operand |
| A symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/). | operator |
| Cell reference that adjusts to a new location when copied or moved. | relative cell reference |
| Adds all the numbers in a range of cells. | SUM |