click below
click below
Normal Size Small Size show me how
AR CBA Excel Part 2
| Term | Definition |
|---|---|
| alphanumeric text that will not be used in calculations | label |
| a chart that shows the relationship of a part to a whole | pie chart |
| a chart that uses bars of varying height to illustrate values in a worksheet | column chart |
| a chart that uses points connected by a line to illustrate values in a worksheet | line chart |
| a function that automatically adds the values in the cells directly above or to the left of the active cell | AutoSum |
| a graphic representation of values and their relationships: pie, line, column, bar, scattered | Chart/Graph |
| a prewritten formula that makes it easy to perform common Calculations | Function |
| numeric characters that can be used in a calculation | Value |
| process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet | What-If Analysis |
| returns the average (arithmetic means) of its arguments | Average |
| returns the largest value in a set of values | Maximum |
| returns the number of cells in a range that contains numbers | Count |
| returns the smallest value in a set of values | Minimum |
| sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest | Ascending |
| sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest | Descending |
| to arrange a list of words or numbers in ascending or descending order | Sort |
| to copy a cell's contents and/or formatting into an adjacent cell or range | Fill |
| value, cell reference, range, or text that acts as an operand in a function formula | Argument |