Question: simple chart in Excel can say more than a sheet full of numbers. Your research requires you to gather current population data of countries around

simple chart in Excel can say more than a sheet full of numbers. Your research requires you to gather current population data of countries around the world and present them into a graph.
Your tasks are:
Research online and obtain the data of 20 populated countries in the world of your choice.
Using MS Excel, create a spreadsheet to store these data (country names and their populations).
In cell A1, type your full name. Bold and change its font type, font size and color of your choice. Select A1...B1, and choose Merge & Center.
In cell A2, type "=now()" as the formula that returns the current date and time. Format the cell to Long Date.
In cell A4, enter the Uniform Resource Locator (URL), the hyperlink to your online resource. Select A4...D4 and choose Merge & Center.
In cell B6, type "Country" and in cell C6, enter "Population." These will serve as column headers. Center, bold and change their font type: Arial and font size to 16. Change their font color to Blue.
From cell B7...B27, enter the country names from your resource. Change their font color to Dark Red.
From cell C7...C27, enter the country populations from your resource. Change their font color to Dark Green.
Insert a 2-DimensionClustered Bar Chart to show the proportions of the populations by their countries.
Protect the worksheet's cells from any modifications. Use your first name in uppercase as the password.
Save your workbook as Populations_By_Countries.xlsx and submit.

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 Databases Questions!