The file named PS$2-$Q$2.$xlsx contains sales data on the world$$s $2,000$ largest companies. You are trying to

get a company ranking based on revenue and create the following sentence.

ExxonMobil ranking #$1$ in revenue has revenue of $$328\mathrm{.}21$

What$$s in the red would be different based on your selected rank. $($No need to change the color of the

font ro red$)$

Your task is to create a formula to get the desired sentence. If an integer between $1$ and $2000$ is entered

in cell B$3,$ then cell C$3$ should return a sentence such as the company ranking #$1$ in revenue has revenue

of $$328\mathrm{.}21.$ Use the TEXT function to ensure the dollar amount has the proper format.

$$ For example, you entered the $1$ in B$3.$ Your C$3$ output should look like this:

ExxonMobil ranking #$1$ in revenue has revenue of $$328\mathrm{.}21$

$$ For example, you entered the $4$ in B$3.$ Your C$3$ output should look like this:

BP ranking #$4$ in revenue has revenue of $$249\mathrm{.}47$