Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions