Excel Functions

12345678910111213141516171819202122
Across
  1. 2. FIND locate one text string within a second text string. They return the number of the starting position of the first text string from the first character of the second text string.
  2. 4. function Use this function to add the values in cells.
  3. 7. Capitalizes the first letter in each word of a text value
  4. 9. Use this function when you need to find things in a table or a range by row. For example, look up an employee's last name by her employee number, or find her phone number by looking up her last name (just like a telephone book). Check out this video about using VLOOKUP.
  5. 10. Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
  6. 11. Counts how many numbers are in the list of arguments
  7. 13. Returns the average of its arguments
  8. 16. Use this function to return the sequential serial number that represents a particular date. This function is most useful in situations where the year, month, and day are supplied by formulas or cell references. For example, you might have a worksheet that contains dates in a format that Excel does not recognize, such as YYYYMMDD.
  9. 17. Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
  10. 19. Converts text to lowercase
  11. 20. Use this function to return the number of days between two dates.
  12. 21. Use this function to search for an item in a range of cells, and then return the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 7, and 38, then the formula =MATCH(7,A1:A3,0) returns the number 2, because 7 is the second item in the range.
  13. 22. Returns the current date and time.
Down
  1. 1. function Use this function to return one value if a condition is true and another value if it's false. Here's a video about using the IF function.
  2. 3. Use this function to return a value or the reference to a value from within a table or range.
  3. 5. Converts text to uppercase
  4. 6. Use this function when you need to look in a single row or column and find a value from the same position in a second row or column.
  5. 8. Joins several text items into one text item
  6. 10. Use this function to select one of up to 254 values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.
  7. 12. Returns the average of its arguments, including numbers, text, and logical values
  8. 14. Returns the rightmost characters from a text value
  9. 15. Returns the maximum value from the list of arguments
  10. 18. Returns the current date.
  11. 21. Returns the minimal value from the list of arguments.