You can find the data for this chapter’s problems in the file Makeupsubtotals.xlsx. Use the Subtotal command for the following computations:    

Create a consolidated worksheet that gives the total unit sales and dollar revenue for each product by region.

Transcribed Image Text:

B 4 Trans Number Name 10 Betsy 11 Ashley 15 Zaret 16 Emilee 567 7 8 68 9 10 11 12 13 14 15 16 17 18 19 20 21 22222 23 24 25 45 Emilee 46 Ashley 58 Cristina 60 Jen 69 Cristina 77 Cristina 81 Jen 86 Jen 87 Emilee 98 Jen 108 Cici 114 Betsy 116 Zaret 119 Colleen 131 Jen 133 Betsy 140 Jen Date с D Product 8/7/2006 lip gloss 11/29/2004 mascara 9/20/2006 foundation 4/12/2004 mascara 9/20/2006 lip gloss 8/9/2005 mascara 4/12/2004 foundation 10/27/2004 mascara 1/23/2005 eye liner 1/15/2004 mascara 1/10/2006 lip gloss 8/9/2005 eye liner 8/31/2005 eye liner 4/12/2004 lip gloss 8/31/2005 lip gloss 9/22/2005 lipstick 6/24/2006 eye liner 5/22/2006 eye liner 11/29/2004 mascara 7/9/2004 mascara 6/28/2004 eye liner E Units F Dollars 24 $ 43 $ -8 $ 45 $ 2 $ 93 $ 34 $ 89 $ 73 $ 27 $ 69 $ -2 $ 5 $ 92 $ -10 $ 77 $ 22 $ 20 $ 56 $ 11 $ 80 $ Location 73.50 east 130.84 east (21.99) east 137.39 east 7.85 east 280.69 east 104.09 east 269.09 east 221.41 east 83.29 east 208.69 east (4.24) east 17.03 east G 277.54 east (28.41) east 233.33 east 68.07 east 62.37 east 168.87 east 34.42 east 242.50 east