1.

Generate numbers 1 to 500 in a 50x10 grid without using any formula

2. Post Generation, highlight alternate cells in the grid in yellow color starting with first cell
Roll Number Candidate Name Gender Work Ex (in months)
2022PGP001 A1 F 12
2022PGP002 A2 M 29
2022PGP003 A3 M 0
2022PGP004 A4 F 8 In the given dataset
2022PGP005 A5 M 4 1. Find the number of males and fe
2022PGP006 A6 F 19 2. Find the number of students wit
2022PGP007 A7 F 9 3. Find the number of male and fem
2022PGP008 A8 M 0 4. Estimate the average male and f
2022PGP009 A9 F 18 5. Highlight cells with freshers, wor
2022PGP010 A10 M 32
2022PGP011 A11 F 34
2022PGP012 A12 F 0
2022PGP013 A13 M 7
2022PGP014 A14 M 23
2022PGP015 A15 F 11
2022PGP016 A16 F 21
2022PGP017 A17 F 3
2022PGP018 A18 M 17
2022PGP019 A19 M 26
2022PGP020 A20 F 6
2022PGP021 A21 M 35
2022PGP022 A22 M 4
2022PGP023 A23 M 0
2022PGP024 A24 M 36
2022PGP025 A25 M 0
2022PGP026 A26 F 20
2022PGP027 A27 M 29
2022PGP028 A28 F 0
2022PGP029 A29 F 3
2022PGP030 A30 F 23
2022PGP031 A31 M 33
2022PGP032 A32 M 8
2022PGP033 A33 M 0
2022PGP034 A34 F 30
2022PGP035 A35 M 4
2022PGP036 A36 M 24
2022PGP037 A37 F 0
2022PGP038 A38 M 6
2022PGP039 A39 M 16
2022PGP040 A40 F 16
2022PGP041 A41 M 3
2022PGP042 A42 M 3
2022PGP043 A43 M 0
2022PGP044 A44 F 20
2022PGP045 A45 F 26
2022PGP046 A46 M 1
2022PGP047 A47 M 19
2022PGP048 A48 M 0
2022PGP049 A49 F 26
2022PGP050 A50 M 16
2022PGP051 A51 F 17
2022PGP052 A52 M 0
2022PGP053 A53 M 14
2022PGP054 A54 M 8
2022PGP055 A55 M 15
2022PGP056 A56 M 0
2022PGP057 A57 M 30
2022PGP058 A58 M 13
2022PGP059 A59 M 0
2022PGP060 A60 F 8
2022PGP061 A61 M 17
2022PGP062 A62 M 25
2022PGP063 A63 F 26
2022PGP064 A64 F 0
2022PGP065 A65 M 11
2022PGP066 A66 M 0
2022PGP067 A67 M 38
2022PGP068 A68 M 27
2022PGP069 A69 F 0
2022PGP070 A70 F 14
2022PGP071 A71 M 7
2022PGP072 A72 F 0
2022PGP073 A73 F 33
2022PGP074 A74 F 16
2022PGP075 A75 M 1
2022PGP076 A76 M 0
2022PGP077 A77 M 25
2022PGP078 A78 F 2
2022PGP079 A79 F 14
2022PGP080 A80 M 24
2022PGP081 A81 F 0
2022PGP082 A82 M 18
2022PGP083 A83 F 25
2022PGP084 A84 M 37
2022PGP085 A85 M 0
2022PGP086 A86 F 5
2022PGP087 A87 F 30
2022PGP088 A88 M 1
2022PGP089 A89 M 0
2022PGP090 A90 M 2
2022PGP091 A91 F 24
2022PGP092 A92 F 18
2022PGP093 A93 M 0
2022PGP094 A94 F 22
2022PGP095 A95 M 3
2022PGP096 A96 F 27
2022PGP097 A97 F 0
2022PGP098 A98 M 14
2022PGP099 A99 M 2
2022PGP100 A100 M 9
2022PGP101 A101 M 29
2022PGP102 A102 M 25
2022PGP103 A103 F 0
2022PGP104 A104 M 4
2022PGP105 A105 M 38
2022PGP106 A106 F 0
2022PGP107 A107 F 7
2022PGP108 A108 F 6
2022PGP109 A109 F 0
2022PGP110 A110 M 15
2022PGP111 A111 M 0
2022PGP112 A112 F 38
2022PGP113 A113 M 0
2022PGP114 A114 M 23
2022PGP115 A115 F 0
2022PGP116 A116 M 4
2022PGP117 A117 F 0
2022PGP118 A118 M 0
2022PGP119 A119 F 32
2022PGP120 A120 F 5
2022PGP121 A121 F 0
2022PGP122 A122 M 0
2022PGP123 A123 M 0
2022PGP124 A124 F 14
2022PGP125 A125 M 27
2022PGP126 A126 F 0
2022PGP127 A127 F 2
2022PGP128 A128 M 31
2022PGP129 A129 F 0
2022PGP130 A130 M 28
2022PGP131 A131 M 0
2022PGP132 A132 M 0
2022PGP133 A133 M 0
2022PGP134 A134 M 0
2022PGP135 A135 F 18
2022PGP136 A136 F 2
2022PGP137 A137 F 28
2022PGP138 A138 M 34
2022PGP139 A139 F 0
2022PGP140 A140 M 0
2022PGP141 A141 F 0
2022PGP142 A142 M 2
2022PGP143 A143 F 33
2022PGP144 A144 M 38
2022PGP145 A145 F 33
2022PGP146 A146 F 0
2022PGP147 A147 M 16
2022PGP148 A148 M 2
2022PGP149 A149 F 6
2022PGP150 A150 M 0
2022PGP151 A151 F 17
2022PGP152 A152 M 15
2022PGP153 A153 F 15
2022PGP154 A154 M 28
2022PGP155 A155 M 0
2022PGP156 A156 F 7
2022PGP157 A157 F 35
2022PGP158 A158 F 36
2022PGP159 A159 M 5
2022PGP160 A160 M 0
2022PGP161 A161 M 37
2022PGP162 A162 M 26
2022PGP163 A163 F 20
2022PGP164 A164 M 0
2022PGP165 A165 F 38
2022PGP166 A166 M 31
2022PGP167 A167 F 22
2022PGP168 A168 M 0
2022PGP169 A169 F 22
2022PGP170 A170 M 26
2022PGP171 A171 F 36
2022PGP172 A172 F 16
2022PGP173 A173 F 0
2022PGP174 A174 M 10
2022PGP175 A175 M 29
2022PGP176 A176 F 1
2022PGP177 A177 F 4
2022PGP178 A178 M 28
2022PGP179 A179 F 31
2022PGP180 A180 M 1
2022PGP181 A181 M 34
2022PGP182 A182 F 28
2022PGP183 A183 F 32
2022PGP184 A184 F 29
2022PGP185 A185 F 20
2022PGP186 A186 F 16
2022PGP187 A187 F 27
2022PGP188 A188 F 8
2022PGP189 A189 M 17
2022PGP190 A190 M 35
2022PGP191 A191 M 0
2022PGP192 A192 F 6
2022PGP193 A193 M 18
2022PGP194 A194 M 19
2022PGP195 A195 M 28
2022PGP196 A196 M 8
2022PGP197 A197 F 2
2022PGP198 A198 M 15
2022PGP199 A199 F 33
2022PGP200 A200 M 4
en dataset
e number of males and female and their percentages
e number of students with work ex and estimate the average work ex
e number of male and female candidates with workex
e the average male and female workex
ht cells with freshers, work exp between 0-1 years, 1-2 years and 2+ years with different colour codes
Roll Number Candidate Name Company Profile Day
2022PGP008 A8 AMZN OPS 0
2022PGP012 A12 HS OPS 0
2022PGP016 A16 CCG OPS 0
2022PGP019 A19 MSFT CONSULTING 0
2022PGP024 A24 MSFT FIN 0
2022PGP031 A31 GOOGL OPS 0
2022PGP034 A34 MTRX IT 0
2022PGP049 A49 HS IT 0
2022PGP052 A52 MSFT CONSULTING 0
2022PGP063 A63 JPM CONSULTING 0
2022PGP065 A65 MSFT FIN 0
2022PGP066 A66 BCSF CONSULTING 0
2022PGP074 A74 MSFT OPS 0
2022PGP076 A76 AMZN IT 0
2022PGP078 A78 GOOGL FIN 0
2022PGP090 A90 MTRX IT 0
2022PGP097 A97 MSFT OPS 0
2022PGP098 A98 MSFT OPS 0
2022PGP100 A100 BCSF FIN 0
2022PGP105 A105 AMZN CONSULTING 0
2022PGP112 A112 BCSF OPS 0
2022PGP113 A113 JPM CONSULTING 0
2022PGP119 A119 MSFT CONSULTING 0
2022PGP120 A120 MTRX CONSULTING 0
2022PGP123 A123 JPM IT 0
2022PGP125 A125 MTRX FIN 0
2022PGP128 A128 CCG S&M 0
2022PGP134 A134 HS CONSULTING 0
2022PGP139 A139 MTRX CONSULTING 0
2022PGP143 A143 CCG CONSULTING 0
2022PGP148 A148 MSFT OPS 0
2022PGP154 A154 CCG IT 0
2022PGP155 A155 MTRX S&M 0
2022PGP156 A156 AMZN FIN 0
2022PGP157 A157 JPM CONSULTING 0
2022PGP158 A158 MTRX FIN 0
2022PGP159 A159 MTRX CONSULTING 0
2022PGP166 A166 AMZN FIN 0
2022PGP167 A167 CCG S&M 0
2022PGP169 A169 MTRX S&M 0
2022PGP174 A174 MTRX OPS 0
2022PGP175 A175 MTRX FIN 0
2022PGP176 A176 CCG CONSULTING 0
2022PGP180 A180 MSFT OPS 0
2022PGP185 A185 AMZN OPS 0
2022PGP186 A186 JPM IT 0
2022PGP191 A191 HS IT 0
2022PGP192 A192 HS IT 0
2022PGP197 A197 HS FIN 0
2022PGP013 A13 MTRX FIN 1
2022PGP015 A15 MSFT S&M 1
2022PGP017 A17 MTRX IT 1
2022PGP020 A20 CCG OPS 1
2022PGP026 A26 BCSF OPS 1
2022PGP027 A27 MTRX CONSULTING 1
2022PGP036 A36 BCSF FIN 1
2022PGP037 A37 HS S&M 1
2022PGP039 A39 BCSF IT 1
2022PGP045 A45 MSFT IT 1
2022PGP054 A54 HS OPS 1
2022PGP055 A55 MTRX FIN 1
2022PGP056 A56 MSFT IT 1
2022PGP061 A61 MTRX OPS 1
2022PGP062 A62 AMZN OPS 1
2022PGP064 A64 MTRX IT 1
2022PGP068 A68 MTRX OPS 1
2022PGP070 A70 MTRX IT 1
2022PGP080 A80 CCG S&M 1
2022PGP081 A81 GOOGL IT 1
2022PGP082 A82 AMZN CONSULTING 1
2022PGP084 A84 HS OPS 1
2022PGP086 A86 MTRX IT 1
2022PGP088 A88 AMZN S&M 1
2022PGP095 A95 AMZN CONSULTING 1
2022PGP096 A96 MTRX S&M 1
2022PGP104 A104 MTRX CONSULTING 1
2022PGP106 A106 JPM S&M 1
2022PGP111 A111 GOOGL FIN 1
2022PGP115 A115 CCG FIN 1
2022PGP118 A118 MTRX S&M 1
2022PGP122 A122 MTRX CONSULTING 1
2022PGP129 A129 CCG OPS 1
2022PGP130 A130 AMZN S&M 1
2022PGP133 A133 BCSF S&M 1
2022PGP136 A136 BCSF IT 1
2022PGP137 A137 GOOGL S&M 1
2022PGP140 A140 CCG CONSULTING 1
2022PGP141 A141 BCSF FIN 1
2022PGP146 A146 AMZN S&M 1
2022PGP151 A151 MTRX FIN 1
2022PGP152 A152 GOOGL FIN 1
2022PGP153 A153 GOOGL IT 1
2022PGP163 A163 JPM OPS 1
2022PGP170 A170 MSFT OPS 1
2022PGP172 A172 MTRX S&M 1
2022PGP173 A173 CCG OPS 1
2022PGP179 A179 CCG FIN 1
2022PGP182 A182 JPM IT 1
2022PGP184 A184 HS S&M 1
2022PGP187 A187 AMZN IT 1
2022PGP188 A188 HS FIN 1
2022PGP001 A1 BCSF CONSULTING 2
2022PGP002 A2 MTRX FIN 2
2022PGP003 A3 AMZN S&M 2
2022PGP005 A5 JPM S&M 2
2022PGP007 A7 AMZN OPS 2
2022PGP010 A10 MSFT FIN 2
2022PGP011 A11 MTRX S&M 2
2022PGP014 A14 MSFT S&M 2
2022PGP029 A29 CCG FIN 2
2022PGP035 A35 MTRX FIN 2
2022PGP038 A38 MTRX IT 2
2022PGP040 A40 CCG OPS 2
2022PGP041 A41 BCSF OPS 2
2022PGP042 A42 BCSF OPS 2
2022PGP043 A43 GOOGL S&M 2
2022PGP048 A48 CCG S&M 2
2022PGP053 A53 HS IT 2
2022PGP069 A69 MTRX CONSULTING 2
2022PGP071 A71 MTRX S&M 2
2022PGP072 A72 AMZN OPS 2
2022PGP073 A73 MTRX S&M 2
2022PGP075 A75 CCG S&M 2
2022PGP077 A77 JPM S&M 2
2022PGP083 A83 JPM OPS 2
2022PGP089 A89 AMZN S&M 2
2022PGP092 A92 AMZN OPS 2
2022PGP093 A93 MSFT FIN 2
2022PGP101 A101 AMZN IT 2
2022PGP103 A103 JPM IT 2
2022PGP107 A107 CCG FIN 2
2022PGP109 A109 CCG CONSULTING 2
2022PGP116 A116 MSFT CONSULTING 2
2022PGP124 A124 MSFT FIN 2
2022PGP126 A126 GOOGL IT 2
2022PGP135 A135 MSFT OPS 2
2022PGP142 A142 BCSF IT 2
2022PGP145 A145 HS IT 2
2022PGP149 A149 MTRX CONSULTING 2
2022PGP160 A160 JPM S&M 2
2022PGP162 A162 MSFT S&M 2
2022PGP165 A165 BCSF CONSULTING 2
2022PGP168 A168 CCG FIN 2
2022PGP178 A178 JPM S&M 2
2022PGP181 A181 CCG IT 2
2022PGP189 A189 MSFT IT 2
2022PGP194 A194 GOOGL S&M 2
2022PGP198 A198 GOOGL FIN 2
2022PGP004 A4 MSFT OPS 3
2022PGP006 A6 HS OPS 3
2022PGP009 A9 MSFT S&M 3
2022PGP018 A18 CCG S&M 3
2022PGP021 A21 MSFT IT 3
2022PGP022 A22 AMZN FIN 3
2022PGP023 A23 GOOGL OPS 3
2022PGP025 A25 MSFT FIN 3
2022PGP028 A28 MSFT OPS 3
2022PGP030 A30 JPM S&M 3
2022PGP032 A32 MSFT CONSULTING 3
2022PGP033 A33 AMZN OPS 3
2022PGP044 A44 AMZN S&M 3
2022PGP046 A46 CCG IT 3
2022PGP047 A47 CCG FIN 3
2022PGP050 A50 HS CONSULTING 3
2022PGP051 A51 HS FIN 3
2022PGP057 A57 JPM CONSULTING 3
2022PGP058 A58 GOOGL OPS 3
2022PGP059 A59 CCG FIN 3
2022PGP060 A60 AMZN CONSULTING 3
2022PGP067 A67 MTRX FIN 3
2022PGP079 A79 MSFT S&M 3
2022PGP085 A85 MTRX IT 3
2022PGP087 A87 MSFT FIN 3
2022PGP091 A91 CCG CONSULTING 3
2022PGP094 A94 MTRX OPS 3
2022PGP099 A99 GOOGL S&M 3
2022PGP102 A102 GOOGL CONSULTING 3
2022PGP108 A108 HS IT 3
2022PGP110 A110 CCG CONSULTING 3
2022PGP114 A114 CCG OPS 3
2022PGP117 A117 MSFT OPS 3
2022PGP121 A121 AMZN CONSULTING 3
2022PGP127 A127 BCSF IT 3
2022PGP131 A131 HS S&M 3
2022PGP132 A132 MTRX IT 3
2022PGP138 A138 HS FIN 3
2022PGP144 A144 MTRX OPS 3
2022PGP147 A147 HS FIN 3
2022PGP150 A150 BCSF IT 3
2022PGP161 A161 AMZN IT 3
2022PGP164 A164 CCG FIN 3
2022PGP171 A171 CCG IT 3
2022PGP177 A177 CCG CONSULTING 3
2022PGP183 A183 CCG S&M 3
2022PGP190 A190 MTRX FIN 3
2022PGP193 A193 GOOGL FIN 3
2022PGP195 A195 GOOGL FIN 3
2022PGP196 A196 MTRX CONSULTING 3
2022PGP199 A199 CCG CONSULTING 3
2022PGP200 A200 MSFT IT 3
1) Calculate the number of offers from each company
2) Calculate the number of offers daywise
3) For each day, calculate the number of offers companywise and sectorwise
4) Using the following table estimate the average, median and top 10% and top 50% averages for the d

