Question: The worksheet in the Answer 4 tab relates to the tracks sold by Sonic Selection. Use the following instructions to search for words in the

The worksheet in the Answer 4 tab relates to the tracks sold by Sonic Selection. Use the following instructions to search for words in the dataset:1. In Cell K2, use the FIND function to look up a word within the "TrackName" column. The word you choose to find can be typed into the space provided in Cell N3, and the first letter of the word should be capitalised, as the FIND function is case sensitive. The FIND function will return the starting position of the string within the "TrackName" column if the word exists within "TrackName". The function will return a #VALUE! Error if the word is not found. 2. Apply the function to all of the cells in Column K. Remember you can apply the filter function if you would like to exclude all the songs that do not have the word you chose in the title. (Hint: Make sure you reference Cell N3s value as opposed to hardcoding it.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!