ShoA$\mathrm{.}1$ Creating New Spreadsheet

Within the dataset workbook, create a separate spreadsheet named $$Part A Solution$$ next to Raw

Data. In Part A Solution construct a simple table which include all team members$$ name, email

address and Contribution$(\%).$

Raw Data Part A Solution

Provide an appropriate table header and highlight the team leader$$s name. Team Leader will be

responsible for the submission of the final work $($final version of the spreadsheet, any other

submission by members will not be accepted.$)$

Your file name for the submission to Blackboard should be Group xx DM$.$xls where xx is your group

number.

NOTE: You are expected to format and style all the tables in this spreadsheet with reference to the

following questions. Please label the table with reference to the question answered.

A$2$ Top $10$ Countries with COVID$19$

Create a second table below the team members table, list down the top $10$ countries with highest total

COVID$19$ cases and display the data of the top $10$ countries identified. Do not just Copy$/$Paste from

Raw Data, use excel function to extract and display data appropriately.

Number Country Total COVID cases

A$3$w me the steps to solve