Across
- 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.
Down
- 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.