GRADE 12 EXCEL FUNCTIONS

Edit Answers
1234567891011121314151617181920
Across
  1. 3. to join two or more text strings into one string.
  2. 4. Rounds a number down to the nearest integer.
  3. 7. Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.
  4. 9. Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
  5. 11. Used when you want to replace specific text in a text string.
  6. 14. returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
  7. 15. Converts a text string that represents a number to a number.
  8. 16. Returns the serial number of the current date and time.
  9. 17. Returns a Variant (String) containing a specified number of characters from the left side of a string.
  10. 19. returns the number of characters in a text string.
  11. 20. Truncates a number to an integer by removing the fractional part of the number.
Down
  1. 1. Returns a Variant (String) containing a specified number of characters from the right side of a string.
  2. 2. Rounds a number up, away from 0
  3. 5. used when you need to take three separate values and combine them to form a date.
  4. 6. Converts text to lowercase.
  5. 8. Rounds a number down, toward zero.
  6. 10. replaces part of a text string, based on the number of characters you specify, with a different text string.
  7. 12. Returns the serial number of the current date.
  8. 13. Converts text to uppercase.
  9. 18. Finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text.