Project 1 - Nationwide Sales Workbook – New Hires sheetOverviewYou manage the employee records and sales figures for Nationwide Sales. You need to download thenew hires and change the text format.Tasks☐1Open thePractice Exam 3workbook.InD3on theNew Hiressheet import the text fileNew Hires 2020. It is tab delimited and ithas headers.☐2Clear the table format.Convert the table to a range.☐3In A4 on theNew Hiressheet, type the function to change cell D4 from all capital letters toproper capitalization (e.g. Crown).Copy toB4and then fill A4:B4 down for all names.☐4Paste the values fromA4:B65ontoD4:E65. (Hint: If the data disappears, you used thewrong Paste option.)☐5Type yourlast name, in cellD66and yourfirst namein cellE66.☐6Show the formulas on the sheet.☐7Change the orientation of the text inD3:E3to 30 degrees counterclockwise.Put a bottom border underD3:E3.☐8Hide theNew Hiressheet.
