Help 100% Sun 6:47 AM a E A1 Dan Instruments Q-S ch Sheet Excel File Edit View Insert Format Tools Data Window Auteuve A S5= Home Insert Draw Page Layout Formulas Data Review View H ou Calbrihedal - 11 AA E E Pastemt BI DHA E Share Comments Table Pro TV PE. Wrap Tent Merge & Center Custom 2. Autolun O Newwal - Calculation The Check Cell Good y Neutral not AY Sort & , Fird & 25 Ideas S % e rt Delete Format Sensitivity K X A B M N O P Q R S T U V W X Y Z AA AB .. . 1 Renter Instrument 2 Mogan Flute 3 Narre carnet 4 Chico French Horn 5 Roman Piomis 6 Diagoro Full 7 be Sanophone che Trombone 9 Gihooly Flute 10 Guys Fute 11 Swart Trombone 12 DI Bassoon 13 Linnill carnet 14 Aserty Trombone 15 M. A ndian 16 Maver Trombone 17 Scherck Flute 18 ind Flute 19 Bum Clarinet 20 Rand Flute 21 Turrdl Clarinet 22 Aserty Clarinet 23 Shenal Sanphone 24 Megles Accordian 25 Metz Picole 26 Senior Ful 27 Scherze Flute 26 Maria Sanphone 29 Mogan Flute 30 Hofmann Oboe 31 Guys Franch Horn 32 Ingraham Flute 33 Lund Clarinet 34 Werner Clarinet 35 Aserty Suophone 35 Melech Flute 37 Battenberg Sanophone SR Henry Trombone 39 Acond Flute 40 Cox French Horn 41 Melch Accordian 42 Allen Flute =IR@Shipping Codell-Pickup".0, Fleshipping Codell-'Ground 25,500 C D E F G H I J K L Shipping Group Insurance Shipping Rental Period ins cov Code Code Return Du R ental Cost Cost Total Co. B/15/16 3 Yes Pickup A 11/15/16 $ 47 $ 9 $ - $ 56 R/28/16 11/21/16 $ 47 S S 556 7/13/16 9 Yes Ground E 4/13/17 $ 550 $ 225 $ 25$ Ground C 10/17/16 5 90 $ 10 $ 255 133 7/2/16 10/2/16 $ 47 $ 15 . 9 5 6 31/16 3 Yes Ground 12/1/16 $ 100 $ S 2 5 161 R/0/16 Pickup 11/30/16 3 57 $ 125 $ 69 B/22/16 Ground A 11/22/16 $ 47 $ $ 25 $ 7/15/16 3 NO Ground A 10/15/16 S 17 $ . 255 72 S7 S 12 $ - $ 69 7/11/16 3 Yes 10/17/16 $ 400 $ 75 $ - $ 475 Nn 12/11/16 $ 47 $ - $ 50$ 97 7/30/16 Pidup B 10/30/16 $ 57 $ 12 $ anno Pidup D 12/30/16 5 100 $ 10 $ . 5 136 B/24/16 Pickup B 11/24/16 $ S7 $ 12 $ - $ 69 9/5/16 3 Yes Pidup A 125016 S 47 $ 9 $ - $ 56 4/8/16 1 Nn Pidup A 12/8/16 $ 47 $ . S - $ 47 8/2/16 Pickup 11/2/16 $ 47 $ 9 $ 3 Yes 11/9/16 5 17 S S 505 106 BA/16 11/12/16 $ 47 $ 9 $ 25 $ 81 7/24/16 3 Yes 10/24/16 $ 47 $ 9 $ - $ 56 9Y Rush 5/1/175 386 5 10 $ 505 444 9/5/16 Ground D 125416 S 100 $ 35 $ 25 $ 161 1G16 Ground C 11/10/1G3 $ - $ 25 5 115 BA15/16 5/15/17 $ 128 $ 20 $ - $ 155 a/8/16 3 Yes IBIG S 47 $ 9 $ $ 56 0/16 1 Y Pickup D 12/10/16 $ 100 $ S - $ 116 9/19/16 Ground 5/19/17 $ 128 $ 27 $ 25 $ 180 T/2/16 9 Yes 4/26/17 5 216 $ 54 - 5 270 7/17/16 1001746 S 400 $ 75 $ 25 $ 500 B0/16 11/30/16 $ 47 $ - $ - $ 47 5/14/17 $ 128 $ $ - $ 155 7/5/16 Pickup 305016 S 10/7/16 5 100 $ . . $ 100 9/14/16 Pickup 12/14/16 $ 47 $ 9 $ - $ 56 30/16 3 Yes 12/30/16 S 100 $ 35 $ - $ 126 7/12/16 Nn Rush 10/12/16 3 5 7 $ - $ 50 $ 107 7/9/16 Ground A 10/9/16 $ 47 $ 9 $ 25 $ 81 929/16 9 Yes Pidup E 5/29/175 650 $ 225 5 5 375 8/4/16 Pidup D 11/4/16 $ 100 $ 365 136 9/15/16 9 Yes 5/15/17 $ 128 $ 27 $ 50 $ 205 ******** Documentation Monthly Rent Rantal Dis t anta information Rent Report + 12. Create the Pivot Table shown in Figure below to display the number of rentals and rental $ by rental month. Rename the worksheet as Monthly Rentals. (Hint: Select any Rental Date in the Pivot Table, and then on the PIVOTTABLE TOOLS ANALYZE tab, in the Group group, click the Group Field button to open the Grouping dialog box. Use Months as the grouping field.) Monthly Rental Summary Pivot Table Aug # of Renters Total Rental $ Jul 14 $ 2,262 16 $ 1,322 Sep 11 $ 1.494 Grand Total 41 $ 5,078 13. In the Pivot Table, drill down to display the renters (all fields) in the source data that represent the 11 rentals in September. Rename the worksheet that is created as SeptDetail. (Hint: Double-click the appropriate cell in Pivot Table to open a new worksheet with the supporting data.) Help 100% Sun 6:47 AM a E A1 Dan Instruments Q-S ch Sheet Excel File Edit View Insert Format Tools Data Window Auteuve A S5= Home Insert Draw Page Layout Formulas Data Review View H ou Calbrihedal - 11 AA E E Pastemt BI DHA E Share Comments Table Pro TV PE. Wrap Tent Merge & Center Custom 2. Autolun O Newwal - Calculation The Check Cell Good y Neutral not AY Sort & , Fird & 25 Ideas S % e rt Delete Format Sensitivity K X A B M N O P Q R S T U V W X Y Z AA AB .. . 1 Renter Instrument 2 Mogan Flute 3 Narre carnet 4 Chico French Horn 5 Roman Piomis 6 Diagoro Full 7 be Sanophone che Trombone 9 Gihooly Flute 10 Guys Fute 11 Swart Trombone 12 DI Bassoon 13 Linnill carnet 14 Aserty Trombone 15 M. A ndian 16 Maver Trombone 17 Scherck Flute 18 ind Flute 19 Bum Clarinet 20 Rand Flute 21 Turrdl Clarinet 22 Aserty Clarinet 23 Shenal Sanphone 24 Megles Accordian 25 Metz Picole 26 Senior Ful 27 Scherze Flute 26 Maria Sanphone 29 Mogan Flute 30 Hofmann Oboe 31 Guys Franch Horn 32 Ingraham Flute 33 Lund Clarinet 34 Werner Clarinet 35 Aserty Suophone 35 Melech Flute 37 Battenberg Sanophone SR Henry Trombone 39 Acond Flute 40 Cox French Horn 41 Melch Accordian 42 Allen Flute =IR@Shipping Codell-Pickup".0, Fleshipping Codell-'Ground 25,500 C D E F G H I J K L Shipping Group Insurance Shipping Rental Period ins cov Code Code Return Du R ental Cost Cost Total Co. B/15/16 3 Yes Pickup A 11/15/16 $ 47 $ 9 $ - $ 56 R/28/16 11/21/16 $ 47 S S 556 7/13/16 9 Yes Ground E 4/13/17 $ 550 $ 225 $ 25$ Ground C 10/17/16 5 90 $ 10 $ 255 133 7/2/16 10/2/16 $ 47 $ 15 . 9 5 6 31/16 3 Yes Ground 12/1/16 $ 100 $ S 2 5 161 R/0/16 Pickup 11/30/16 3 57 $ 125 $ 69 B/22/16 Ground A 11/22/16 $ 47 $ $ 25 $ 7/15/16 3 NO Ground A 10/15/16 S 17 $ . 255 72 S7 S 12 $ - $ 69 7/11/16 3 Yes 10/17/16 $ 400 $ 75 $ - $ 475 Nn 12/11/16 $ 47 $ - $ 50$ 97 7/30/16 Pidup B 10/30/16 $ 57 $ 12 $ anno Pidup D 12/30/16 5 100 $ 10 $ . 5 136 B/24/16 Pickup B 11/24/16 $ S7 $ 12 $ - $ 69 9/5/16 3 Yes Pidup A 125016 S 47 $ 9 $ - $ 56 4/8/16 1 Nn Pidup A 12/8/16 $ 47 $ . S - $ 47 8/2/16 Pickup 11/2/16 $ 47 $ 9 $ 3 Yes 11/9/16 5 17 S S 505 106 BA/16 11/12/16 $ 47 $ 9 $ 25 $ 81 7/24/16 3 Yes 10/24/16 $ 47 $ 9 $ - $ 56 9Y Rush 5/1/175 386 5 10 $ 505 444 9/5/16 Ground D 125416 S 100 $ 35 $ 25 $ 161 1G16 Ground C 11/10/1G3 $ - $ 25 5 115 BA15/16 5/15/17 $ 128 $ 20 $ - $ 155 a/8/16 3 Yes IBIG S 47 $ 9 $ $ 56 0/16 1 Y Pickup D 12/10/16 $ 100 $ S - $ 116 9/19/16 Ground 5/19/17 $ 128 $ 27 $ 25 $ 180 T/2/16 9 Yes 4/26/17 5 216 $ 54 - 5 270 7/17/16 1001746 S 400 $ 75 $ 25 $ 500 B0/16 11/30/16 $ 47 $ - $ - $ 47 5/14/17 $ 128 $ $ - $ 155 7/5/16 Pickup 305016 S 10/7/16 5 100 $ . . $ 100 9/14/16 Pickup 12/14/16 $ 47 $ 9 $ - $ 56 30/16 3 Yes 12/30/16 S 100 $ 35 $ - $ 126 7/12/16 Nn Rush 10/12/16 3 5 7 $ - $ 50 $ 107 7/9/16 Ground A 10/9/16 $ 47 $ 9 $ 25 $ 81 929/16 9 Yes Pidup E 5/29/175 650 $ 225 5 5 375 8/4/16 Pidup D 11/4/16 $ 100 $ 365 136 9/15/16 9 Yes 5/15/17 $ 128 $ 27 $ 50 $ 205 ******** Documentation Monthly Rent Rantal Dis t anta information Rent Report + 12. Create the Pivot Table shown in Figure below to display the number of rentals and rental $ by rental month. Rename the worksheet as Monthly Rentals. (Hint: Select any Rental Date in the Pivot Table, and then on the PIVOTTABLE TOOLS ANALYZE tab, in the Group group, click the Group Field button to open the Grouping dialog box. Use Months as the grouping field.) Monthly Rental Summary Pivot Table Aug # of Renters Total Rental $ Jul 14 $ 2,262 16 $ 1,322 Sep 11 $ 1.494 Grand Total 41 $ 5,078 13. In the Pivot Table, drill down to display the renters (all fields) in the source data that represent the 11 rentals in September. Rename the worksheet that is created as SeptDetail. (Hint: Double-click the appropriate cell in Pivot Table to open a new worksheet with the supporting data.)