Microsoft Office Tutorials and References
In Depth Information
In the Lab
EX 77
6. Update the document properties with your name, course number, and name for the workbook.
7. Save the workbook using the fi le name, Lab 1-2 Scissors Offi ce Supply Annual Sales. Print the
worksheet.
8. Two corrections to the fi gures were sent in from the accounting department. The correct sales
are $98,342.16 for Miami’s annual Small Business sales (cell C5) and $48,933.75 for
St. Louis’s annual Nonprofi t sales (cell D8). After you enter the two corrections, the company
total in cell F9 should equal $2,809,167.57. Print the revised worksheet.
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 Santa Fe annual Large Business
sales (cell E6) to $154,108.49. Write the company total in cell F9 at the top of the fi rst printout.
Click the Undo button.
11. Click cell A1 and then click the Merge and Center button to split cell A1 into cells A1, B1,
C1, D1, E1, and F1. To merge the cells into one again, select the range A1:F1 and then click the
Merge and Center button on the Home tab on the Ribbon.
12. Close the workbook without saving the changes. Submit the assignment as requested by your
instructor.
In the Lab
Lab 3: College Cost and Financial Support 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 costs in a
worksheet. The data required to prepare your worksheet is shown in Table 1–9.
Table 1–9 College Cost and Resources
Cost
Freshman
Sophomore
Junior
Senior
Books
450.00
477.00
505.62
535.95
Room & Board
7500.00
7950.00
8427.00
8932.62
Tuition
8200.00
8692.00
9213.52
9766.33
Entertainment
1325.00
1404.50
1488.77
1578.10
Miscellaneous
950.00
1007.00
1067.42
1131.47
Clothes
725.00
768.50
814.61
863.49
Financial Support
Freshman
Sophomore
Junior
Senior
Job
3400.00
3604.00
3820.24
4049.45
Savings
4350.00
4611.00
4887.66
5180.92
Parents
4700.00
4982.00
5280.92
5597.78
Financial Aid
5500.00
5830.00
6179.80
6550.59
Other
1200.00
1272.00
1348.32
1429.22
Continued >
Search JabSto ::




Custom Search