Excel Terminology Test Review

Edit Answers
12345678910111213141516171819202122
Across
  1. 2. All Excel formulas must start with an ___________ sign.
  2. 4. Earned income after all deductions have been taken out.
  3. 5. Mathematical expressions that can add, subtract, multiply & divide.
  4. 7. Earned income (for each pay period) before deductions are taken out.
  5. 9. Runs horizontally and are represented by a number.
  6. 11. A select group of cells
  7. 12. Refers to the Order of Evaluation mathematical protocol followed in a multi-operational formula.
  8. 14. Function that will find the total of values in a range of cells.
  9. 15. Function that will find the lowest value in a range of cells.
  10. 17. Identifies each cell and is used in formulas.
  11. 18. Shortcut used to place a cell in "edit mode".
  12. 21. Displays a formula in a cell that has been selected.
Down
  1. 1. Data that appears with a dollar sign and two digits to the right of the decimal.
  2. 3. A grid of numbered rows and lettered columns.
  3. 6. Refers to cells whose address remains the same when formulas are copied to other cells ($B$4).
  4. 8. MS Word files are saved documents, MS Excel files are saved ___________.
  5. 9. Refers to cells whose address changes when formulas are copied to other cells.
  6. 10. Created when a row and column intersect each other.
  7. 13. Shortcut used to make a cell absolute.
  8. 16. Located under ribbon, displays address of a selected cell.
  9. 19. Function that will count the number of cells with numbers or letters.
  10. 20. Function that will find the highest value in a range of cells.
  11. 22. Function that will find the average value from a range of cells.