Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
ASSIGNMENT 1: USING EXCEL FOR DECISION SUPPORT Your task is to find incomplete records, duplicate records, and erroneous records in the 2010 data. While reviewing
ASSIGNMENT 1: USING EXCEL FOR DECISION SUPPORT Your task is to find incomplete records, duplicate records, and erroneous records in the 2010 data. While reviewing the Word file that came with the Excel file, you learn the following things about the data: When the data clerk entered the engagement dates, he entered only the month and day. Excel entered the year 1900 as a default value for the rest of the date. All dates should be corrected to show 2010 as the year. Engagement ID values should be unique. If there are duplicate Engagement ID values, delete the entire row from the file and log the duplicate values. Only CE, NW, NE, SW, and SE are valid values for the Region column. Delete any other Region values from the file and log them. To search for invalid Region values, first use a pivot table to count the number of engagements in each region. In the PivotTable Fields area, drag the Region field into the Rows cell and then drag the Region field into the Values cell. A count of engagements for each region is created in the pivot table. Invalid Region values will be counted along with valid ones. Highlight and copy the pivot table, then paste it into the log file-select the first cell in the area where you want to paste, click the arrow next to Paste on the Home tab, click Paste Special, and then click Values in the window that appears. You can then delete the pivot table from the 2010 data worksheet. If invalid Region values exist, you can sort the data by the Region field to group the problematic rows together
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66775978bfeb1_72066775978a527c.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started