Temple University Cleansing Inventory Data Excel Worksheet

User Generated

xunaulj

Business Finance

Temple University

Description

this only works on Windows version of Excel

i have only one Excel workbook

please see attached file , there is 2 Excel workbook file and 1 word file which is the instruction for each excel workbook.

"important Must work on the same files" and upload them back to me once its done

Unformatted Attachment Preview

Grader - Instructions Excel 2016 Project YO16_XL_CH09_GRADER_PS2_AS - Cleansing Inventory Data 1.5 Project Description: You currently work part-time in an automotive parts store. Because word of your knowledge of Excel has spread, you have been contacted by the district manager. The database used for keeping track of inventory has been corrupted, causing some issues with the inventory data. You have been asked to use your expertise of Excel to clean the inventory data. Steps to Perform: Points Possible Step Instructions 1 Start Excel. Open the downloaded workbook named e05ch09_grader_a1_Inventory.xlsx. Save the file with the name e05ch09_grader_a1_Inventory_LastFirst.xlsx, using your last and first name. If necessary, enable the content. 0 2 Remove any duplicates that exist in the Inventory worksheet. Duplicate records are any records with the same InventoryCode and ItemNumber. 15 3 Enter the text Step 1 in cell G1. 5 4 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. 12 5 Enter the text Step 2 in cell H1. 5 6 There are several spaces before and after the data in column G that need to be removed. In cell H2, enter a formula to remove any extra spaces in the data from column G. Copy the formula down the column. 12 7 The category and manufacturer should be in two separate columns. Enter the text Category in cell I1. 5 8 Enter the text Manufacturer in cell J1. 5 9 Use Flash Fill to place the category data from column H in proper case in column I. 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. Mac users will need to use the Text to Columns feature. Select the range H2:H24. On the Data tab, click Text to Columns. Use / as the Delimiter and =$I$2 as the Destination. 21 10 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. 10 11 Enter the text ItemCode in cell L1. The ItemCode is a combination of the inventory code in all uppercase letters, with the item number appended to it. For example, the first ItemCode should be RLXF920569. Use the appropriate function in column L to create this new ItemCode and AutoFill the function down to L20. 10 12 Save the workbook. Close the workbook. Exit Excel. Submit the workbook as directed. 0 Total Points Created On: 07/05/2019 100 1 YO16_XL_CH09_GRADER_PS2_AS - Cleansing Inventory Data 1.5 InventoryCode rLXf lJDf lJDf bCDx kRBa lQSa bLMv fOXt nXWq tNDk eSZw qKOm mTHa lQSa eWHp eCEz sYKp nQUq gLYh eCEz bLMv aWHw uIRb rLXf ItemNumber 920569 400632 400632 914314 933521 402860 009225 030594 041141 741102 009216 895850 091160 402860 500129 009256 424076 874000 930777 009256 009225 873700 883466 920569 Category/Manufacturer BRAKES/NAPA TOOLS/NAPA TOOLS/NAPA Paint/3M EQUIPMENT/Balkamp CHEMICALS/NAPA Paint/Sharpe SHOCKS/KYB CHEMICALS/Altrom Chemicals OIL/Pennzoil WELDERS/Vise Grip Paint/Evercraft EQUIPMENT/Viper CHEMICALS/K&W OIL/Quaker State ACCESSORIES/NAPA TOOLS/DeWalt SHOCKS/NAPA BRAKES/McGard ACCESSORIES/Balkamp Paint/3M WELDERS/Balkamp SEALANTS/Permatex BRAKES/Balkamp 20200327203943fang_e05ch09_grader_a1_inventory SellingPrice WholeSale 44.99 41.94 16.25 12.34 16.25 12.34 18.4 14.48 9.99 7.89 48.49 35.18 6 4.62 89.99 75.00 37.99 25.51 5.25 3.94 22.19 13.53 9.99 6.19 12.49 10.62 18.49 13.18 3.99 3.31 8.5 6.35 249.49 203.65 13.09 11.55 10.79 6.14 3.5 2.35 26 24.62 26.49 20.09 16.49 12.00 5.45 2.94 Units/Description 4 pads 4 grinding wheels 4 grinding wheels 3 spray gun filters 3 antifreeze testers 5 gallons RV antifreeze 1 spray gun service kit 2 rear shocks 6 cans fuel injector cleaner 1 qt 3 rolls metal solder 5 spray gun nozzle gaskets 3 antifreeze filters 5 cans radiator stop leak 1 qt 1 universal license plate light 1 grinder 2 shock mate boot kits 4 locks 2 yellow round side markers 6 rolls masking tape 4 soldering gun tips 6 tubes gasket sealant 1 spindle lock nut kit 20200327203943fang_e05ch09_grader_a1_inventory
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Here is your file

InventoryCode
rLXf
lJDf
bCDx
kRBa
lQSa
bLMv
fOXt
nXWq
tNDk
eSZw
qKOm
mTHa
eWHp
eCEz
sYKp
nQUq
gLYh
aWHw
uIRb

ItemNumber
920569
400632
914314
933521
402860
009225
030594
041141
741102
009216
895850
091160
500129
009256
424076
874000
930777
873700
883466

Category/Manufacturer
BRAKES/NAPA
TOOLS/NAPA
Paint/3M
EQUIPMENT/Balkamp
CHEMICALS/NAPA
Paint/Sharpe
SHOCKS/KYB
CHEMICALS/Altrom Chemicals
OIL/Pennzoil
WELDERS/Vise Grip
Paint/Evercraft
EQUIPMENT/Viper
OIL/Quaker State
ACCESSORIES/NAPA
T...

Similar Content

Related Tags