Excel M1 & M2 Theory

123456789101112
Across
  1. 1. The Cell Styles command is in this tab
  2. 3. Cell reference that does not change when copied
  3. 5. Used to align currency symbols and decimal points in a column of numbers
  4. 8. Used to enter a range of text based on examples that are already in your worksheet
  5. 9. Used to format a range so that all values greater than $500 appear in red
  6. 11. A collection of characters with a similar, specific design
  7. 12. Displays the highest value in the selected range
Down
  1. 2. Used to combine multiple cells into one combined cell
  2. 4. In the formula =A8*$A$1, A8 is this type of reference
  3. 6. Order of operations followed by Excel
  4. 7. This feature inserts a function that totals the cells above or to the left of the selected cell
  5. 9. Returns cell contents to their default font and style
  6. 10. Built-in formula that helps you perform complex calculations