Create a blank workbook. Name it using your Last name followed by your initials and _ 1EX (underscore then 1EX).
Ask before/after/during class or come into office/online hours if you have questions on any of this. Refer to the syllabus onAcademic Dishonesty and group/individual work and allowable help for all projects – also remember it’s your responsibility to protectyour work.Before you start — read this whole assignment and use an optional text and/or review the tutorials as necessary. A project overviewis also available.Part 1 – Create / Download• Create a blank workbook. Name it using your Last name followed by your initials and _ 1EX (underscore then 1EX). ForExample: WarnerBL_1EX .xlsx or xls. Either extension is fine• Copy/paste the data from Excel 1- Music Data.docx , into the 2nd worksheet in your workbook. Name the tab MUSIC.• Adjust the YTD Units Sold and 2015 Units Sold columns so that their titles are wrapped onto 2 or 3 lines within one cell. Adjustthe Title column so that titles can be wrapped on 2 or more lines within one cell as needed (so titles are not cut-off). See thesorted example below.• Sort the data (do not sort or remove the title/heading rows) by Code. Check the sort to be sure all is correct.• Add conditional formatting to this Music worksheet that highlights any selling prices of $9 or more with a green background. Ifthe selling prices is lowered below $9, the formatting should change automatically.• Using the named range feature of Excel, name all of the cells in this worksheet, MusicData.• No additional data/formulas should be added to the worksheet.