GOODWIN.XLS
Please read ALL directions before starting Excel. Save as GOODWIN.
If there are any discrepancies between THESE directions and the ones I
PRINTED for you, follow the PRINTED ones.
1. Copy the spreadsheet (students received a paper copy)into Excel,
except:
2. Leave numerical values blank for all the totals in rows 14 (Tot Op
Exp) and 16 (Op Income) as well as column F (YTD)
3. Make sure to use the fill cell alignment for the lines in rows 3, 5,
13, and 15.
4. Type all values with no symbols or decimal places
5. For all labels, copy the text exactly as shown above
6. Center row 1 across all 6 columns, and center each cell in row 2
7. Type the appropriate formulas in the blank cells from instruction #2
above
8. Format the NET SALES and OP INCOME to be currency with two decimals,
as in the example above.
9. Format all other values currency, except no dollar sign ($)
10. Change all fonts to Arial 12. Freeze at cell B6.
11. Set the width of each column to an appropriate value.
12. Set to print (but dont actually print) in landscape with you name as
a header and the date as a footer
13. Change the sheet name to DATA; delete sheet2 & sheet3
14. Save and close. (more to follow)
Graphing
Create a Pie Chart (GOODPIE), A Line Graph (GOODLINE) and a Column Graph
(GOODBAR), whichever is appropriate, to satisfy the following conditions:
1. A graph to show the change between the NET SALES over the 4 quarters.
2. A graph to show the % relationship between the 5 operating expenses in Q2.
3. A graph to compare the Tot Op Exp to the Op Income for all 5 time periods.
All graphs should be properly labeled.