| A | B |
|---|
| Advanced Filter | Only certain items that are specified will show up in your findings. |
| PivotTable | A sophisticated tool that summarizes data quickly. |
| Subtotal | The total of a group of items within a larger set of items. |
| AutoSum | A button/function used to add up all numbers in a columns and/or row. |
| Precedent | A cell whose value is used to find the value of another cell. |
| Dependent | If the value of one cell is used to find teh value of a second cell, the this is the second cell. |
| Scenario | A version of your data that you save and name. |
| What-If-Analysis | A comparison test, which test at least 2 possible outcomes. |
| Constraint | Limits totals so they cannot be changed. |
| Database Function | A formula that acts on only those items that meet certain criteria. |
| Conditional Formatting | Formats a cell only if it meets certain "conditions" |
| Brightness | Makes the graphic either lighter or darker. |
| Contrast | Makes objects within the graphic either lighter or darker. |
| Crop | Trimming off part of the graphic. |
| Rotate | Turning a graphic clockwise or counter clockwise. |
| Legend | Part of a chart that indicates what each color or pattern represents. |
