Module 1 Integrating Word and Excel - Independent Challenge 2

As a member of the Beaver Island Arts Commission in Washington State, you are responsible for compiling the minutes of the commission’s quarterly meetings. You have already written most of the text required for the minutes. Now you need to insert data from Excel that shows how much money was raised from various fund-raising activities.
a. Start Word, open IL_INT_1-11.docx from the location where you store your Data Files, save it as IL_INT_1_BeaverIslandArtsCommissionMinutes, start Excel, open IL_INT_1-12.xlsx from the location where you store your Data Files, then save it as IL_INT_1_BeaverIslandData.
b. In Excel, open the Clipboard pane, clear all items if necessary, then copy the photograph and cell A2.
c. In Word, open the Clipboard pane, paste the photograph at the top of the Word document, change the text wrapping of the picture to Square, then position the photograph to the right of the first paragraph, keeping within the green guidelines.
d. Click to the left of “Approval of Minutes,” then paste cell A2.
e. Copy the Fundraising Revenue chart from Excel, then paste it in the appropriate area in the Word document.
f. In Excel, change the number of participants in the bake sale to 1000; then in Word, refresh the data in the chart if necessary. The Bake Sale slice should be 60%.
g. In Excel, copy the contents of cell E7, switch to Word, select “XX” in the paragraph below the chart, view the paste options, then paste the value as a link using the Unformatted Text selection in the Paste Special dialog box. Add a space if necessary.
h. In Excel, click cell G7, then calculate the total funds raised by adding the contents of the range B7:F7.
i. In cell B8, enter the formula =B7/G7, use [F4] to make cell G7 absolute, then copy the formula to the range C8:F8.
j. Copy cell E8, switch to Word, select “ZZ” in the paragraph below the chart, then paste the value as a link using the Unformatted Text selection, adding a space if necessary.
k. In Excel, change the number of participants in the bake sale to 1200; then in Word, verify the Bake Sale slice changed to 64% and the links updated to $60,000 and 64%. If the links do not update automatically, right-click them and click Update Link in the Word document.
l. Type your name in the Word footer, then save the Word document and Excel workbook, submit the files to your instructor, then close them

Comments

Post a Comment

Popular posts from this blog

Module 1 Getting Started with Excel - Independent Challenge 1

download The CFO at Riverwalk Medical Clinic has hired you to help him analyze departmental insurance reimbursements. He also would like to see what quarterly revenues would look like with a 20% increase in quarterly reimbursements. You’ve been given a worksheet for this project that contains some but not all of the data. a. Open IL_EX_1-3.xlsx from the location where you store your Data Files, then save it as IL_EX_1_Reimbursements. b. Enter the data shown in TABLE 1-4 in the range E4:E11. c. Type your name in cell A17. d. Move the label in cell F2 to cell A15. e. Use the Clipboard to copy and paste the label in cell F3 to cell A12. f. Use the formula bar to correct the spelling error in the label in cell A6. (Hint: The correct spelling is Immunology.) g. Edit cell A8 to correct the spelling error in the label. (Hint: The correct spelling is Ophthalmology.) h. Type Quarter 1 in cell B3, then use Auto Fill to enter Quarter 2, Quarter 3, and Quarter 4 in the range C3...
Read more

Module 1 Creating Documents with Word - Visual Workshop

download Create the letter shown in FIGURE 1-34. Before beginning to type, click the No Spacing button in the Styles group on the Home tab. Type the letter before formatting the letterhead and applying the theme. To format the letterhead, change the font size of the first line of text to 40 point and apply the Gradient Fill: Blue, Accent 5, Reflection WordArt style. Change the font color of the address line to Blue, Accent 5. Add the bottom border to the letterhead. When the letterhead is formatted, change the font size of the body text to 12 point, apply the Organic theme, then change the font color of the letterhead text to Green, Accent 1. Save the document as IL_WD_1-SakuraDoksa to the location where you store your Data Files, submit the letter to your instructor, then close the document and exit Word.
Read more

Module 1 Creating Documents with Word - Independent Challenge 1

download You work at the Riverwalk Medical Clinic, a large outpatient medical facility staffed by family physicians, specialists, nurses, and other allied health professionals. Your boss has drafted an information sheet to help seasonal allergy sufferers and asks you to edit and format it so that it is eye catching and attractive.  a. Open the file IL_WD_1-5.docx from the drive and folder where you store your Data Files, save it as IL_WD_1_AllergyInfo, then read the document to get a feel for the content. FIGURE 1-32 shows how you will format the info sheet. FIGURE 1-32 Riverwalk Medical Clinic Advice for Seasonal Allergy Sufferers b. Show the rulers in your document window if they are not already visible. c. Accept or ignore all suggested spelling and grammar changes in the document. d. Insert the Riverwalk Medical Clinic logo file Support_IL_WD_1-6.jpg at the top of the document. Change the height of the logo to 1", then position the logo in the bottom right with...
Read more