Excel Vocabulary

2. Used by Pie chart as a visual representative ___________ of the pie.
5. Data point values displayed in table below chart. (2 words)
8. Always starts with an = sign to calculate a value.
12. How text or numbers are positioned (either horizontally or vertically) within a cell.
13. To open this, click on F7. (2 words)
15. Uses a $ before the row and column address so the cell reference location remains constant.
17. Refers to the cell's address when using formulas. (2 words)
18. A type of conditional formatting using color and icon sets to visually represent a cell in comparison to other cell values. (2 words)
20. Type of formatting applied to cells based on value.
22. An electronic ledger to enter data.
24. Functions require you to provide input to calculate a value.
25. The type of operator used by the IF function Logical_test argument.
26. Represents numeric values using a graphic.

1. Click this button to remove filtering. (2 words)
3. Will select the entire column when clicking on box with the column letter. (2 words)
4. Cell with formula that refers to the value/formula in selected cell.
6. Custom colors require you to click this at the bottom of the font color palette. (2 words)
7. Calculates intersecting totals and summarizes data. (2 words)
9. A type of cell reference that shifts when copying a formula to a new location.
10. Appears next to a formula with a potential error to help resolve error. (2 words)
11. Predefined settings to create a new file.
13. Visual representation of filtering options.
14. These usually appear in the worksheet in the color blue. (2 words)
16. The Set cell box used by Goal Seek is called the __________cell.
19. Bar charts use this to display on the vertical axis with data points along the horizontal axis.
21. Cells in sequential order displaying a recognizable pattern. (2 words)
23. If you see this #DIV/0, you have a(n) _______.
25. Default name for sheet when moving a chart to a new sheet.