GB 513 RANK Imagine Your Future /gb513rank.com GB 513 RANK Imagine Your Future /gb513rank.com | Page 2

This assignment requires you to use Excel to answer the questions
and create the charts. However when presenting reports in business,
you will find that most managers will prefer to read Word®
documents or PowerPoint® slides rather than go through Excel
sheets. Being able to move your work from Excel to Word® is a
valuable skill. For this assignment, you should copy all your charts
and comments to a Word document and submit that Word file.
Clearly label all questions and charts, as well as your answers.
Question 1
According to T-100 Domestic Market, the top seven airlines in the
United States by domestic boardings in a recent year were
Southwest Airlines with 81.1 million, Delta Airlines with 79.4
million, American Airlines with 72.6 million, United Airlines with
56.3 million, Northwest Airlines with 43.3 million, U.S. Airways with
37.8 million, and Continental Airlines with 31.5 million. Construct a
pie chart and a bar graph to depict this information.
Question 2
The U.S. Department of the Interior releases figures on mineral
production. Following are the 15 leading states in nonfuel mineral
production in the United States in 2008.
State Value ($ billions) Arizona 7.84
Nevada 6.48
Florida 4.20