EXCEL 365 Functions CROSSWORD

1234567891011121314151617181920212223
Across
  1. 2. Returns the largest number in a range.
  2. 4. Counts empty cells in a range.
  3. 6. Returns the mean value of selected numbers.
  4. 8. Counts the number of cells that meet a condition.
  5. 9. Counts non-empty cells (numbers, text, etc.).
  6. 12. Adds all numbers in a range (total of).
  7. 14. Returns a list of unique values from a range.
  8. 15. Returns the number of characters in a cell or text.
  9. 17. ____ reference A cell reference that changes when copied to another cell (e.g., A1).
  10. 19. Joins text with a delimiter, optionally ignoring empty cells.
  11. 22. Counts numeric values in a range (the number of).
  12. 23. Extracts characters from the end of a text string.
Down
  1. 1. Joins two or more text strings into another cell.
  2. 2. Returns the smallest number in a range.
  3. 3. Converts text to lowercase.
  4. 5. ____ Reference A cell reference that remains fixed when copied, using dollar signs (e.g., $A$1).
  5. 7. Returns one value if a condition is TRUE, another if FALSE.
  6. 10. Averages values based on a condition.
  7. 11. ____ Reference A cell reference that locks either the row or the column (e.g., $A1 or A$1).
  8. 13. Converts text to uppercase.
  9. 16. Extracts characters from the middle of a text string.
  10. 18. Extracts characters from the start of a text string.
  11. 20. Adds values based on a condition.
  12. 21. Returns a sorted version of a range.