Company Day 0 stipend Day 1 Stipend

BCSF 58 49
MTRX 85 40
AMZN 70 47
MSFT 58 47
JPM 53 50
HS 88 45
CCG 93 48
GOOGL 53 42

5) Using the Data from Q2, estimate the average stipends for work ex and non work ex candidates
6) Using the data from Q2, estimate the average stipend for each gender
rwise
and top 50% averages for the dataset

Day 2 stipend Day 3 Stipend

36 20
27 19
35 17
33 20
38 20
39 18
38 16
35 15

nd non work ex candidates

er
No. Date Coupon Payment Method Product Region Price
1 5/22/2010 Coupon MasterCard Carlota West 22.95
2 6/29/2010 Coupon MasterCard Yanaki West 19.95
3 11/5/2010 No Coupon MasterCard Aspen East 21.95
4 8/31/2010 No Coupon American Express Yanaki West 19.95
5 5/30/2010 Coupon Visa Yanaki West 19.95
6 10/5/2010 Coupon PayPal Yanaki South 19.95
7 3/22/2010 Coupon Visa Yanaki West 19.95
8 6/14/2010 No Coupon Discover Yanaki West 19.95
9 5/9/2010 No Coupon American Express Yanaki West 19.95
10 8/28/2010 No Coupon Visa Aspen West 21.95
11 11/30/2010 Coupon PayPal Aspen North 21.95
12 9/13/2010 No Coupon MasterCard Yanaki North 19.95
13 10/23/2010 No Coupon Visa Carlota North 22.95
14 9/19/2010 No Coupon PayPal Carlota West 22.95
15 9/20/2010 No Coupon American Express Carlota North 22.95
16 1/18/2010 Coupon Visa Carlota West 22.95
17 7/28/2010 No Coupon Discover Sunset West 24.95
18 6/6/2010 No Coupon PayPal Yanaki South 19.95
19 1/30/2010 No Coupon PayPal Aspen East 21.95
20 10/9/2010 Coupon PayPal Carlota North 22.95
21 7/4/2010 No Coupon PayPal Delicate Arch South 29.95
22 11/8/2010 Coupon Visa Yanaki North 19.95
23 6/9/2010 Coupon PayPal Yanaki North 19.95
24 3/17/2010 Coupon MasterCard Yanaki South 19.95
25 4/7/2010 No Coupon Visa Aspen East 21.95
26 1/5/2010 No Coupon PayPal Sunset East 24.95
27 7/22/2010 No Coupon American Express Aspen West 21.95
28 11/12/2010 No Coupon American Express Yanaki West 19.95
29 5/11/2010 No Coupon Discover Carlota West 22.95
30 4/14/2010 No Coupon PayPal Aspen North 21.95
31 8/11/2010 No Coupon Discover Yanaki West 19.95
32 11/14/2010 No Coupon Visa Aspen West 21.95
33 1/21/2010 No Coupon PayPal Aspen West 21.95
34 4/12/2010 Coupon American Express Aspen West 21.95
35 6/4/2010 Coupon MasterCard Yanaki South 19.95
36 10/19/2010 Coupon Visa Delicate Arch West 29.95
37 9/7/2010 No Coupon PayPal Aspen West 21.95
38 9/19/2010 No Coupon PayPal Carlota West 22.95
39 1/17/2010 Coupon American Express Yanaki North 19.95
40 3/15/2010 Coupon PayPal Yanaki South 19.95
41 12/16/2010 No Coupon MasterCard Bellen North 24.95
42 7/8/2010 No Coupon PayPal Aspen West 21.95
43 5/13/2010 No Coupon MasterCard Sunset North 24.95
44 3/3/2010 Coupon Discover Delicate Arch West 29.95
45 4/30/2010 No Coupon PayPal Delicate Arch North 29.95
46 7/11/2010 Coupon PayPal Delicate Arch North 29.95
47 3/22/2010 Coupon Visa Carlota East 22.95
48 8/27/2010 No Coupon Visa Carlota West 22.95
49 11/16/2010 No Coupon MasterCard Carlota North 22.95
50 1/26/2010 Coupon Visa Yanaki West 19.95
51 5/6/2010 No Coupon MasterCard Aspen East 21.95
52 3/18/2010 Coupon MasterCard Yanaki North 19.95
53 4/16/2010 No Coupon Discover Aspen West 21.95
54 1/5/2010 No Coupon PayPal Carlota South 22.95
55 11/9/2010 No Coupon PayPal Aspen North 21.95
56 7/29/2010 No Coupon Visa Aspen North 21.95
57 12/7/2010 No Coupon Visa Carlota North 22.95
58 11/22/2010 Coupon American Express Bellen West 24.95
59 1/10/2010 No Coupon PayPal Aspen West 21.95
60 6/1/2010 No Coupon Visa Carlota East 22.95
61 5/2/2010 No Coupon American Express Carlota East 22.95
62 6/13/2010 Coupon Visa Delicate Arch West 29.95
63 2/16/2010 Coupon MasterCard Delicate Arch East 29.95
64 8/2/2010 No Coupon Visa Carlota West 22.95
65 11/1/2010 Coupon MasterCard Delicate Arch West 29.95
66 11/8/2010 No Coupon Visa Carlota West 22.95
67 8/17/2010 No Coupon PayPal Yanaki North 19.95
68 9/27/2010 No Coupon MasterCard Sunset East 24.95
69 1/9/2010 No Coupon Visa Yanaki North 19.95
70 10/10/2010 No Coupon MasterCard Sunset West 24.95
71 12/31/2010 No Coupon Discover Sunset East 24.95
72 12/6/2010 No Coupon PayPal Carlota East 22.95
73 3/18/2010 No Coupon American Express Bellen North 24.95
74 3/22/2010 No Coupon Visa Yanaki South 19.95
75 9/14/2010 Coupon Visa Aspen West 21.95
76 2/9/2010 No Coupon MasterCard Yanaki South 19.95
77 3/24/2010 No Coupon Discover Delicate Arch North 29.95
78 7/28/2010 Coupon MasterCard Yanaki North 19.95
79 8/26/2010 Coupon MasterCard Aspen South 21.95
80 3/5/2010 No Coupon American Express Carlota West 22.95
81 8/18/2010 No Coupon Visa Yanaki North 19.95
82 11/2/2010 Coupon MasterCard Yanaki South 19.95
83 12/19/2010 No Coupon Visa Carlota West 22.95
84 7/5/2010 Coupon Discover Carlota West 22.95
85 4/16/2010 No Coupon Visa Yanaki West 19.95
86 12/23/2010 No Coupon Visa Aspen North 21.95
87 5/29/2010 No Coupon PayPal Delicate Arch North 29.95
88 5/1/2010 Coupon PayPal Aspen West 21.95
89 7/3/2010 No Coupon American Express Yanaki West 19.95
90 8/12/2010 No Coupon MasterCard Delicate Arch West 29.95
91 6/21/2010 Coupon PayPal Yanaki West 19.95
92 12/15/2010 No Coupon MasterCard Yanaki South 19.95
93 5/25/2010 No Coupon PayPal Bellen East 24.95
94 3/23/2010 No Coupon PayPal Bellen West 24.95
95 1/22/2010 Coupon Visa Carlota West 22.95
96 9/26/2010 No Coupon MasterCard Aspen South 21.95
97 12/27/2010 No Coupon PayPal Carlota West 22.95
98 7/24/2010 No Coupon MasterCard Delicate Arch East 29.95
99 4/27/2010 No Coupon PayPal Yanaki West 19.95
100 5/7/2010 No Coupon Visa Yanaki West 19.95
101 3/3/2010 Coupon American Express Yanaki East 19.95
102 3/23/2010 No Coupon PayPal Carlota North 22.95
103 12/5/2010 Coupon Visa Aspen North 21.95
104 11/11/2010 Coupon PayPal Delicate Arch South 29.95
105 4/13/2010 No Coupon Discover Yanaki East 19.95
106 12/13/2010 No Coupon Visa Sunset North 24.95
107 10/5/2010 No Coupon Visa Bellen West 24.95
108 1/2/2010 No Coupon Visa Aspen West 21.95
109 11/4/2010 Coupon PayPal Yanaki East 19.95
110 4/29/2010 No Coupon PayPal Aspen West 21.95
111 10/2/2010 Coupon PayPal Yanaki East 19.95
112 12/26/2010 Coupon Discover Aspen West 21.95
113 11/5/2010 No Coupon Visa Sunset West 24.95
114 11/15/2010 No Coupon Visa Delicate Arch West 29.95
115 6/27/2010 Coupon PayPal Aspen South 21.95
116 4/21/2010 No Coupon Visa Delicate Arch West 29.95
117 9/25/2010 No Coupon American Express Delicate Arch West 29.95
118 1/24/2010 Coupon MasterCard Aspen North 21.95
119 1/4/2010 No Coupon Visa Carlota South 22.95
120 5/6/2010 Coupon American Express Bellen South 24.95
121 6/22/2010 No Coupon Visa Yanaki East 19.95
122 7/12/2010 No Coupon Discover Aspen North 21.95
123 5/3/2010 No Coupon Visa Sunset North 24.95
124 3/9/2010 Coupon PayPal Aspen West 21.95
125 3/2/2010 No Coupon Visa Yanaki North 19.95
126 3/28/2010 No Coupon Discover Aspen South 21.95
127 1/15/2010 No Coupon Visa Bellen West 24.95
128 11/18/2010 No Coupon MasterCard Yanaki West 19.95
129 3/27/2010 No Coupon Visa Bellen West 24.95
130 8/11/2010 Coupon PayPal Carlota West 22.95
131 12/24/2010 No Coupon Visa Yanaki North 19.95
132 11/27/2010 No Coupon PayPal Aspen West 21.95
133 3/12/2010 No Coupon Visa Bellen West 24.95
134 9/16/2010 Coupon Visa Sunset West 24.95
135 2/1/2010 No Coupon MasterCard Bellen West 24.95
136 7/3/2010 No Coupon Visa Sunset North 24.95
137 8/30/2010 No Coupon PayPal Yanaki East 19.95
138 9/18/2010 Coupon MasterCard Yanaki South 19.95
139 11/24/2010 No Coupon Visa Carlota West 22.95
140 12/22/2010 No Coupon Visa Delicate Arch West 29.95
141 4/23/2010 No Coupon PayPal Carlota South 22.95
142 11/18/2010 Coupon Discover Aspen West 21.95
143 10/28/2010 No Coupon Visa Bellen South 24.95
144 8/14/2010 No Coupon PayPal Delicate Arch West 29.95
145 5/5/2010 No Coupon Visa Bellen North 24.95
146 8/25/2010 Coupon Visa Carlota North 22.95
147 10/25/2010 No Coupon PayPal Yanaki North 19.95
148 7/31/2010 No Coupon PayPal Yanaki East 19.95
149 7/25/2010 Coupon MasterCard Carlota West 22.95
150 9/30/2010 Coupon Visa Bellen North 24.95
151 10/3/2010 No Coupon Discover Aspen East 21.95
152 4/1/2010 No Coupon MasterCard Carlota North 22.95
153 12/15/2010 No Coupon American Express Carlota East 22.95
154 1/7/2010 No Coupon PayPal Carlota West 22.95
155 7/23/2010 Coupon PayPal Bellen West 24.95
156 3/16/2010 No Coupon PayPal Yanaki East 19.95
157 12/4/2010 No Coupon American Express Delicate Arch East 29.95
158 1/8/2010 Coupon MasterCard Aspen West 21.95
159 6/2/2010 Coupon PayPal Bellen West 24.95
160 8/18/2010 No Coupon Discover Sunset West 24.95
161 4/24/2010 No Coupon MasterCard Yanaki West 19.95
162 12/1/2010 No Coupon Visa Yanaki North 19.95
163 12/31/2010 Coupon Visa Carlota North 22.95
164 4/30/2010 Coupon PayPal Carlota North 22.95
165 3/16/2010 Coupon American Express Aspen West 21.95
166 1/28/2010 No Coupon MasterCard Yanaki West 19.95
167 8/3/2010 No Coupon MasterCard Carlota North 22.95
168 11/11/2010 No Coupon Visa Yanaki West 19.95
169 12/13/2010 Coupon Visa Aspen South 21.95
170 3/27/2010 No Coupon PayPal Carlota North 22.95
171 10/8/2010 Coupon PayPal Bellen North 24.95
172 8/3/2010 No Coupon Visa Carlota North 22.95
173 3/10/2010 Coupon Visa Carlota West 22.95
174 3/2/2010 No Coupon Visa Carlota East 22.95
175 1/26/2010 No Coupon Visa Carlota West 22.95
176 5/6/2010 No Coupon American Express Delicate Arch West 29.95
177 3/10/2010 Coupon Visa Yanaki West 19.95
178 11/18/2010 Coupon PayPal Aspen North 21.95
179 1/30/2010 Coupon Discover Yanaki West 19.95
180 7/2/2010 No Coupon Visa Delicate Arch West 29.95
181 10/13/2010 Coupon Discover Yanaki East 19.95
182 2/7/2010 No Coupon Discover Bellen North 24.95
183 6/5/2010 No Coupon MasterCard Aspen West 21.95
184 11/2/2010 No Coupon Visa Sunset North 24.95
185 12/13/2010 No Coupon Visa Aspen East 21.95
186 10/23/2010 No Coupon Visa Carlota West 22.95
187 12/22/2010 Coupon PayPal Yanaki South 19.95
188 8/21/2010 Coupon PayPal Yanaki North 19.95
189 8/28/2010 Coupon PayPal Yanaki North 19.95
190 6/20/2010 No Coupon American Express Bellen North 24.95
191 4/30/2010 Coupon MasterCard Bellen East 24.95
192 10/14/2010 No Coupon MasterCard Carlota North 22.95
193 8/4/2010 No Coupon Visa Yanaki West 19.95
194 10/28/2010 Coupon PayPal Aspen West 21.95
195 11/4/2010 No Coupon American Express Sunset West 24.95
196 1/5/2010 No Coupon PayPal Yanaki North 19.95
197 12/11/2010 Coupon Visa Carlota West 22.95
198 7/18/2010 No Coupon PayPal Aspen West 21.95
199 5/31/2010 No Coupon Visa Yanaki West 19.95
200 12/16/2010 Coupon PayPal Aspen West 21.95
Units Sales
2 45.9
1 19.95
1 21.95
1 19.95 Generate a pivot table and display the following
4 79.8 1. Sales in the North via PayPal with Coupon
4 79.8 2. Sales of Aspen in the first half of 2010
3 59.85
7 139.65
6 119.7
2 43.9
2 43.9
5 99.75
5 114.75
4 91.8
5 114.75
1 22.95
5 124.75
1 19.95
4 87.8
1 22.95
10 299.5
1 19.95
5 99.75
2 39.9
3 65.85
1 24.95
1 21.95
1 19.95
4 91.8
3 65.85
2 39.9
2 43.9
3 65.85
2 43.9
5 99.75
1 29.95
3 65.85
1 22.95
1 19.95
5 99.75
5 124.75
1 21.95
7 174.65
1 29.95
5 149.75
1 29.95
2 45.9
7 160.65
7 160.65
6 119.7
2 43.9
6 119.7
3 65.85
1 22.95
3 65.85
5 109.75
5 114.75
10 249.5
5 109.75
5 114.75
5 114.75
4 119.8
1 29.95
5 114.75
7 209.65
5 114.75
3 59.85
5 124.75
2 39.9
5 124.75
1 24.95
1 22.95
10 249.5
3 59.85
2 43.9
1 19.95
1 29.95
1 19.95
3 65.85
1 22.95
4 79.8
4 79.8
5 114.75
1 22.95
1 19.95
5 109.75
2 59.9
2 43.9
2 39.9
7 209.65
1 19.95
4 79.8
5 124.75
1 24.95
7 160.65
3 65.85
6 137.7
1 29.95
6 119.7
1 19.95
2 39.9
5 114.75
1 21.95
6 179.7
2 39.9
1 24.95
4 99.8
4 87.8
2 39.9
3 65.85
10 199.5
1 21.95
5 124.75
1 29.95
1 21.95
4 119.8
3 89.85
3 65.85
4 91.8
6 149.7
3 59.85
6 131.7
2 49.9
2 43.9
1 19.95
1 21.95
1 24.95
2 39.9
1 24.95
5 114.75
6 119.7
2 43.9
1 24.95
7 174.65
1 24.95
2 49.9
1 19.95
2 39.9
2 45.9
6 179.7
7 160.65
1 21.95
5 124.75
3 89.85
2 49.9
1 22.95
1 19.95
5 99.75
4 91.8
2 49.9
1 21.95
2 45.9
1 22.95
2 45.9
1 24.95
2 39.9
6 179.7
1 21.95
1 24.95
3 74.85
4 79.8
1 19.95
1 22.95
2 45.9
3 65.85
7 139.65
1 22.95
2 39.9
5 109.75
7 160.65
2 49.9
1 22.95
2 45.9
3 68.85
10 229.5
1 29.95
2 39.9
2 43.9
1 19.95
2 59.9
5 99.75
7 174.65
3 65.85
5 124.75
4 87.8
10 229.5
5 99.75
1 19.95
1 19.95
4 99.8
1 24.95
5 114.75
3 59.85
2 43.9
3 74.85
1 19.95
1 22.95
7 153.65
2 39.9
6 131.7
Month Chocolate Strawberry Vanilla
Jan 544 639 189
Feb 217 719 679
Mar 810 178 810
Apr 567 926 929 Insert formula in H7 to autogenerate based on selected month a
May 745 230 364 Sales Chocolate
Jun 298 820 947 Jul
Jul 457 522 832
Aug 495 500 239
Sep 871 391 529
Oct 585 225 791
Nov 478 262 540
Dec 741 883 809
erate based on selected month and item from dropdown of H6 and G7