Text Functions Assessment

This is the file needed to answer this assessment question: Text Functions Q1

Everything before the hyphen is a product code and the number after the hyphen is units sold. In each row extract the product family and the units sold.

This is the file needed to answer this assessment question: Text Functions Question 2

Use one VLOOKUP formula in the above file that can be copied from R6:T20 that lookups the appropriate information for each QB.

This is the file needed to answer this assessment question: Text Functions Q3

Each row in the file above lists a city’s zip code, city name, state, latitude, and longitude. Fill in the yellow cells with formulas that extract the name of the city in each row. You may assume that each Zip code is 5 characters long.

Hint: The FIND function is case sensitive.

This is the file needed to answer this assessment question: Text Functions Q4

Column E in the file above contains a QB’s name, followed by his QB rating and the number of passes completed.Create formulas in Column C that extract the QB’s number of completions.