ExcelAssignment1

# ExcelAssignment1 - Instructions: 1. For all the reported...

This preview shows pages 1–2. Sign up to view the full content.

Instructions: 1. For all the reported months in 2008, 2009, and 2010: A. Use a formula to calculate the Total Imports. The Total Imports value is equal to the Import Goods plus Impor t B. Use a formula to calculate the Total Exports. The Total Exports value is equal to the Export Goods plus Expo r C. Use a formula to calculate Balance of Goods. The Balance of Goods is equal to the Goods Export minus the G D. Use a formula to calculate the Balance of Services. The Balance of Services is equal to the Services Export m E. Use a formula to calculate the Total Balance. The Total Balance value is equal to the Balance of Goods plus t h A.Use a Line with Markers chart B. Select one year of Total Balance data to graph (select the January through December data) C. On the INSERT Tab, drop down Line charts to find the Line with Markers Chart D. Right click on the chart and choose Select Data from the menu E. Add the other years of data. Make sure the Series Name is set for each series of data A. Use the same method as you did in step 2 4. Graph 2008, 2009, and 2010 Total Imports A. Use the same method as you did in step 2. 5. In Graphs from step 3 & 4, A. Right click on the axis which contains the money values B. Select Format Axis from the menu C. Set the Minimum value to 50,000.00

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 03/09/2011 for the course INFO SYSTE 3263 taught by Professor Drmichellehepner during the Spring '11 term at University of Central Oklahoma.

### Page1 / 6

ExcelAssignment1 - Instructions: 1. For all the reported...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online