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 |