using the ticker(subject to used input) enter formulae in thecalls below (in yellow) that will return the desiredinformation Consider the data to the left. Please answer the following questions. (Mcap and Revenue in millions of \$) 1. Using data validation, validate the blue input cell below to include the list of tickers i 2 answers