Microsoft Office Tutorials and References
In Depth Information
In the Lab
5. Create a pie chart that shows the revenue contributions of each sales channel. Chart the sales channel
names (B3:D3) and corresponding totals (B17:D17). That is, select the range B3:D3, and then while
holding down the ctrl key, select the range B17:D17. Insert the Pie in 3-D chart, as shown in
Figure 1– 80, by using the Pie button (Insert tab | Charts group). Use the chart location F3: K17.
6. Apply the worksheet name, Semiannual Revenue, to the sheet tab and apply the Purple, Accent 4,
Lighter 80% color to the sheet tab. Change the document properties, as specii ed by your instructor.
7. Save the workbook using the i le name, Lab 1-2 Play ‘em Again Semiannual Revenue. Print the
worksheet in landscape orientation.
8. Two corrections to the i gures were sent in from the accounting department. The correct revenue
is $118,124.45 for Cell Phones sold through the mail (cell B5) and $43,573.67 for iPods sold over
the Web (cell D11). After you enter the two corrections, the company total in cell E17 should equal
$8,723,956.77. Print the revised worksheet in landscape orientation.
9. Use the Undo button to change the worksheet back to the original numbers in Table 1– 8. Use the
Redo button to change the worksheet back to the revised state.
10. Close Excel without saving the latest changes. Start Excel and open the workbook saved in Step 7.
Double-click cell E6 and use in-cell editing to change the PSPs revenue (cell C14) to $128,857.32.
Write the company total in cell E17 at the top of the i rst printout. Click the Undo button.
11. Click cell A1 and then click the Merge & Center button on the Home tab on the Ribbon to
split cell A1 into cells A1, B1, C1, D1, and E1. To merge the cells into one again, select the range
A1:E1 and then click the Merge & Center button.
12. Close the workbook without saving the changes. Submit the assignment as specii ed by your instructor.
In the Lab
Lab 3: Projected College Cash Flow Analysis Worksheet
Problem: Attending college is an expensive proposition and your resources are limited. To plan for
your four-year college career, you have decided to organize your anticipated resources and expenses
in a worksheet. The data required to prepare your worksheet is shown in Table 1– 9.
Table 1– 9 College Cost and Resources
Resources
Freshman
Sophomore
Junior
Senior
529 Plans
2700.00
2889.00
3091.23
3307.62
Financial Aid
5250.00
5617.50
6010.73
6431.48
Job
3100.00
3317.00
3549.19
3797.63
Parents
3700.00
3959.00
4236.13
4532.66
Savings
4250.00
4547.50
4865.83
5206.43
Other
1100.00
1177.00
1259.39
1347.55
Expenses
Freshman
Sophomore
Junior
Senior
Activities Fee
500.00
535.00
572.45
612.52
Books
650.00
695.50
744.19
796.28
Clothes
750.00
802.50
858.68
918.78
Entertainment
1650.00
1765.50
1889.09
2021.32
Room & Board
7200.00
7704.00
8243.28
8820.31
Tuition
8250.00
8827.50
9445.43
10106.60
Miscellaneous
1100.00
1177.00
1259.39
1347.55
Continued >
Search JabSto ::




Custom Search