Padma Laghari is a content manager for Veritate Online, a website that sells electronics, home furnishings, and other goods throughout the United States. Padma oversees the contractors the company...

1. Padma Laghari is a content manager for Veritate Online, a website that sells electronics, home furnishings, and other goods throughout the United States. Padma oversees the contractors the company hires to research, write, and edit content for the website, including product descriptions and answers to customer questions. She is organizing information about the contractors in an Excel workbook, and asks for your help in updating and analyzing the data.Switch to the
   Contractors
   worksheet. Unfreeze the top row of the worksheet.


2. Padma wants to sort and filter the contractor data. Format the range A4:G52 as a table with headers using Blue-Gray, Table Style Medium 9. Use
   Contractors
   as the name of the table.


3. Apply the First Column table style option to separate the ID values from the rest of the data. Resize column A to its best fit.


4. A new contractor started last week, and Padma wants to include her data with the other contractors. Insert the record shown in Table 1 to the end of the Contractors table above row 53.

Documentation New Perspectives Excel 2019 | Module 6: End of Module Project 1 Veritate Online MANAGING YOUR DATA WITH DATA TOOLS Author:paula barajas Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Contractors Veritate Online Contractor List IDFirstLastSpecialtyStart YearPay CategoryEval Rating c5486MariaConnerGarden and home202015 c6664SusanOlsonClothing and shoes202124 c7469HowardAgbaje  Electronics201924 c6084PhucTrangAutomotive202133 c6406Gregg  WattsMovies and music202024 c1438Lenard  Kalende  Movies and music202015 c7075Bradley  BowersSports and outdoors202133 c5455Long  SowClothing and shoes202015 c5356EunJohnsAutomotive202133 c2158Craig  WatersElectronics202024 c8597JoannaMunisi  Movies and music202033 c2326VashtiPopoola  Sports and outdoors201715 c6071MelissaJensenSports and outdoors202133 c3049RuthDudusola  Electronics201722 c2463Rashad  MahalaGarden and home201715 c4614WilliamMillerAutomotive202115 c9808MarilynFrazierGarden and home201815 c4573PeteHamadache  Movies and music201715 c3571KirstinBohnerClothing and shoes201715 c4412MargueriteCortezGarden and home201724 c5261Jarvis  RansomSports and outdoors202024 c3948NancyDeredaSports and outdoors202124 c1722ThanhHueMovies and music202224 c4865MyVanGarden and home201824 c2489BertLeonardElectronics201715 c1885VictorinaCobblewick  Clothing and shoes202024 c1922RustyLawsonAutomotive201715 c3923BlakeCollinsMovies and music202124 c4866JackWestermanElectronics202115 c3217Jarod  WhetstoneAutomotive202033 c4218NhungHoàngClothing and shoes202215 c4986EliciaSettles  Garden and home201715 c9888LouiseDialloSports and outdoors202033 c7972NikitaAmiri  Automotive201824 c7251FernandaNgôClothing and shoes202233 c8508HannahJohnsonMovies and music202024 c5117ShantelleWashingtonMovies and music202024 c6771CarinHallSports and outdoors202124 c8031Reid  GreeneMovies and music201724 c2525LunaZimmermanGarden and home202024 c9453Bobby  RodgersElectronics201733 c9808MarilynFrazierGarden and home202215 c8686EverettMurrayClothing and shoes202124 c6541HunterBakerAutomotive202133 c5228LaverneCusterMovies and music201815 c7466DonnieGraziaElectronics202024 c5847AnneMoussa  Automotive201915 c4317AnitaMelanderElectronics201915 Product SpecialtyCategoryMin per Post Automotive1$50 Clothing and shoes2$100 Electronics3$200 Garden and home2$100 Movies and music2$125 Sports and outdoors3$150