can someone help me with this Microsoft Excel Problem?

Points Possible 0 15 Step Instructions Start Excel. Open the downloaded workbook named Excel_ch09 PS2_Inventory.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. 2 There are duplicate rows of data in the Inventory worksheet. These duplicate records need to be removed before the data can be further cleansed. Remove any duplicates that exist in the Inventory worksheet. Duplicate records are any records with the same InventoryCode and ItemNumber. 3 The data for the Category Manufacture has extra spaces, non-printable characters, and the case of the text needs altered in order to successfully cleanse the data. This process will take several steps and it will be easier if each step is completed in separate columns. 5 12 Enter the text Step 1 in cell GI. The data in column C has nonprintable characters before and after the data contained in each cell. In cell G2, enter a formula to remove any nonprintable characters from column C. Copy the formula down the column. Enter the text Step 2 in cell Hl. There are several spaces before and after the data in column G that need to be removed. 5 5 6 12 7 The category and manufacturer should be in two separate columns. Enter the 5 text Category in cell 11. 8 Enter the text Manufacturer in cell Jl. 5 9 Use Flash Fill to place the category data from column H in proper case in 21 column L. Use Flash Fill to place the Manufacturer data from column H into the new column J. Owing to the nature of the data, Flash Fill will need to be invoked from the Data tab. 10 A new ItemCode will be constructed from the InventoryCode and Item Number 10 columns. The first part of the ItemCode will be the InventoryCode displayed as uppercase letters. Enter the text InvCode in cell K1. In cell K2, enter a formula to display the inventory code from column A as all uppercase letters. Copy the formula down the column 11 Enter the text ItemCode in cell L1. The ItemCode is a combination of the 10 inventory code in all uppercase letters, with the item number appended to it. For example, the first ItemCode should be UARM423949. Use the appropriate function in column L to create this new ItemCode and fill the function down the column 12 Save and close Excel Ch09_PS2_Inventory.xlsx. Exit Excel. Submit your files as directed Total Points 100 0 InventoryCode uaRM ULkk VITL mExy KUKK aQky ItemNumber 423949 653258 708778 946463 703086 131819 9 xgag 756385 UkgH VanV kkok bb Kmp NBEZ 811862 127037 971190 040715 081885 623171 653258 299429 186104 183636 714742 Category/Manufacturer ACCESSORIES Balkamp BRAKES Balkamp OIL Quaker State OIL Pennzoil Paint Sharpe BRAKES McGard Paint Evercraft ACCESSORIES NAPA EQUIPMENT Balkamp EQUIPMENT Viper SHOCKS NAPA SEALANTS Permatex TOOLS NAPA BRAKES Balkamp TOOLS NAPA CHEMICALS K&W WELDERS Vise Grip Paint 3M WELDERS Balkamp Paint 3M CHEMICALS Altrom Chemicals CHEMICALS NAPA BRAKES NAPA SHOCKS KYB TOOLS DeWalt EQUIPMENT Balkamp SHOCKS NAPA Selling Price Wholesale Units/Description 6,5 5.35 2 yellow round side markers 8.45 5.9355 I spindle lock nut kit 6.99 6.3117 Iq 8.25 6.94 14 7.62 1 spray gun service kit 13.79 9.14 4 locks 12.99 9.19 spray gun nozzle gaskets 11.5 9.34 1 universal license plate light 12.99 10.89 3 antifreeze testers 15.49 13.62 3 antifreeze filters 16.09 14.55 2 shock mate boot kits 19.49 15.00 6 tubes gasket scalant 19.25 15.34 4 grinding wheels 8.45 5.9355 I spindle lock nut kit 19.25 15,34 4 grinding wheels 21.49 16.18 5 cans radiator stop leak 25.19 16.53 3 rolls metal solder 21.4 17.48 3 spray gun filters 29.49 23.09 4 soldering gun tips 29 27.62 6 rolls masking tape ULKK aji Hmms iMIS Xkmk 128797 274771 ppog 40.99 28.51 6 cans fuel injector cleaner Qqal 577395 51.49 fssf eHge aaaY 532981 282483 117903 836202 127037 040715 47.99 92.99 252.49 12.99 16.09 38.18 5 gallons RV antifreeze 44.94 4 pads 78.00 2 rear shocks 206.65 1 grinder 10.89 3 antifreeze testers 14.55 2 shock mate boot kits InzF Van V Hbbb Points Possible 0 15 Step Instructions Start Excel. Open the downloaded workbook named Excel_ch09 PS2_Inventory.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. 2 There are duplicate rows of data in the Inventory worksheet. These duplicate records need to be removed before the data can be further cleansed. Remove any duplicates that exist in the Inventory worksheet. Duplicate records are any records with the same InventoryCode and ItemNumber. 3 The data for the Category Manufacture has extra spaces, non-printable characters, and the case of the text needs altered in order to successfully cleanse the data. This process will take several steps and it will be easier if each step is completed in separate columns. 5 12 Enter the text Step 1 in cell GI. The data in column C has nonprintable characters before and after the data contained in each cell. In cell G2, enter a formula to remove any nonprintable characters from column C. Copy the formula down the column. Enter the text Step 2 in cell Hl. There are several spaces before and after the data in column G that need to be removed. 5 5 6 12 7 The category and manufacturer should be in two separate columns. Enter the 5 text Category in cell 11. 8 Enter the text Manufacturer in cell Jl. 5 9 Use Flash Fill to place the category data from column H in proper case in 21 column L. Use Flash Fill to place the Manufacturer data from column H into the new column J. Owing to the nature of the data, Flash Fill will need to be invoked from the Data tab. 10 A new ItemCode will be constructed from the InventoryCode and Item Number 10 columns. The first part of the ItemCode will be the InventoryCode displayed as uppercase letters. Enter the text InvCode in cell K1. In cell K2, enter a formula to display the inventory code from column A as all uppercase letters. Copy the formula down the column 11 Enter the text ItemCode in cell L1. The ItemCode is a combination of the 10 inventory code in all uppercase letters, with the item number appended to it. For example, the first ItemCode should be UARM423949. Use the appropriate function in column L to create this new ItemCode and fill the function down the column 12 Save and close Excel Ch09_PS2_Inventory.xlsx. Exit Excel. Submit your files as directed Total Points 100 0 InventoryCode uaRM ULkk VITL mExy KUKK aQky ItemNumber 423949 653258 708778 946463 703086 131819 9 xgag 756385 UkgH VanV kkok bb Kmp NBEZ 811862 127037 971190 040715 081885 623171 653258 299429 186104 183636 714742 Category/Manufacturer ACCESSORIES Balkamp BRAKES Balkamp OIL Quaker State OIL Pennzoil Paint Sharpe BRAKES McGard Paint Evercraft ACCESSORIES NAPA EQUIPMENT Balkamp EQUIPMENT Viper SHOCKS NAPA SEALANTS Permatex TOOLS NAPA BRAKES Balkamp TOOLS NAPA CHEMICALS K&W WELDERS Vise Grip Paint 3M WELDERS Balkamp Paint 3M CHEMICALS Altrom Chemicals CHEMICALS NAPA BRAKES NAPA SHOCKS KYB TOOLS DeWalt EQUIPMENT Balkamp SHOCKS NAPA Selling Price Wholesale Units/Description 6,5 5.35 2 yellow round side markers 8.45 5.9355 I spindle lock nut kit 6.99 6.3117 Iq 8.25 6.94 14 7.62 1 spray gun service kit 13.79 9.14 4 locks 12.99 9.19 spray gun nozzle gaskets 11.5 9.34 1 universal license plate light 12.99 10.89 3 antifreeze testers 15.49 13.62 3 antifreeze filters 16.09 14.55 2 shock mate boot kits 19.49 15.00 6 tubes gasket scalant 19.25 15.34 4 grinding wheels 8.45 5.9355 I spindle lock nut kit 19.25 15,34 4 grinding wheels 21.49 16.18 5 cans radiator stop leak 25.19 16.53 3 rolls metal solder 21.4 17.48 3 spray gun filters 29.49 23.09 4 soldering gun tips 29 27.62 6 rolls masking tape ULKK aji Hmms iMIS Xkmk 128797 274771 ppog 40.99 28.51 6 cans fuel injector cleaner Qqal 577395 51.49 fssf eHge aaaY 532981 282483 117903 836202 127037 040715 47.99 92.99 252.49 12.99 16.09 38.18 5 gallons RV antifreeze 44.94 4 pads 78.00 2 rear shocks 206.65 1 grinder 10.89 3 antifreeze testers 14.55 2 shock mate boot kits InzF Van V Hbbb