EXCEL 365 Functions CROSSWORD

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