Excel Definitions - Part 2

To arrange a list of words or numbers in ascending or descending order

• COUNT
• Sort
• Range
• Chart/Graph

Selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon

• Sort
• COUNT
• Group
• Range

A chart that uses points connected by a line to illustrate values in a worksheet

• Line Chart
• Bar Chart
• Pie Chart
• Bar Graph

Numeric characters that can be used in a calculation

• Value
• Operator
• Number
• Range

Process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet

• COUNT
• Range
• What-If Analysis
• SUM

cell reference that does not adjust to the new cell location when copied or moved

• Relative Cell Reference
• Absolute Cell Reference
• Mixed Cell Reference
• Range

a cell reference that contains both relative and absolute references

• Relative Cell Reference
• Absolute Cell Reference
• Mixed Cell Reference
• Range

cell reference that adjusts to a new location when copied or moved

• Relative Cell Reference
• Absolute Cell Reference
• Mixed Cell Reference
• Range

the position of data within a cell

• Format
• Centered
• Mixed Cell Reference
• Alignment

returns the average (arithmetic means) of its arguments

• SUM
• AVERAGE
• WHATIF
• SUMIF