Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Databases With PostgreSQL From Novice To Professional

Authors: Richard Stones, Neil Matthew

2nd Edition

1590594789, 978-1590594780

More Books

Students also viewed these Databases questions

Question

=+ (b) Do the same for p = 2.

Answered: 1 week ago

Question

4. Does cultural aptitude impact ones emotional intelligence?

Answered: 1 week ago