i need change on the excel that is already done but the scoreis only 73 out 100 i have the report can anyone please help for the mistake due today

Shelly Cashman Excel 2013 Chapter 8: SAM Project 1a Precision Guitars WORKING WITH PIVOTTABLES AND PIVOTCHARTS Author: Liting Wang Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Precision Instrument Manufacturing 2013-2016 Guitar Sales Model A100 A105 A110 A115 A120 A150 AE100 AE110 AE115 AE120 E100 E105 E110 Type Price/unit 2013 Sale2014 Sale2015 Sale2016 Sales Acoustic $99.00 $5,742 $5,940 $4,158 $2,970 Acoustic $149.00 $1,192 $1,490 $1,639 $1,490 Acoustic $119.00 $4,522 $5,236 $3,094 $3,213 Acoustic $209.00 $1,045 $627 $418 $627 Acoustic $249.00 $1,245 $747 $498 $747 Acoustic $409.00 $1,227 $818 $1,227 $818 Acoustic-Ele $149.00 $4,172 $4,619 $5,662 $6,705 Acoustic-Ele $179.00 $9,935 $9,935 $10,561 $11,456 Acoustic-Ele $209.00 $7,315 $8,569 $7,733 $5,852 Acoustic-Ele $309.00 $3,245 $4,017 $4,326 $5,253 Electric $79.00 $5,688 $7,031 $5,688 $4,582 Electric $149.00 $1,937 $2,533 $2,831 $4,470 Electric $209.00 $11,077 $8,569 $5,852 $6,061 016 Sales Precision Instrument Manufacturing Total Sales by Guitar Type 2013 - 2016 $30,000 $25,000 $20,000 Data Column C Column D Column E Dollar (U.S.) $15,000 $10,000 $5,000 $- Type Acoustic Guitar Type Acoustic-Electric Electric Type Electric Model E100 Customer Data Sum - Quantity Jackson Music Scho Patriot's Hill Music Starz Music Center E105 Ace Guitar World Earle's Guitar Emp Maui Guitar Center E110 Ace Guitar World Earle's Guitar Emp Jackson Music Scho Total Result Sum - Total Amount 58 #VALUE! 13 #VALUE! 20 #VALUE! 25 #VALUE! 30 #VALUE! 10 #VALUE! 8 #VALUE! 12 #VALUE! 29 #VALUE! 8 #VALUE! 5 #VALUE! 16 #VALUE! 117 #VALUE! um - Total Amount Precision Instrument Manufacturing Guitars Sold to All Customers in 2016 Sum - Quantity Type Customer Acoustic Ace Guitar World Earle's Guitar Emporium Firefly Music and Arts Jackson Music School Maui Guitar Center Patriot's Hill Music Starz Music Center Westwood Music Academy Total Result Acoustic-Electric Electric Total Result 24 18 42 8 15 13 36 15 5 20 12 15 29 56 13 41 12 66 10 30 20 60 12 12 25 49 5 12 17 75 154 117 346 180 160 140 120 100 80 60 40 20 0 Type Acoustic Acoustic-Electric Electric al Result Precision Instrument Manufacturing 2016 Guitar Sales Order # Customer 1 Maui Guitar Center 2 Westwood Music Academy 3 Maui Guitar Center 4 Maui Guitar Center 5 Jackson Music School 6 Jackson Music School 7 Jackson Music School 8 Firefly Music and Arts 9 Ace Guitar World 10 Westwood Music Academy 11 Starz Music Center 12 Firefly Music and Arts 13 Ace Guitar World 14 Ace Guitar World 15 Starz Music Center 16 Earle's Guitar Emporium 17 Westwood Music Academy 18 Starz Music Center 19 Earle's Guitar Emporium 20 Firefly Music and Arts 21 Starz Music Center 22 Maui Guitar Center 23 Maui Guitar Center 24 Maui Guitar Center 25 Ace Guitar World 26 Starz Music Center 27 Patriot's Hill Music 28 Patriot's Hill Music 29 Patriot's Hill Music 30 Ace Guitar World 31 Jackson Music School 32 Jackson Music School 33 Jackson Music School 34 Earle's Guitar Emporium 35 Westwood Music Academy 36 Firefly Music and Arts 37 Earle's Guitar Emporium 38 Earle's Guitar Emporium 39 Ace Guitar World 40 Earle's Guitar Emporium 41 Starz Music Center 42 Earle's Guitar Emporium 43 Ace Guitar World 44 Patriot's Hill Music Type Customer ID Date Acoustic-Electric 323 1/1/2016 Acoustic-Electric 229 1/1/2016 Acoustic-Electric 323 1/1/2016 Acoustic-Electric 323 1/1/2016 Electric 301 1/10/2016 Electric 301 1/10/2016 Acoustic 301 1/10/2016 Acoustic 250 1/15/2016 Acoustic-Electric 160 1/15/2016 Acoustic-Electric 229 2/15/2016 Acoustic 170 2/15/2016 Acoustic 250 3/15/2016 Electric 160 3/15/2016 Acoustic-Electric 160 4/1/2016 Electric 170 4/14/2016 Acoustic-Electric 151 5/1/2016 Acoustic 229 5/15/2016 Acoustic-Electric 170 5/15/2016 Acoustic-Electric 151 6/1/2016 Acoustic 250 6/15/2016 Acoustic-Electric 170 7/1/2016 Acoustic 323 7/5/2016 Electric 323 7/5/2016 Acoustic 323 7/5/2016 Acoustic-Electric 160 7/5/2016 Electric 170 8/1/2016 Acoustic 422 8/1/2016 Electric 422 8/1/2016 Acoustic-Electric 422 8/1/2016 Electric 160 8/5/2016 Acoustic 301 8/10/2016 Acoustic-Electric 301 8/10/2016 Electric 301 8/10/2016 Acoustic-Electric 151 8/13/2016 Acoustic-Electric 229 8/15/2016 Acoustic 250 8/15/2016 Acoustic 151 9/1/2016 Electric 151 9/13/2016 Electric 160 10/1/2016 Electric 151 ### Acoustic 170 ### Acoustic 151 ### Acoustic-Electric 160 ### Electric 422 12/1/2016 45 Patriot's Hill Music 46 Patriot's Hill Music 47 Westwood Music Academy 48 Firefly Music and Arts 49 Patriot's Hill Music 50 Maui Guitar Center Total Acoustic-Electric Acoustic Acoustic-Electric Acoustic-Electric Acoustic-Electric Acoustic-Electric 422 12/1/2016 422 12/1/2016 229 ### 250 ### 422 12/1/2016 323 1/1/2016 Manufacturing Sales Model AE100 AE115 AE110 AE120 E100 E110 A110 A100 AE115 AE115 A100 A100 E105 AE110 E100 AE120 A100 AE115 AE115 A100 AE110 A110 E105 A115 AE100 E100 A105 E100 AE110 E110 A110 AE100 E110 AE115 AE115 A100 A120 E105 E110 E110 A150 A110 AE100 E100 Quantity Price/unit Total Amount 10 $149.00 Err:509 3 $209.00 Err:509 10 $179.00 Err:509 10 $309.00 Err:509 13 $79.00 Err:509 12 $209.00 Err:509 6 $119.00 Err:509 4 $99.00 Err:509 5 $209.00 Err:509 3 $209.00 Err:509 10 $99.00 Err:509 4 $99.00 Err:509 10 $149.00 Err:509 4 $179.00 Err:509 10 $79.00 Err:509 7 $309.00 Err:509 5 $99.00 Err:509 3 $209.00 Err:509 3 $209.00 Err:509 3 $99.00 Err:509 9 $179.00 Err:509 10 $119.00 Err:509 12 $149.00 Err:509 3 $209.00 Err:509 12 $149.00 Err:509 15 $79.00 Err:509 5 $149.00 Err:509 10 $79.00 Err:509 10 $179.00 Err:509 3 $209.00 Err:509 6 $119.00 Err:509 15 $149.00 Err:509 4 $209.00 Err:509 5 $209.00 Err:509 3 $209.00 Err:509 4 $99.00 Err:509 3 $249.00 Err:509 8 $149.00 Err:509 5 $209.00 Err:509 5 $209.00 Err:509 2 $409.00 Err:509 5 $119.00 Err:509 3 $149.00 Err:509 10 $79.00 Err:509 AE110 A105 AE115 AE100 AE110 AE110 10 5 3 5 10 11 $179.00 $149.00 $209.00 $149.00 $179.00 $179.00 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:508 Precision Instrument Manufacturing 2016 Guitar Sales by Customer Customer Ace Guitar World Type Acoustic-Electric Electric Earle's Guitar Emporium Acoustic Acoustic-Electric Electric Firefly Music and Arts Acoustic Acoustic-Electric Jackson Music School Acoustic Acoustic-Electric Electric Maui Guitar Center Acoustic Acoustic-Electric Electric Patriot's Hill Music Acoustic Acoustic-Electric Electric Starz Music Center Acoustic Acoustic-Electric Electric Westwood Music Academy Acoustic Acoustic-Electric Total Result Data Count - Order # 7 4 3 7 2 3 2 5 4 1 6 2 1 3 7 2 4 1 7 2 3 2 6 2 2 2 5 1 4 50 Sum - Quantity 42 24 18 36 8 15 13 20 15 5 56 12 15 29 66 13 41 12 60 10 30 20 49 12 12 25 17 5 12 346 Sum - Total Amount #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Precision Instrument Manufacturing 2016 Guitar Sales by Model and Month Sum - Quantity Model A100 Date CustJan Feb May Aug Dec Westwood Mus 5 A105 Patriot's Hill Music 5 Jacks 6 5 A110 6 AE100 Jackson Music Scho 15 Patriot's Hill Music 10 20 3 3 Jacks 13 Patriot's Hill Music 10 10 Jacks 12 34 4 53 38 AE110 AE115 West 3 3 E100 E110 Total Result 3 5 This shape represents a slicer. Slicers are supported in Excel 2010 or later. If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used. This shape represents a slicer. Slicers can be used in at least Excel 2010. If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used. Precision Instrument Manufacturing Guitar Sales - Actual and Forecast Electric Acoustic Acoustic Electric Total 2013 $14,973 $45,160 $24,666 $84,799 2014 $14,858 $32,778 $27,140 $74,776 2015 $11,034 $28,282 $28,282 $67,598 2016 $9,865 $25,507 $29,266 $64,638 2017 $9,766 $24,270 $30,309 $64,345 Guitar Sales - Actual and Forecast Dollars (U.S.) $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 2013 2014 2015 Year 2016 2017 Precision Instrument Manufacturing Acoustic Electric Guitar 2013-2017 Sales $32,500 $30,000 R = 0.9544720605 $27,500 Dollars (U.S.) $25,000 $22,500 $20,000 2013 2014 2015 Year 2016 2017