Yo19_excel_ch09_assessment_cleansing_inventory_data | Computer Science homework help




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 in Excel to clean the inventory data.


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.


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.


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.

  Enter the text Step 1 in cell G1.


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 H1.


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.


The category and manufacturer   should be in two separate columns. Enter the text Category in cell I1.


Enter the text Manufacturer in cell J1.


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. 


A new ItemCode will be   constructed from the InventoryCode and ItemNumber 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.


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 UARM423949.   Use the appropriate function in column L to create this new ItemCode and fill   the function down the column. 


Save and close Excel_Ch09_PS2_Inventory.xlsx. Exit   Excel. Submit your files as directed.

Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Quality Essay Help has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.


Essay Writing Services

At Quality Essay Help, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.


Admission and Business Papers

Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.


Editing and Proofreading

Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.


Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.