Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started