Digital audio is a relatively new medium for storing and reproducing music. Before albums were sold on CD and other digital media formats, analog recordings were commonly sold as vinyl records, eight$-$track tapes, and cassette tapes. We want to build a worksheet to help us compare these different media formats to observe how information storage has progressed over the past $50$ years. Note the following media equivalencies:

A $74-$minute CD $(44\mathrm{.}1$ kilohertz, $2$ channel, $16-$bit digital audio$)$ can hold $650$ MB of data.

A single$-$sided, single$-$layer DVD can hold $4\mathrm{.}7$ GB of data $($~$4813$ MB$,547$ minutes of $44\mathrm{.}1$ kilohertz, two$-$channel, $16-$bit digital audio$).$

A single$-$sided, single$-$layer Blu$-$ray disc can hold $25$ GB of data $($~$25,600$ MB$,2914$ minutes of $44\mathrm{.}1$ kilohertz, two$-$channel, $16-$bit digital audio$).$

A $7-$inch vinyl record recorded at $45$ rpm can hold $9$ minutes of music.

A $7-$inch vinyl record recorded at

rpm can hold $12$ minutes of music.

A $12-$inch vinyl record recorded at $45$ rpm can hold $24$ minutes of music.

A $12-$inch vinyl record recorded at

rpm can hold $36$ minutes of music.

An eight$-$track tape can hold $46$ minutes of music.

A typical cassette tape can hold $60$ minu

The User should introduce the quantity in Cell A$9,$ he should be able to select the appropiate format from a drop$-$ Down menu.

$2.$ In this cell A$9,$ the user should be able to introduce whole numbers only $($Greater thatn or iqual to zero$).$ And an input message should be displayed letting the user know this. An error message should be displayed if the user introduces anything else.

$3.$ Determine audio equivalencies between these different storage formats