Spreadsheet Practice Ch10

Directions: The tables below represent total U.S. import and exports during a recent year. Create two pie charts illustrating the infromation in the table using your spreadsheet program.

 

EXPORTS (in tens of millions of dollars)
IMPORTS (in tens of millions of dollars)
Agricultural products
469
Agricultural products
367
Other manufactured goods
3,878
Other manufactured goods
7,005
Machinery
297
Machinery
314
Electrical machinery
749
Electrical machinery
886
Chemicals
705
Chemicals
622
Mineral fuels
98
Mineral fuels
752

 

  1. Start your spreadsheet program.
  2. Save the assignment in your Excel folder as: Excel_practice_ch10
  3. Enter the information into your spreadsheet, using the headings "Imports" and "Exports."
  4. Convert the information in each table into a pie chart using your charting application. (You should have two pie charts)
  5. Insert a header on your page which includes your name, date and assignment.
  6. Print our a copy of your work with your paper landscape fit to one page.