click below
click below
Normal Size Small Size show me how
spreadsheet (test 2)
vocab
| Question | Answer |
|---|---|
| special formulas that do not use mathematical operations (+ - / *) | functions |
| the value, cell reference, range, or test that acts as an operand in the function formula | argument |
| a reference to a cell that will not adjust when you copy or move the formula to a new location in the spreadsheet | absolute cell reference |
| ways to display alphabetic and numeric data so it is more understandable to a spreadsheet user | cell formats |
| displays numerical data proceeded with a dollar sign | currency format |
| lines that you can insert above, below, or on the sides of cells | boarders |
| inserts color behind the characters in a cell | shading |
| keeps rows or column titles on the screen no matter where you scroll | freezing |
| places data in specific order, can be done on the toolbar or data menu, can perform ascending, descending, or can sort in more than one category | sorting |
| columns that determine how data will be sorted | sort criteria |
| the area of the spreadsheet to be sorted | sort range |
| determines the number of cells with entered data in a range | count function |
| represents a "dispersion" around a mean | standard deviation |
| locates the largest number in a range of cells | maximum function |
| locates the smallest number in a range of cells | minimum function |
| will calculate a total for a range of cells | sum function |
| will calculate the average for a range of cells | average function |