Microsoft Office Tutorials and References
In Depth Information
In the Lab
6. Update the document properties with your name, course number, and name for the workbook.
7. Save the workbook using the ﬁ le name, Lab 1-2 Scissors Ofﬁ ce Supply Annual Sales. Print the
8. Two corrections to the ﬁ 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 Nonproﬁ 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 ﬁ rst printout.
Click the Undo button.
11. Click cell A1 and then click the Merge & 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 & Center button on the Home tab on the Ribbon.
12. Close the workbook without saving the changes. Submit the assignment as requested by your
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
Room & Board