Excel Lesson 2 Vocabulary

1234567891011121314151617181920
Across
  1. 3. Information that appears at the top of each page
  2. 6. An Excel feature that looks for patterns in the data and automatically fills or formats data in remaining cells based on those patterns.
  3. 7. the space between the page content and the edges of the page.
  4. 8. The sequence in which operators are applied in a calculation.
  5. 12. An Excel function that calculates the average value of a collection of numbers.
  6. 13. Short for picture element, an individual point of color on a display screen or printout.
  7. 14. Information that appears at the bottom of each page
  8. 15. An Excel feature that automatically increases or decreases the width of a column so that the widest entry will fit.
  9. 16. is a series of two or more adjacent cells in a column, row, or rectangular group of cells. Example: B5:C10
  10. 17. A predefined, coordinated set of colors, fonts, graphical effects, and other formats that can be applied to give the worksheet a consistent appearance.
  11. 18. The enhancement of how content appears on the screen by changes to its font, size, color, or alignment.
  12. 20. special formatting that is applied if cell values meet specified criteria
Down
  1. 1. A letter, number, symbol, or punctuation mark.
  2. 2. checks which cells are referenced in the formula assigned to the active cell.
  3. 4. The Excel view that shows how the sheet will look when printed.
  4. 5. A function used to determine the lowest number in a range.
  5. 9. is the process of finding and correcting errors in a worksheet.
  6. 10. A cell reference that automatically changes to reflect the new location when the formula is copied or moved.
  7. 11. a function that displays the highest value in a range.
  8. 19. An Excel mode that lets you select cells to use in a formula by using the pointer.