Shelly Cashman Excel 365 | Module 7: SAM Project A CleanTec Corporation

Описание: #Shelly Cashman Excel 365 | Module 7: SAM Project A
#Shelly Cashman Excel 365 | Module 7: SAM Project A


Contact Us:
WhatsApp Number:+923187569415
Chatting Link :https://tinyurl.com/yzpfk6fm




I am providing help in all online courses like Excel, Word, Access, PowerPoint, Accounting , Management Courses, Finance Courses, Computer Science Courses, Information Technology Courses, All Writing Assignments etc. I can do your Quizzes, Exams , Mid-Term, Final Exams. In short I can get you A grade in your courses. If you want me do your courses My WhatsApp number and Email is given you can contact me through that. Thanks




PROJECT STEPS
1. Salma Dalvari is an associate project manager at CleanTec Corporation, an environmental engineering firm. She is preparing a workbook that will be given to prospective clients to describe CleanTec's services and performance. She asks for your help in importing data and adding other content to the workbook.

Go to the Project Team worksheet. Add CleanTec logo as the alt text for the picture in the range B1:B2.
2. In cell B1, apply the Pattern Fill: White; Dark Upward Diagonal Stripe; Shadow WordArt Style (1st column, 4th row in the WordArt Styles gallery) to the shape containing the worksheet title "CleanTec Corporation" to coordinate it with the other worksheet titles in the workbook.
3. The worksheet should list information about the engineering project team, which is contained in a webpage.

Import data from the webpage as follows:
a. Open the webpage Support_EX365_7A_Project.html in a browser.
b. In the Project Team worksheet, import the data from the CleanTec_Engineering_Project_Team part of the Support_EX365_7A_Project webpage as a table in cell H12 of the existing worksheet. [Mac Hint: Import the
data from HTML. Open the file Support_EX365_7A_Team.html, copy and paste the data from the range A3:G9 to the range beginning in cell H12.]
c. Clear the formats from the imported data in the range H12:N18 to remove the webpage formatting.
d. Apply the Green, Table Style Medium 2 style to the imported table. [Mac Hint: Format the imported data in H12:N18 as a table with headers, and apply the Green, Table Style Medium 2 style.]
e. Rename the table using Project_Team as the name.

4. Salma wants you to list the team information in the range B5:F10. The webpage table separates the first and last names, but Salma wants to list the full name on the Project Team worksheet.

List the first and last names of each team member in a single cell as follows:
a. In cell B5, enter a formula using the CONCAT function that displays the first name shown in cell I13 followed by a space (" ") and then the last name shown in cell J13.
b. Fill the range B6:B10 with the formula in cell B5 to list the full names of the remaining team members.
5. Incorporate the imported data in the range C5:F10 as follows:
a. Copy the Role data from the range K13:K18 and paste only the values in the range C5:C10.
b. In cell D5, enter a formula using the PROPER function to capitalize the first letter in each word in the Department text in cell L13.
c. Fill the range D6:D10 with the formula in cell D5 to list the departments of the remaining team members.
d. In cell E5, enter a formula using the LEFT function to insert the first 2 characters on the left of cell M13. Copy the formula in cell E5 to the range E6:E10.
e. In cell F5, enter a formula using the RIGHT function to insert the last 2 characters on the right of cell N13. Copy the formula in cell F5 to the range F6:F10.
f. Hide rows 12 to 18 so that the worksheet does not display duplicated data.
6. On the Company Awards worksheet, Salma already imported data summarizing the recent awards the company received but wants to display the data in the range H5:I8 of the Project Team worksheet. She asks you to switch the rows and columns when you insert the data to fit in the range H5:I8. Insert the imported data as follows:
a. Go to the Company Awards worksheet. Copy the data in the range B2:G3, and then transpose the rows and columns as you paste the data on the Project Team worksheet starting in cell H5.
b. Resize column H to its best fit.
7. On the Project Team worksheet, Salma asks you to provide one diagram with an organization chart to show the hierarchy of the engineering project team and another diagram illustrating the company awards.



Insert an organization chart as follows:
a. Insert the Organization Chart SmartArt from the Hierarchy section of the SmartArt gallery.
b. Move and resize the SmartArt so that the upper-left corner is in cell B19 and the lower-right corner is in cell E31.