Answered step by step
Verified Expert Solution
Question
1 Approved Answer
8. Make one final copy of the Sales sheet and rename it Subtotals by Sales Type. Place this new sheet to the right of the
8. Make one final copy of the Sales sheet and rename it Subtotals by Sales Type. Place this new sheet to the right of the Sales by Product sheet. Subtotal the sheet by Sales Type, summing the Profit column.
9. Add a 2nd subtotal to the Subtotals by Type sheet that subtotals by Sales Type and averages the Profit column.
Dynamite Detergent Oustomer Sales Sales Type Online Online Online Online Online Online Online Retail Online Online Online Online Online Online Online Online Online Online Online Online Online Online Palau Online 23262 Candice Levy 23263 Xerxes Smith 23264 Levi Douglas 23265 Uniel Benton 23266 Celeste Pugh 23257 Vance Campos 23268 Latifah Wall 23269 lane Hernandez 23270 Wanda Garza 23271 Athena Fitzpatrick 23272 Anjolie Hicks 23273 Isaac Cooper 23274 Asher Weber 23275 Ethan Gregory 23276 Hayes Rollins 23277 Mackenzie Moss 23278 Aphrodite Brennan 23279 Angela Wise 23780 James Spencer 23281 Adria Kaufman 23282 Amir Alexander 23283 Lani Sweet 23284 Clark Weaver 23285 Leonard Cardenas 23286 Renee Padilla 23287 soy Vazquez 23288 Ingrid Bush 23289 Deacon Craig 23290 Rama Goodwin 23291 Mai Odonnell 23292 Liberty Mcbride 23293 Britanni Bender 23294 Samuel Ayala 23295 Shad Delacruz 23296 India Gilbert 23297 Ursula Mcconnell 23298 Ryder Conner 23299 Germaine Kidd 23300 Rhona Carke 23301 Maxwell Parker 23302 Isaac Wolf 23303 Guinevere Key 23304 Deanna Santana 23305 Lared Sandoval 23306 Ima Cummings 23307 Oprah Elis 23308 Dara Cunningham 23309 Buckminster Hopkins 23310 Kenyon Joyce Region Country Sub-Saharan Africa Congo Central America and the Caribbean Panama Sub-Saharan Africa Tanzania Sub-Saharan Africa South Africa Sub-Saharan Africa Gabon Middle East and North Africa Syrian Arab Republic Central America and the Caribbean Guadeloupe Europe Macedonia Asia Kyrgyastan Sub-Saharan Africa Reunion Central America and the Caribbean Turks and Caicos Island Central America and the Caribbean Netherlands Antilles Europe Macedonia Australia and Oceania Tuvalu Asia Nepal Middle East and North Africa Oman Sub-Saharan Africa Malawi Europe Moldova Sub-Saharan Africa Burkina Faso Australia and Oceania Bouvet Island Sub-Saharan Africa Liberia Australia and Oceania Vanuatu Australia and Oceania Sub-Saharan Africa Madagascar Middle East and North Africa Yemen Asia Korea Central America and the Caribbean Montserrat Asia Mongolia Middle East and North Africa Tunisia Europe Albania Australia and Oceania Fiji Sub-Saharan Africa Angola Sub-Saharan Africa Brazi Australia and Oceania Solomon Islands Europe Denmark Europe Hungary Central America and the Caribbean Virgin Islands, British Sub-Saharan Africa Niger Middle East and North Africa Palestinian Territory Sub-Saharan Africa Falkland Islands Central America and the Caribbean Panama Central America and the Caribbean Colombia Australia and Oceania Solomon Islands Sub-Saharan Africa Botswana Asia Philippines Central America and the Caribbean Dominican Republic Australia and Oceania Saint Helena Sub-Saharan Africa Sierra Leone North America Canada Product Sold SUPA101 DETA200 DETA800 SUPA104 PURA 200 PURA100 DETA100 PURA 100 SUPA103 SUPA103 DETA200 SUPA104 PURA 100 DETA800 PURA500 SUPA101 SUPA105 PURA 100 SUPA103 SUPA102 DETA100 SUPA105 PURA 250 SUPA102 DETABO PURA 250 SUPA104 SUPA105 DETARDO DETARDO SUPA105 SUPA101 DETA800 SUPA101 SUPA105 DETARDO PURA 250 PURA 200 SUPA104 SUPA103 PURASOO SUPA105 PURA200 DETA800 DETA 200 DETA100 PURA 100 PURA200 SUPA104 Online Online Retai Online Online Online Units Sold Date Sold Product Price Product Cost 117 8/9/2016 $20.50 $15.30 73 7/6/2016 $76.50 $63.50 205 8/18/2016 $89.00 $76.00 14 8/5/2016 $29.99 $15.00 170 8/5/2016 $5.99 $42.00 129 7/11/2016 $33.00 $21.50 82 7/12/2016 $66.00 $53.00 116 6/1/2016 $3.00 $2150 67 6/7/2016 $26.99 $13.50 125 7/27/2016 $26.99 $13.50 71 7/31/2016 $76.50 $63.50 22 8/13/2016 $29.99 $15.00 153 8/22/2016 $33.00 $2150 141 7/4/2016 $89.00 $76.00 65 8/1/2016 $36.50 $33.50 157 7/12/2016 $20 50 $15 30 197 8/24/2016 $24.50 $18.00 10 6/21/2016 $33.00 $2150 30 6/3/2016 $26.99 $13.50 134 7/13/2016 $24 50 $12.50 100 8/21/2016 $66.00 $53.00 142 6/24/2016 $24 50 $18.00 135 6/17/2016 $4450 $32.30 9 7/24/2016 $24.50 $12.50 69 &/R/2016 $89.00 $76.00 189 6/17/2016 $44.50 $32.30 141 6/15/2016 $29.99 $15.00 166 8/2/2016 $24.50 $18.00 170 8/11/2016 $89.00 $76.00 199 8/10/2016 $89.00 $76.00 73 7/3/2016 $24.50 $18.00 117 6/30/2016 $20.50 $15.30 160 6/22/2016 $89.00 $76.00 45 6/9/2016 $20.50 $15.30 37 6/8/2016 $24.50 $18.00 135 8/12/2016 $89.00 $76.00 12 7/28/2016 $44.50 $32.30 104 6/27/2016 $53.99 $42.00 167 7/7/2016 $29.99 $15.00 10R 7/19/2016 $26.99 $13.50 105 7/27/2016 $36.50 $33.50 176 8/17/2016 $24.50 $18.00 131 6/1/2016 $53.99 $42.00 188 8/26/2016 $89.00 $76.00 93 6/8/2016 $76.50 $63.50 113 7/4/2016 $66.00 $53.00 112 7/9/2016 $33.00 $21.50 201 6/23/2016 $53.99 $42.00 41 6/17/2016 $29.99 $15.00 Profit $5.20 $13.00 $13.00 $14.99 $11.99 $11.50 $13.00 $11.50 $13.49 $13.49 $13.00 $14.99 $11.50 $13.00 $3.00 $5.20 $6.50 $11.50 $13.49 $12.00 $13.00 $6.50 $12.20 $12.00 $13.00 $12.20 $14.99 $6.50 $13.00 $13.00 $6.50 $5.20 $13.00 $5.20 $6.50 $13.00 $12.20 $11.99 $14.99 $13.49 $3.00 $6.50 $11.99 $13.00 $13.00 $13.00 $11.50 $11.99 $14.99 Online Online Online Online Online Retail Online Online Online Online Online Online Online Online Online Retal Online Online Online Retail Dynamite Detergent Oustomer Sales Sales Type Online Online Online Online Online Online Online Retail Online Online Online Online Online Online Online Online Online Online Online Online Online Online Palau Online 23262 Candice Levy 23263 Xerxes Smith 23264 Levi Douglas 23265 Uniel Benton 23266 Celeste Pugh 23257 Vance Campos 23268 Latifah Wall 23269 lane Hernandez 23270 Wanda Garza 23271 Athena Fitzpatrick 23272 Anjolie Hicks 23273 Isaac Cooper 23274 Asher Weber 23275 Ethan Gregory 23276 Hayes Rollins 23277 Mackenzie Moss 23278 Aphrodite Brennan 23279 Angela Wise 23780 James Spencer 23281 Adria Kaufman 23282 Amir Alexander 23283 Lani Sweet 23284 Clark Weaver 23285 Leonard Cardenas 23286 Renee Padilla 23287 soy Vazquez 23288 Ingrid Bush 23289 Deacon Craig 23290 Rama Goodwin 23291 Mai Odonnell 23292 Liberty Mcbride 23293 Britanni Bender 23294 Samuel Ayala 23295 Shad Delacruz 23296 India Gilbert 23297 Ursula Mcconnell 23298 Ryder Conner 23299 Germaine Kidd 23300 Rhona Carke 23301 Maxwell Parker 23302 Isaac Wolf 23303 Guinevere Key 23304 Deanna Santana 23305 Lared Sandoval 23306 Ima Cummings 23307 Oprah Elis 23308 Dara Cunningham 23309 Buckminster Hopkins 23310 Kenyon Joyce Region Country Sub-Saharan Africa Congo Central America and the Caribbean Panama Sub-Saharan Africa Tanzania Sub-Saharan Africa South Africa Sub-Saharan Africa Gabon Middle East and North Africa Syrian Arab Republic Central America and the Caribbean Guadeloupe Europe Macedonia Asia Kyrgyastan Sub-Saharan Africa Reunion Central America and the Caribbean Turks and Caicos Island Central America and the Caribbean Netherlands Antilles Europe Macedonia Australia and Oceania Tuvalu Asia Nepal Middle East and North Africa Oman Sub-Saharan Africa Malawi Europe Moldova Sub-Saharan Africa Burkina Faso Australia and Oceania Bouvet Island Sub-Saharan Africa Liberia Australia and Oceania Vanuatu Australia and Oceania Sub-Saharan Africa Madagascar Middle East and North Africa Yemen Asia Korea Central America and the Caribbean Montserrat Asia Mongolia Middle East and North Africa Tunisia Europe Albania Australia and Oceania Fiji Sub-Saharan Africa Angola Sub-Saharan Africa Brazi Australia and Oceania Solomon Islands Europe Denmark Europe Hungary Central America and the Caribbean Virgin Islands, British Sub-Saharan Africa Niger Middle East and North Africa Palestinian Territory Sub-Saharan Africa Falkland Islands Central America and the Caribbean Panama Central America and the Caribbean Colombia Australia and Oceania Solomon Islands Sub-Saharan Africa Botswana Asia Philippines Central America and the Caribbean Dominican Republic Australia and Oceania Saint Helena Sub-Saharan Africa Sierra Leone North America Canada Product Sold SUPA101 DETA200 DETA800 SUPA104 PURA 200 PURA100 DETA100 PURA 100 SUPA103 SUPA103 DETA200 SUPA104 PURA 100 DETA800 PURA500 SUPA101 SUPA105 PURA 100 SUPA103 SUPA102 DETA100 SUPA105 PURA 250 SUPA102 DETABO PURA 250 SUPA104 SUPA105 DETARDO DETARDO SUPA105 SUPA101 DETA800 SUPA101 SUPA105 DETARDO PURA 250 PURA 200 SUPA104 SUPA103 PURASOO SUPA105 PURA200 DETA800 DETA 200 DETA100 PURA 100 PURA200 SUPA104 Online Online Retai Online Online Online Units Sold Date Sold Product Price Product Cost 117 8/9/2016 $20.50 $15.30 73 7/6/2016 $76.50 $63.50 205 8/18/2016 $89.00 $76.00 14 8/5/2016 $29.99 $15.00 170 8/5/2016 $5.99 $42.00 129 7/11/2016 $33.00 $21.50 82 7/12/2016 $66.00 $53.00 116 6/1/2016 $3.00 $2150 67 6/7/2016 $26.99 $13.50 125 7/27/2016 $26.99 $13.50 71 7/31/2016 $76.50 $63.50 22 8/13/2016 $29.99 $15.00 153 8/22/2016 $33.00 $2150 141 7/4/2016 $89.00 $76.00 65 8/1/2016 $36.50 $33.50 157 7/12/2016 $20 50 $15 30 197 8/24/2016 $24.50 $18.00 10 6/21/2016 $33.00 $2150 30 6/3/2016 $26.99 $13.50 134 7/13/2016 $24 50 $12.50 100 8/21/2016 $66.00 $53.00 142 6/24/2016 $24 50 $18.00 135 6/17/2016 $4450 $32.30 9 7/24/2016 $24.50 $12.50 69 &/R/2016 $89.00 $76.00 189 6/17/2016 $44.50 $32.30 141 6/15/2016 $29.99 $15.00 166 8/2/2016 $24.50 $18.00 170 8/11/2016 $89.00 $76.00 199 8/10/2016 $89.00 $76.00 73 7/3/2016 $24.50 $18.00 117 6/30/2016 $20.50 $15.30 160 6/22/2016 $89.00 $76.00 45 6/9/2016 $20.50 $15.30 37 6/8/2016 $24.50 $18.00 135 8/12/2016 $89.00 $76.00 12 7/28/2016 $44.50 $32.30 104 6/27/2016 $53.99 $42.00 167 7/7/2016 $29.99 $15.00 10R 7/19/2016 $26.99 $13.50 105 7/27/2016 $36.50 $33.50 176 8/17/2016 $24.50 $18.00 131 6/1/2016 $53.99 $42.00 188 8/26/2016 $89.00 $76.00 93 6/8/2016 $76.50 $63.50 113 7/4/2016 $66.00 $53.00 112 7/9/2016 $33.00 $21.50 201 6/23/2016 $53.99 $42.00 41 6/17/2016 $29.99 $15.00 Profit $5.20 $13.00 $13.00 $14.99 $11.99 $11.50 $13.00 $11.50 $13.49 $13.49 $13.00 $14.99 $11.50 $13.00 $3.00 $5.20 $6.50 $11.50 $13.49 $12.00 $13.00 $6.50 $12.20 $12.00 $13.00 $12.20 $14.99 $6.50 $13.00 $13.00 $6.50 $5.20 $13.00 $5.20 $6.50 $13.00 $12.20 $11.99 $14.99 $13.49 $3.00 $6.50 $11.99 $13.00 $13.00 $13.00 $11.50 $11.99 $14.99 Online Online Online Online Online Retail Online Online Online Online Online Online Online Online Online Retal Online Online Online RetailStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started