ECDL Excel IP

1234567891011121314151617181920
Across
  1. 3. Counts the number of cells that relate to a given condition
  2. 6. =
  3. 11. The symbol for divide
  4. 12. Adds a range of cells together
  5. 14. Parentheses
  6. 16. A selection of cells
  7. 17. Counts the amount of cells in a range with text and numerical data
  8. 18. The symbol that subtracts one cell from another
  9. 20. Returns the largest number in a range of cells
Down
  1. 1. "" or quote marks
  2. 2. Performs a logical function
  3. 3. Counts the amount of cells in a range with numerical data
  4. 4. The Symbol that adds to cells together
  5. 5. Gives you the average of a range of cells
  6. 7. <
  7. 8. What you use in IF to separate the parts of the formula
  8. 9. Counts the amount of cells in a range with no data in them
  9. 10. >
  10. 13. Rounds a number to a specified amount of decimal places
  11. 15. What goes between two cells in a range of cells also known as a Range Operator
  12. 18. Returns the smallest number in a range of cells
  13. 19. The symbol for times