Lab Work ( 10/11)
Assignment 1: Use the Worksheet file " College Cash Flow Analysis.xls"
and follow the steps below (refer figure 1-83 in page E 1.62)
- Type "Total" in cell A8, A16, F3 & F10
- Use the AutoSum button to calculate the totals in rows 8 and 16 and column
F
- Increase the font in the worksheet title to 24 and change its color to
red. Center the worksheet title in cell A1 across columns A through F.
Increase the font size in the table titles in cells A2 and A9 to 18 and change
their color to green.
- Format the range A3:F8 using the AutoFormat command on the Format menu as
follows:
- Select the range A3:F8 and then apply the table format Accounting 1
- with the range A3:F8 still selected, apply that table format List 1.
- Format the range A10:F16 using the AutoFormat command on the Format menu as
follows:
- Select the range A10:F16 and then apply the table format Accounting 1
- with the range A10:F16 still selected, apply that table format List 1.
- Chart the range A4:B7 and draw a 3-D Pie Chart in the range G3:J8 that
shows the contribution of each category of resource for the freshman year.
- Add the Pie chart title "Freshman Resources" in cell G2
- Change the font of the pie chart title to 12-point, bold green. Center the
pie chart title over the range G2:J2
- Chart the range A11:B15 and draw a 3-D Pie Chart in the range G10:J16 that
shows the contribution of each category of expense for the freshman year.
- Add the Pie chart title "Freshman Expenses" in cell G9
- Change the font of the pie chart title to 12-point, bold green. Center the
pie chart title over the range G9:J9
- Save your work and email to
capstoneatccsu@yahoo.com
Assignment 2: Cases and Places - Problem 5 (page E 1.64 in your
text book). Email your finished work to
capstoneatccsu@yahoo.com.