Question:

give answer in 2 step with explanation at the end of each step and final answer at the end:* PROJECT STEPS] B 1. = Abdul-Khoury is-an assistant sales-manager-at:Wang-Marketing, -a-full-service-agency- - New York-City-that-provides-advertising, -public relations, -and-marketing-for-clients- around the world. -Abdul-is-preparing-a-workbook to-summarize-the-agency's-revenue: and-expenses-in-the-past-month.-He-will-submit-similar-workbooks:to-the-agency's- bankers-once-a-month-as-part-of-their-loan-agreement:with-the-bank.-Abdul-asks-for- your-help-in-importing-data-and-adding-other-content to-the-workbook. -« Go to-the-Advertising-worksheet.-Insert the-picture-Support_EX365_2021_EOM7- 1 _Mac_Logo.png-to-add-a-picture-of-the-agency's-logo-to-the-worksheet.-Move-and- resize the picture so-its-upper-left-comer-is-in-cell-A1-and-its-lower-right-comer-is-in-cell- G7.-Add the-alt-text-Wang-Marketing-logo-for-people-using-screen-readers.§ 2.» Abdul-needs-to-import-data-from-the-New-York, Chicago, -and-Los-Angeles-offices. The- New-York-office-provided-its-monthly-data-in-a-text-file. Import -the-data- from-text from- the-file-Support_EX365_2021_EOM7-1_Mac_NewYork.csv-in-the-Advertising worksheet-beginning-in-cell-A10.-Separate-the-data-using-a-comma-delimiter.{ 3.» Te A ER A pocvirs from the file-Suppor ,*specifying-a- path-such-as-c:\users\username\documents\projects\-Support_EX365_2021_EOM7- 1_Mac_LosAngeles.html.-Select-all-the-data-except-the-first-column- (Hint: -Select-data-in- range-B3:D7),-and-then-copy-and-paste-the-values-in-the-Advertising-worksheet- beginning-in-cell-A22,9 4. » Format-the-ranges-as-tables-with-headers-and-then-apply-Dark-Red, ‘Table: Style-Light-9- to-each-of the-three-tables-to-coordinate-with-the-rest-of the-workbook.-Remove-the- filter-buttons-from the-header-rows. -Format-the-$-Revenue-and-$-Expense-data-in-the- bottom two tables-using-the-Comma-number-style-that-has-no-decjgnal-places. 1 —. ime. and A Sa