Excel Formulas

12345678910111213
Across
  1. 3. A logical function used to test multiple conditions with OR logic.
  2. 4. A function used to round a number up to the nearest integer.
  3. 6. A function that calculates the sum of products from corresponding ranges in multiple arrays or ranges.
  4. 8. A function that rounds a number to the nearest multiple.
  5. 9. A logical function used to test multiple conditions with AND logic.
  6. 11. A function to handle errors and return a specific value when an error occurs.
  7. 12. A function used to format a value as text with a specified format.
  8. 13. A function that extracts the numeric value from a text string.
Down
  1. 1. A function for rounding numbers to a specified number of decimal places.
  2. 2. A function that capitalizes the first letter of each word in a text string.
  3. 5. A function used to calculate the total of a range of numbers.
  4. 7. A function used to combine text from multiple cells into one.
  5. 10. A function used to count the number of cells with values in a range.
  6. 11. A logical function used for conditional testing in Excel.