File Home Home Insert Draw Page Layout Formulas Data Review View Help Shape Format Share Comme X Insert Calibri (Body) 14 ~A >|| General W DX Delete v Paste BI U $ - %. OO Conditional Format as Cell Formatting v Table Styles Sensitivity Format Sort & Find & Filter - Select Analyze Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity TextBox 1 H Perfect Record 1 Description of Issue (Highlight All Cells with issues) 1 1 1 1 1 Instructions 1 1 1 $ 1 A B 1 Part Number PartDescription 2 100022 Maple Flooring 3 180016 steal beams 4. 100023 Oak Flooring 5 100024 Birch Flooring 6 100025 Cherry Flooring 7 100026 Linoleum Flooring Design Opt 1 8 100027 Linoleum Flooring Design Opt 2 9 100027 Linoleum Flooring Design Opt 3 10 100029 Linoleum Flooring Design Opt 4 11 100030 Ceramic Tile Design Opt 1 12 100031 Ceramic Tile Design Opt 2 13 100032 Ceramic Tile Design Opt 3 14 100033 Ceramic Tile Design Opt 4 15 500011 Toilet - White 16 500012 Toilet - Off-White 17 500013 Toilet - Black 18 500014 Sink - White 19 500015 Sink - Off-White 20 500016 Sink - Black 21 500017 Basic Tub - White 22 500018 Basic Tub - Off-White 23 500019 Basic Tub - Black 24 500020 Jacuzzi Tub - White 25 500021 Jacuzzi Tub - Off-White 26 500022 Jacuzzi Tub - Black 27 500023 Stand Up Shower - White 28 500024 Stand Un Shower - Off-White Inventory InventoryClass E F G UOMCode Purchasing Cost Selling Price InventoryClass CommodityCode 1 $ 4.99 $ 8.99 B $ 9.48 $ 15.43 B 1 $ 3.99 $ 6.99 B Flooring 1 $ 5.99 S 9.99 B 1 $ 6.99 $ 10.99 B 1 $ 0.89 $ 2.00 B 1 $ 0.99 $ 2.50 B 1 $ 0.99 $ 2.50 B 1 $ 1.15 $ 3.25 B 3.99 $ 6.25 B 1 $ 4.99 $ 7.50 B Flooring 1 $ 4.99 S 7.50 B 1 $ 5.50 $ 8.75 B NULL $ 199.75 $ 385.25 A 2 $ 199.75 $ 385.25 A 2 $ 230.00 $ 450.99 A $ 89.99 $ 125.54 A 2 $ 89.99 $ 125.54 A 2 $ 99.99 $ 187.25 A 2 $ 450.25 $ 895.99 A 2 $ 450.25 $ 895.99 A 2 $ 599.00 $ 999.99 A $ 799.99 $ 1,500.00 A $ 799.99 $ 1,500.00 NULL $ 999.99 $ 2,000.00 A 2 $ 199.99 $ 300.00 A 2 S 199 99 $ 300 00 A The dataset represents 102 parts for a general contractor. Each part is represented by a part number (number), description (text), Unit of Measure (ie. How Many in a Set), Purchasing Cost (number), Selling Price (number), Inventory Class (see other worksheet), and Commodity Code (should be a number). 1 3 3 3 3 3 3 3 Your task is to identify the errors in the records and record them in column H with a NO and column I with what the error is. For records without any error make Column H YES. 3 3 Assume for this example all fields are mandatory. 3 3 Once complete calcualate the data quality (Perfect Records / Total 3 3 3