ranked first. Using the dataset, write a formula (in a separate worksheet) using the INDEX and MATCH functions and named ranges to display (based on a country and metric which the user of your worksheet chooses) the data for the request. For example, if the user chooses the country,Canadaand the metric,Total Cases, the formula result should display107,021. Set data validation restricting the selection of the country and metrix to those listed on the dataset. If no country or metric is selected, the result should not display # N/A.

2.- Using the dataset in theworldometers, write formulas (in a separate worksheet) to provide the following information:

a. In countries in which total cases were at least 100,000 cases, what is the average number of total deaths?

b. How many total tests were conducted by countries beginning with \"C\"?

c. How many countries have below average cases?

Rank	Country	Total Cases	Total Deaths	Total Recovered	Active Cases	Serious and Critical Cases	Total Cases per 1 M Pop	Deaths per 1 M Pop	Total Tests	Tests per 1 M Pop	Population
12	USA	########	136,136	########	########	15,645	9,811	411	########	122,290	########
15	Brazil	########	69,316	########	507,351	8,318	8,289	326	########	21,234	########
112	India	819,986	22,135	514,457	283,394	8,944	594	16	########	7,987	########
28	Russia	713,936	11,017	489,068	213,851	2,300	4,892	75	########	153,411	########
14	Peru	316,448	11,314	207,802	97,332	1,292	9,595	343	########	56,495	########
5	Chile	309,274	6,781	278,053	24,440	1,990	16,175	355	########	65,657	########
21	Spain	300,988	28,403	N/A	N/A	617	6,438	607	########	122,651	########
32	UK	288,133	44,650	N/A	N/A	185	4,244	658	########	169,947	########