Shelly Cashman Excel 365 | Module 7: SAM Critical Thinking Project C CleanTec Corporation

#Shelly Cashman Excel 365 | Module 7: SAM Critical Thinking Project C #Shelly Cashman Excel 365 | Module 7: SAM Critical Thinking Project C 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 leaf picture at the top of the worksheet. 2. 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_CT7C_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_CT7C_Project webpage as a table in cell H12 of the existing worksheet. If necessary, resize the table to remove the blank row from the bottom. [Mac Hint: Import the data from HTML. Open the file Support_EX365_CT7C_Project.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 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. To display the first member, enter a formula in the appropriate cell using a function that displays the first employee's first and last names in the imported list, with a space in between them. Then fill the name column with the formula you just entered 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 imported table and paste only the values in the column next to the employee's full names. b. In the Department column, enter a formula using a function to capitalize the first letter in each word in the Department text in the imported table. Fill the column down with the formula to list the departments of the remaining team members. c. For the Tenure column, enter a formula using a function to insert the first 2 characters on the left of the Tenure column of the imported table. Copy the formula to fill the rest of the column. d. For the Location column, enter a formula using a function to insert the last 2 characters on the right of the Location column of the imported table. Copy the formula to fill the rest of the column. e. 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:I10 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:I10. Insert the imported data as follows: a. Go to the Company Awards worksheet. Copy the data, and then transpose the rows and columns as you paste the data on the Project Team worksheet in the appropriate cell. 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: