Excel Text Function Quiz

Question 1

Which function would you use to remove all extra spaces from a cell except for single spaces between words?

Question 2

What is the primary difference between the FIND and SEARCH functions?

Question 3

Which function joins multiple text strings but allows for a custom delimiter (like a comma) and can ignore empty cells?

Question 4

To get the word 'Excel' from 'ExcelClash' starting from the left, which formula is correct?

Question 5

The LEN function is used to:

Question 6

Which function converts every word in a string to begin with a capital letter (e.g., 'john doe' to 'John Doe')?

Question 7

What does =REPT('$', 5) return?

Question 8

If A1 contains 'Product-123', what does =SUBSTITUTE(A1, '-', '/') return?

Question 9

Which function converts a numeric string, such as '$1,200', into an actual number that Excel can calculate?

Question 10

Using the TEXT function, how would you format a date in A1 to show only the full name of the weekday (e.g., 'Monday')?

Question 11

The EXACT function returns:

Question 12

If you need to extract the 3 characters in the middle of a string starting at index 5, which function must you use?

Question 13

Which function removes non-printable characters (like line breaks) from a string imported from another system?

Question 14

What is the result of =UPPER('Excel')?

Question 15

In the formula =REPLACE(A1, 1, 3, 'New'), what does the '1, 3' signify?