Question: Note for Excel Component: You are highly advised to refer to YouTube videos on how to use SUM (), COUNTIFS (), AND how to do

Note for Excel Component: You are highly advised

Note for Excel Component: You are highly advised to refer to YouTube videos on how to use SUM (), COUNTIFS (), AND how to do PIE CHARTS. Please adhere to the date and time for submission deadline File 02: Excel Worksheet (see attached Excel Sheet) (60 points]: Complete the following using in-built excel functions: a. The total number of global cases. Refer to column B-use SUM (). Report the value in column G (10 points] b. The total number of deaths. Refer to column C- use SUM (). Report the value in column G. [10 points] C. The total number of cases reported in the USA. Use COUNTIES (). Example for Argentina (ARG): ECOUNTIFS (E: E,"ARG", B: B,">0"). Report the value in column G. (10 points] d. The total number of cases reported in Canada. Use a similar formula as shown above and substitute CAN from column E. Report the value in column G. (10 points] e. The total number of cases reported in Brazil. Use a similar formula as shown above and substitute BRA from column E. Report the value in column G. (10 points] f. Do a Pie Chart for above three countries USA, Brazil and Canada to depict the total number of Covid-19 cases. [10 points) Note for Excel Component: You are highly advised to refer to YouTube videos on how to use SUM (), COUNTIFS (), AND how to do PIE CHARTS. Please adhere to the date and time for submission deadline File 02: Excel Worksheet (see attached Excel Sheet) (60 points]: Complete the following using in-built excel functions: a. The total number of global cases. Refer to column B-use SUM (). Report the value in column G (10 points] b. The total number of deaths. Refer to column C- use SUM (). Report the value in column G. [10 points] C. The total number of cases reported in the USA. Use COUNTIES (). Example for Argentina (ARG): ECOUNTIFS (E: E,"ARG", B: B,">0"). Report the value in column G. (10 points] d. The total number of cases reported in Canada. Use a similar formula as shown above and substitute CAN from column E. Report the value in column G. (10 points] e. The total number of cases reported in Brazil. Use a similar formula as shown above and substitute BRA from column E. Report the value in column G. (10 points] f. Do a Pie Chart for above three countries USA, Brazil and Canada to depict the total number of Covid-19 cases. [10 points)

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 General Management Questions!

Chart Assignment: After reviewing Ch. 10 of aplia in the text, you will put your knowledge to work. You will be constructing charts based on the information below. You must use the information found...

MGMT 2100 - Assignment #1: Spreadsheet Skills General Instructions: For this assignment you will complete a tutorial introduction to some important features of Microsoft Excel, and then search for...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

I am looking for the solution or guidance with the following case study. The case study has been asked about by other students but I cannot find the solution. can you direct me to it or provide some...

Please I have an article on which the questions come from. Please feel out the form appropriately. Please let me know if you can do a good job on this. I have similar exercise coming. Thanks ARTICLE...

Hello, I am needing help on this assignment please ASAP so I can study it as I have a test on Thursday over this and many other things. let me know if there are any questions. Thank you. UNITED...

I need two ratios provided based on the financial statement of a company (fullfinancial attached). I need the price-earnings ratio (the formula of price per share divided by earnings per share) and...

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

Please be sure to not copy any answers verbatim. original answers needed will be scanned through the safe-assign system. read the Marketing Debate below What is the Best Way to Position a brand? and...

A bank has rate-sensitive assets of $200 and rate-sensitive liabilities of $250. What is the change in net interest income when interest rates increase by 0.50 percentage points? Write the $ number...

A vertical cylinder with a heavy piston contains air at a temperature of 300 K. The initial pressure is 200 kPa, and the initial volume is 0.350 m3. Take the molar mass of air as 28.9 g/mol and...

Your company is planning to issue $ 1 , 0 0 0 bonds with a stated interest rate of 7 % and a maturity date of July 1 5 , 2 0 2 5 . If interest rates rise in the economy so that similar financial...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...