Import Data and Work with Smartart and Images - Computer Science Assignment Help

Assignment Task

 PROJECT STEPS

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.
 

Copy the formatting from cell E3 to cell D3 to use consistent formatting for the column headings.
 

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.]
 

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.

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.
 

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.
 

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.

This Computer Science Assignment has been solved by our Computer Science experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.