Question: 1 . Initialize ( clear ) the data areas ( 3 ) : a . h 2 :m 4 5 on COVID worksheet b .

1. Initialize (clear) the data areas (3):
a. h2:m45 on COVID worksheet
b. a1:a45 on Cases worksheet
2. In cell j2, display the sum of the Total Deaths (Column F) in continent Asia (Column C). For this
problem
a. You can assume there are only 43 rows of data (rows 2 to 44).
b. Use an Application function for this problem. (10 pts)
3. Display in cell j4 the number of countries whose Active Cases (Column E) are greater than
300,000. Use a Do While for this problem. (12 pts)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!