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 tab relates to the tracks sold by Sonic Selection. Use the following instructions to search for words in the dataset: In Cell K 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 N 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. 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 Ns value as opposed to hardcoding it
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
