In this assignment you are going to learn the basics of Microsoft Excel. Most of you have never used this program before. The first thing I want you to do is to watch the tutorial video that I made. Go to the Video (V) Drive. Inside the Video Drive, I want you to click the following: Video>Osborne>Computer Tutorials>Excel Basics.

After you watch the video, you need to open Microsoft Excel. It opens the same way as Word and PowerPoint. I want you to create a document that has:

1. Three Headings- Countries, Population, $GDP    I want you to use size 18 font for the headings and make them bold.

2. In the countries column there are 15 countries I want you to include. They are: United States, China, Japan, India, Iraq, Afghanistan, Egypt, Brazil, Mexico, Guatemala, Russia, South Africa, Germany, France, and United Kingdom.

3. In the population column, you need to go to Google and type <name of country> population. Type their exact population next to the correct country in the population column.

4. In the $GDP column, you need to use this link to find the GDP per capita in each of the countries.  Type the GDP for each country in the column. Make sure you use dollar signs. If you want to you can do what I did in the video and highlight the column and change the numbers to currency instead of typing the $ sign. There should be no extra zeros after the decimal place. You shouldn’t even have a decimal place on chart. The video shows you how to do this.

5. After each column is finished, make a 2-D Column Chart for population. You will do it the exact same way that I did in the video.

6. Make a 2-D Bar Graph for GDP. You will do it the exact same way that I did in the video.

After you finish save it.  hr-last name-last name-Excel

Turn it in.

***2 Tips***

1. You can’t have the word million or billion in your spreadsheet. Make sure you only use numbers. If you include words in your cells, it will mess up the charts and graphs.

2. Make sure that you only highlight the selected cells that have data. If you highlight extra cells that don’t have data, they will mess up the charts and graphs.