Excel Formulas Concepts Vocab

1234567891011121314
Across
  1. 3. displays only data which meets certain criteria
  2. 4. grid of rows and columns in which text and numbers are entered and results are calculated
  3. 10. address of a cell range based on the relative position of the cell
  4. 11. expression which returns a value
  5. 13. points to a specific cell and does not change when copied and includes dollar signs the reference name
  6. 14. mathematical operator used for subtraction
Down
  1. 1. allows users to quickly copy formulas or data down a column or across a row
  2. 2. contains both relative and absolute references
  3. 5. acronym for order of operations
  4. 6. a button in the formula auditing group to display formulas
  5. 7. mathematical operator used for multiplication
  6. 8. mathematical operator used for division
  7. 9. address of a cell indicating its column and row location
  8. 12. mathematical operator used for addition