click below
click below
Normal Size Small Size show me how
Excel Ch. 4
Excel Review
Term | Definition |
---|---|
= | A function always begins with |
$ | Represents an absolute function |
# | Several of these represent that the number is too big to fit in the column |
Select Tool | This tool looks like a white plus sign and is placed in the center of the row |
Fill Tool | This one looks like a black plus sign and appears when the cursor is placed on the bottom right hand corner over the tiny black box |
Move Tool | This one looks like a plus sign with arrows coming out. It is placed on the side of a cell |
Absolute Function | Cell address that does not change when copied in a formula |
Average Function | Built in mathematical function that determines the average of a block of cells |
Count | An excel function that counts all numeric values in a range |
Count A | Number of cells in a range containing both text and values |
Function | Built-in mathematical function |
Max Function | Function that returns the highest number in a range of cells |
Min Function | Returns the lowest number in a range |
Mixed Reference | Cell address that adjusts or changes when it is copied |
Relative Function | Cell address that adjusts either the row or the column when the formula is copied |
Text Wrapping | An automatic feature that moves text to the next line when a line is full and text can no longer fit |