Shelly Cashman Excel 2019 | Module 7: End of Module Project 2 #shelly #module7 #EOMPROJECT2
If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
wa.me/message/PPXGSJS2TLWUA1
Whatsapp Contact Number:
+91 8114420233
Email ID:
excelprojectshelp@gmail.com
1. Ruben Hernandez is the head of the Web Development Department at Brand Deluxe, a web design agency in Brooklyn, New York. He is preparing a draft of a workbook to send to new hires who are joining the department and asks for your help in importing data and adding other content to the workbook.
Go to the Department worksheet. Change the style of the "Brand Deluxe" WordArt text to Fill: Aqua, Accent color 1; Shadow to match the style of the company name on other worksheets. Change the text outline color of the WordArt to Aqua, Accent 1.
2. Copy the formatting from cell E3 to cell D3 to use consistent formatting for the column headings.
3. The worksheet should list information about the department members, which is contained in a webpage. Get data from the Support_EX19_EOM7-2_Department.html webpage. (Hint: Use Windows Explorer to navigate to the Support_EX19_EOM7-2_Department.html webpage, click in the Address bar, and then copy the path. In the From Web dialog box, paste the path in the URL box.) Import only the Web Development Department Members webpage data as a table to cell G11 in the existing worksheet. [Mac hint - Import the file from HTML, copy the data starting in row 2 and paste it to cell G11 in the Department worksheet. Format the imported data as a table with headers and apply the Brown, Table Style Medium 7 table style.]
4. In the imported table, delete the table row for Brett Warrick because he has moved to a different department. Find the text "David Energy" and replace it with Davis Energy to use the correct company name.
5. Ruben wants to list the department information in the range A4:E9. The webpage table separated the first and last names, but Ruben wants to list the full name on the Department worksheet. In cell A4, enter a formula using the CONCAT function that displays the first name shown in cell G12 followed by a space (" ") and then the last name shown in cell H12. Fill the range A5:A9 with the formula in cell A4 to list the full names of the remaining department members.
6. Begin to incorporate the imported data in the range B4:E9 by copying the Position data from the range I12:I17 and paste only the values in the range B4:B9.
7. In cell C4, enter a formula using the PROPER function to capitalize the first letter in each word in the Current Project text in cell J12. Fill the range C5:C9 with the formula in cell C4 to list the names of the remaining projects.
8. In cell D4, enter a formula using the LEFT function to insert the first 2 characters on the left of cell K12. Copy the formula in cell D4 to the range D5:D9.
9. In cell E4, enter a formula using the RIGHT function to insert the last 2 characters on the right of cell L12. Copy the formula in cell E4 to the range E5:E9.
10. Resize columns A:E to their best fit, resize column G to 18.25, and resize column H to 13.00. Hide rows 11 to 17 so that the worksheet does not display duplicated data.
11. Ruben already imported project summary data on the Project Summary worksheet but wants to display the data in the range G4:H7 of the Department worksheet.
Go to the Project Summary worksheet. Copy the data in the range A1:D2, and then transpose the rows and columns as you paste the data on the Department worksheet starting in cell G4.
12. In the Department worksheet, insert and format a picture of Web Development Department members by inserting the picture Support_EX19_EOM7-2_Group.jpg. Position the picture so that the upper-left corner is in cell G18 and the lower-right corner is in cell J33.
shelly cashman excel 2019 | module 1: sam project 1b,#shelly cashman excel 2019 | module 1: sam project 1b,new perspectives excel 2019 | module 1: end of module project 2,new perspectives excel 2019 | module 10: sam project 1b,excel module 8 sam end of module project 1,shelly cashman excel 2019 | module 5: sam project 1a,new perspectives excel 2019 | module 7: end of module project 1,new perspectives excel 2019 module 1 sam project 1a,excel module 8 sam project