click below
click below
Normal Size Small Size show me how
spreed sheet
| Question | Answer |
|---|---|
| absolute cell reference | cell references that does not adjust to the new cell location when copied or moved |
| active cell | a selected worksheet cell that is ready for data entry |
| alignment | the position of data within a cell |
| ascending | sort order arrangement text or numbers from a to z from small to large or from earliest to latest |
| auto sum | a function that automatically adds the values in the cell direct above or to the left of the active cell |
| average | returns the average (arithmetic means ) of its arguments |
| cell | the spaced formed by the intersection of a row and column the basic unit of a worksheet |
| cell reference | a unique identifier for a cell which is formed by combining the cell column letter and row number |
| chart/graph | a graphic representation of values bad their relationship pie line column bar scattered |
| column | a vertical group of cells in a worksheet identified by letters |
| column chart | a chart that uses bars of varying height to illustrate values in a worksheet |
| count | returns the number of cells in a range that contains numbers |
| descending | sort of order arranging text or numbers from z to a largest to smallest or latest to earliest |
| fill | to copy a cells content and or formatting into an adjacent cell range |
| format | arranging the shape ,size, type and general makeup of a cell or group of cells |
| formula | an equation that calculates a new value using values currently on a worksheet |
| freeze | keep selected rows or columns visible on the screen as the rest of the worksheet |
| function | A prewritten formula that makes it easy to preform common calculations |
| label | alphanumeric text that will not be used on calculations |
| line chart | a chart that uses point connected by a line to illustrate values in a worksheet |
| max | returns the largest values in a set of values |
| min | returns the smallest value in a set of values |