Homework answers / question archive / Illustrated Excel 2019 | Module 10: End of Module Project 1 Malik Construction COLLABORATE ON A WORKBOOK GETTING STARTED Open the file IL_EX19_EOM10-1_FirstLastName_1

Illustrated Excel 2019 | Module 10: End of Module Project 1 Malik Construction COLLABORATE ON A WORKBOOK GETTING STARTED Open the file IL_EX19_EOM10-1_FirstLastName_1

MS Excel

Share With

Illustrated Excel 2019 | Module 10: End of Module Project 1

Malik Construction

COLLABORATE ON A WORKBOOK

• GETTING STARTED

• Open the file IL_EX19_EOM10-1_FirstLastName_1.xlsx, available for download from the SAM website.
• Save the file as IL_EX19_EOM10-1_FirstLastName_2.xlsx by changing the “1” to a “2”.
  • If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
  • Support_EX19_EOM10-1_AprClients.xml
  • Support_EX19_EOM10-1_Leads.html
  • Support_EX19_EOM10-1_MayClients.xml
  • Support_EX19_EOM10-1_MayClients.xsd
• With the file IL_EX19_EOM10-1_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
  • If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

• PROJECT STEPS

1. Silvia Villacruz is the head of marketing and sales for Malik Construction, a full-service construction firm in Boulder, Colorado. She has been tracking sales leads in an Excel workbook, which has been reviewed by Gurman Malik, the owner of the firm, and Natalia Martinez, an account manager. Silvia asks for your help in responding to comments and including missing data.
   Go to the Sales Leads worksheet and show all comments in the workbook. Respond to the comment in cell C8 by entering Trade show in the cell and then deleting the comment from Gurman Malik.
2. Go to the next comment in the worksheet, which is from Natalia Martinez in cell F8. Reply to the comment by including the text Okay, thank you as response, and then post your reply. Reply to the comment in cell E12 by including the text Yes, the percentage is correct. as the response, and then post your reply.
3. Silvia notices that an entry in the Potential Opportunity column might be incorrect and wants to ask Natalia to verify it. In cell D8, insert and post a new comment that contains the following text:
   Is this estimate correct? Please let me know.
4. Silvia wants to add some data from an internal company webpage to the worksheet.
   Open the file Support_EX19_EOM10-1_Leads.html in your browser, select the entire table, and then copy the data. In the Sales Leads worksheet, select the range A13:G16, and then paste the copied data to match the destination formatting. Close the webpage.
5. Silvia is also tracking data about sales to new clients. She has two XML files containing client data for May and April, and asks you to import them.
   Go to the New Clients worksheet. Open the XML Source pane and add the XML schema Support_EX19_EOM10-1_MayClients.xsd to the workbook.
6. Map the XML elements as shown in Table 1.

7. Use the XML Map Properties dialog box to set the XML map properties to validate imported and exported data against the schema and append new data to existing XML tables.
   First, import the XML data from the file Support_EX19_EOM10-1_MayClients.xml into the worksheet at cell B2. Next, import the XML data from the file Support_EX19_EOM10-1_AprClients.xml into the worksheet at cell B7.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.