excel

Edit Answers
1234567891011121314151617181920
Across
  1. 4. searches for a value in the first column of a table and returns a corresponding value from another column.
  2. 6. combines multiple text strings into one.
  3. 7. creates a clickable hyperlink within a cell.
  4. 8. counts the number of cells containing numeric values.
  5. 13. evaluates a condition and returns one value if true, another if false.
  6. 14. combines text from multiple cells into one string.
  7. 15. creates a date value from year, month, and day components.
  8. 18. counts the number of cells meeting a specific condition.
  9. 20. checks if all specified conditions are true.
Down
  1. 1. finds the largest number in a range.
  2. 2. returns the current date.
  3. 3. calculates the total of a range of cells.
  4. 5. retrieves a value from a specified range based on row and column numbers.
  5. 9. checks if at least one specified condition is true.
  6. 10. extracts a specified number of characters from the end of a text string.
  7. 11. extracts a specified number of characters from the beginning of a text string.
  8. 12. calculates the average of a range of numbers.
  9. 16. searches for a value in a range and returns its position.
  10. 17. rounds a number to a specified number of decimal places.
  11. 19. transposes rows into columns and vice versa.