Microsoft Office Tutorials and References
In Depth Information
4. Save the workbook as Distribution Chart in the same folder.
5. Embed the chart from the Distribution Chart workbook into the Employee Memo doc-
ument on the blank line above the paragraph that begins “LHC has grown steadily.”
6. Double-click a blank area of the chart. Describe what happens. Why does this occur?
7. Explode the Home Care wedge of the pie, and then deselect the chart. ( Hint : Single-
click the Home Care wedge twice to select only that wedge, and then drag the
wedge away from the rest of the pie to explode it.)
8. Switch to Excel, and then close the Distribution Chart workbook without saving changes.
9. Open the LHCGrowthUpdated workbook in the Tutorial.01\Review folder included
with your Data Files, and then save it as Growth Table 2 in the same folder.
10. Copy the growth table.
11. Switch to the employee memo, place the insertion point in the blank paragraph mark
above the heading “New Services,” paste the Excel table and then use the Paste
Options button to link the growth table to the Employee Memo, but keep the format-
ting of the source file when you link the table.
12. Switch to Excel, press the Esc key to deselect the table, and then change the number
of home care clients in 2006 to 1354, and the number of transportation clients in
2006 to 331.
13. Switch back to the employee memo and update the link.
14. Replace Caitlin Sheehan’s name at the top of the memo with your own. Center the
pie chart horizontally on the page. ( Hint : Click the chart once to select it, and then
center it.) Center the table and fine-tune its format. Finally, make sure that there is
one blank line between the chart and the table and any text above and below them,
and that the page break is in a logical place.
15. Save the memo, and then preview and print it.
16. Break the link between the employee memo and the table.
17. Test that the link is broken by changing the number of clients in 2006 who received
light chores service from 89 to 100 in the table in the Excel workbook, and then try
to update the link in the Word document.
18. Exit all open programs. When prompted to save files, click the Yes button.
Case Problem 1
Data Files needed for this Case Problem: MusicLetter.doc and MusicRentals.xls
Making Music Caleb Jacobson is the owner of Making Music, a small music retail store in
Danbury, Connecticut. Caleb sells instruments and accessories, sheet music, lesson books, and
a few music collectibles, and he offers repair service for most common instruments. Caleb and
some of his staff also teach piano and guitar lessons in a room upstairs from the store. In addi-
tion, Making Music rents and sells band instruments to middle and high school students at area
schools. Currently, Making Music has arrangements with three area middle schools and two
high schools to show up on the school grounds in September each year to rent or sell band
instruments to interested students. Caleb wants to make arrangements with more schools to
expand his business. He decides to write a letter of introduction to the music departments at
several schools in nearby towns. He wants to include an updated list of instruments that he
rents and sells, the current monthly rental fees, the total cost if a student rents until the instru-
ment is paid off, and the cost if a student buys the instrument outright. He wants to be able to
update this information if his prices change. He also wants to include a chart showing the
instruments he sells and rents the most. You’ll use Excel and Word to create the letter for Caleb.
Apply the skills you
learned to link an Excel
table to a letter and
embed an Excel chart in
1. Start Word, and then open the MusicLetter document in the Tutorial.01\Cases folder
included with your Data Files.