Excel's Pivottable Raport provides an excellent way to summarize data for two or more variables simultaneously. The goal of this beaded muralista familiare you with cu Protable about the data. The data for this problem is located on the Datasheet incolumns A through of the Excel Online below. Any Profile is provided on the other on the pret tab to select the potable sheet. Inside the potable area right-click and select Show Field Ust. The Portable task one should now be displayed on the right side of the sordhest. In the field ist you should see Restaurant, Radio, Quality Rating and Meal Price (5) Construct a shot to answer the following is Open spreadsheet Question 1. What are the sales totals for each region to this question proceed as follows. First, dick on Region in the field tist and then dag to the whole the four regions enter the Pivottable et des Price (5) into the values box of the Pettate pane The second column in the Phot ble should be forward tutal sales for each region and the Grand Total Total Sales East 5 North $ Seath + west 1 Grand Tu 2. What the actuals for each Quy Rating the ones First did the the battery Rating from the rest in the box of the pan. What are the TS cent 0000 Very Good 2. What is the sales total for a particular combination of Region and Quality Rating? Forecample, what is the sales total for Excellent restaurants in the Westerisestion, Mered follows, Drag Quality rating from the tow box to the column box in the Pivot Table pane. Then drag Region from the Field Listinto the rows box. The intersection of West and Excellent in the Platable provides the answer. Total sales for Excellent meals in the West Region Total sales for Excellent restaurants in the West are 4. What is the average meal price for the entire East region and Very Good meats in the East region to the nearest cant) to answer the questo proceed as follows Select a mercat Divottables it appears from Question above. Next, go to the values bok in the Pivottable pane and click on Sum of Meal prices and select Value Field Settings. The Suttiset Average. Then do in the values box. It should now read average of Meal Price (5) A meat price in the East Region is to the newest cont. Ag meal price for Very Good meals in the East wortis to the newest E G H Question 1 Total Sales East North South West Grand Total Question 2 Total Sales 1 Restaurant 2 3 4 5 6 7 8 9 10 10 12 13 14 15 16 17 18 19 20 21 22 23 Excellent Good Very Good Region 1 East 2 North 3 East 4 East 5 North 6 East 7 North 8 South 9 West 10 East 11 West 12 South 13 South 14 South 15 East 16 North 17 East 18 North 19 East 20 West 21 South 22 East 23 West 24 West 25 East 26 East 27 South 28 South 29 West 30 East 31 East 32 West Question 3 Quality Rating Excellent Good Good Good Excellent Good Good Excellent Very Good Good Good Good Excellent Good Good Excellent Good Good Excellent Excellent Good Excellent Excellent Very Good Good Good Good Very Good Very Good Very Good Very Good Excellent Meal Price (5) 28 37 55 14 46 23 15 18 19 25 29 13 10 10 10 13 51 36 30 23 12 17 22 10 20 26 40 47 50 Total Sales (Excellent, West) Question 4 Average Meal Price (East) Average Meal Price (Very Good East) 30 31 32 33 31 22 Restaurant 28 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 Region Quality Rating Meal Price (5) 33 East Good 54 34 North Very Good 46 35 North Good 20 36 West Good 54 37 North Very Good 38 North Very Good 44 39 South Very Good 21 40 East Excellent 55 41 East Excellent 14 42 West Very Good 23 43 East Excellent 15 44 North Excellent 44 45 West Excellent 49 46 South Very Good 43 47 East Very Good 16 48 West Good 22 49 South Very Good 16 50 East Very Good 31 51 West Very Good 35 52 West Very Good 45 53 North Very Good 38 54 North Good 34 55 South Excellent 18 56 South Very Good 55 57 East Good 39 58 South Excellent 24 59 South Excellent 51 60 West Excellent 51 61 South VeryGood 39 62 South Excellent 39 63 West Very Good 43 64 South Excellent 48 65 South Excellent 13 66 West Good 19 67 East Good 51 68 East Excellent 55 69 East Very Good 22 70 West Good 53 71 South Excellent 43 72 North Good 26 73 South Excellent 14 48 25 23 49 36 55 25 27 48 48 21 51 53 51 11 24 26 55 38 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 74 East 75 North 76 South 77 North 78 North 79 West 80 East 81 East 82 North 83 South 84 West 85 East 86 East 87 West 88 East 89 East 90 West 91 North 92 East 93 South 94 West 95 West 96 West 97 West 98 South 99 South 100 West 101 West 102 North 103 West 104 West 105 South 106 West 107 South 108 West 109 South 110 East 111 West 112 East 113 North 114 South Very Good Good Good Very Good Very Good Excellent Excellent Good Good Good Excellent Excellent Very Good Good Very Good Excellent Excellent Very Good Very Good Good Good Very Good Good Excellent Very Good Very Good Excellent Good Very Good Excellent Very Good Good Good Very Good Very Good Very Good Excellent Excellent Excellent Excellent Good 27 18 16 46 19 45 33 11 19 32 25 29 21 37 10 41 32 44 30 26 35 122 Restaurant Region Quality Rating 116 115 South Excellent 117 116 South Very Good 118 117 East Very Good 119 118 South Excellent 120 119 West Excellent 121 120 East Excellent 121 East Very Good 123 122 North Very Good 124 123 North Good 125 124 South Excellent 126 125 East Good 127 126 North Excellent 128 127 East Good 129 128 East Excellent 130 129 East Very Good 131 130 North Good 132 131 South Excellent 133 132 West Very Good 134 133 South Excellent 135 134 North Excellent 136 135 South Good 137 136 East Very Good 138 137 North Excellent 139 138 East Good 140 139 North Good 141 140 East Good 142 141 South Good 145 142 South Very Good 144 143 West Good 145 144 North Excellent 146 145 East Very Good 147 146 East Very Good 148 147 West Excellent 149 148 East Very Good 150 149 West Very Good 151 150 North Very Good 152 151 West Good 153 152 South Excellent 154 153 East Excellent 155 154 West Good 156 155 North Good Meal Price (5) 21 38 39 12 24 12 52 15 10 46 39 19 25 18 44 10 10 13 20 17 21 28 51 31 28 30 52 28 44 42 34 41 26 34 36 53 33 42 28 26 14 Restaurant Region Quality Rating Meal Price (5) 157 156 East Excellent 44 158 157 West Very Good 22 159 158 South Very Good 35 160 159 South Good 25 161 160 East Good 53 162 161 North Good 40 163 162 East Good 26 164 163 West Excellent 10 165 164 North VeryGood 12 166 165 East Excellent 26 167 166 North Very Good 21 168 167 South Very Good 19 169 168 East Excellent 20 170 169 South Excellent 29 171 170 East Very Good 28 172 171 East Excellent 36 173 172 South Excellent 47 174 173 West Excellent 35 175 174 West Excellent 17 176 175 North Excellent 177 176 North Very Good 19 178 177 South Very Good 31 179 178 West VeryGood 44 180 179 West Excellent 18 181 180 South Very Good 14 182 181 West Excellent 44 183 182 North Good 46 184 183 East Good 36 185 184 South Very Good 31 186 185 West Good 20 187 186 North Good 34 1188 187 North Good 51 189 188 West Excellent 30 190 189 South Very Good 32 191 190 South Very Good 20 192 191 East Good 37 193 192 North Good 47 194 193 West Good 195 55 194 West Very Good 31 196 195 West Good 197 24 196 South Excellent 28 26 Restaurant Region Quality Rating Meal Price (5) 198 197 North Excellent 19 199 198 South Excellent 14 200 199 West Excellent 46 201 200 East Excellent 15 202 201 West Good 44 203 202 East Excellent 19 204 203 South VeryGood 48 205 204 South Excellent 27 206 205 West Very Good 43 207 206 North Good 34 208 207 North Good 13 209 208 West Excellent 21 210 209 South Excellent 12 211 210 West Excellent 47 212 211 North Excellent 37 213 212 South Excellent 32 214 213 East Very Good 11 215 214 North Excellent 42 216 215 North Good 54 217 216 West Excellent 25 218 217 West Excellent 17 219 218 North Very Good 16 220 219 North Good 12 221 220 East Excellent 39 222 221 West Good 18 223 222 North Very Good 28 224 223 North Very Good 29 225 224 West Good 19 226 225 East Excellent 46 227 226 North Very Good 48 228 227 East Very Good 33 229 228 East Good 42 230 229 North Good 28 231 230 West Very Good 30 232 231 West Very Good 27 233 232 East Excellent 47 234 233 West Very Good 235 234 South Excellent 33 236 235 West Good 41 237 236 South Very Good 17 238 237 West Excellent 23 54 33 37 Restaurant | Region Quality Rating Meal Price (5) G 239 238 East Very Good 48 240 239 East Good 11 241 240 South Very Good 38 242 241 West Very Good 52 243 242 North Excellent 13 244 243 West Excellent 16 245 244 North Excellent 34 246 245 West Very Good 37 247 246 North Excellent 248 247 North Good 21 249 248 North Excellent 27 250 249 South Very Good 24 251 250 North Excellent 46 252 251 West Excellent 253 252 West Good 19 254 253 East Very Good 48 255 254 East Very Good 14 256 255 East Good 11 257 256 West Very Good 34 258 257 West Good 27 259 258 South Very Good 27 260 259 West Excellent 26 261 260 North Good 20 262 261 West Good 37 263 262 East Good 37 264 263 North Very Good 13 265 264 North Good 53 266 265 East Good 55 267 266 West Excellent 39 268 267 North Good 33 269 268 West Very Good 31 270 269 South Good 46 271 270 West Good 28 272 271 North Very Good 24 273 272 East Very Good 38 274 273 West Very Good 16 275 274 North Good 22 276 275 West Excellent 10 277 276 East Good 42 278 277 West Excellent 40 279 278 East Very Good 23 Restaurant Region 280 279 North 281 280 South 282 281 East 2083 282 South 284 283 West 285 284 South 286 285 South 287 286 West 288 287 South 289 288 West 290 289 South 291 290 West 292 291 North 293 292 East 294 293 South 295 294 South 296 295 South 297 296 North 298 297 East 1299 298 East 300 299 West B01 300 South Quality Rating Meal Price (5) Excellent 54 Good 52 Very Good 55 Excellent 35 Good 49 Very Good 33 Excellent 39 Excellent 21 Good 26 Excellent 19 Good 46 Excellent 26 Excellent 15 Excellent 30 Excellent 11 Good 38 Good 48 Very Good 38 Good 30 Excellent 43 Good 30 Excellent 45 Excel's Pivottable Raport provides an excellent way to summarize data for two or more variables simultaneously. The goal of this beaded muralista familiare you with cu Protable about the data. The data for this problem is located on the Datasheet incolumns A through of the Excel Online below. Any Profile is provided on the other on the pret tab to select the potable sheet. Inside the potable area right-click and select Show Field Ust. The Portable task one should now be displayed on the right side of the sordhest. In the field ist you should see Restaurant, Radio, Quality Rating and Meal Price (5) Construct a shot to answer the following is Open spreadsheet Question 1. What are the sales totals for each region to this question proceed as follows. First, dick on Region in the field tist and then dag to the whole the four regions enter the Pivottable et des Price (5) into the values box of the Pettate pane The second column in the Phot ble should be forward tutal sales for each region and the Grand Total Total Sales East 5 North $ Seath + west 1 Grand Tu 2. What the actuals for each Quy Rating the ones First did the the battery Rating from the rest in the box of the pan. What are the TS cent 0000 Very Good 2. What is the sales total for a particular combination of Region and Quality Rating? Forecample, what is the sales total for Excellent restaurants in the Westerisestion, Mered follows, Drag Quality rating from the tow box to the column box in the Pivot Table pane. Then drag Region from the Field Listinto the rows box. The intersection of West and Excellent in the Platable provides the answer. Total sales for Excellent meals in the West Region Total sales for Excellent restaurants in the West are 4. What is the average meal price for the entire East region and Very Good meats in the East region to the nearest cant) to answer the questo proceed as follows Select a mercat Divottables it appears from Question above. Next, go to the values bok in the Pivottable pane and click on Sum of Meal prices and select Value Field Settings. The Suttiset Average. Then do in the values box. It should now read average of Meal Price (5) A meat price in the East Region is to the newest cont. Ag meal price for Very Good meals in the East wortis to the newest E G H Question 1 Total Sales East North South West Grand Total Question 2 Total Sales 1 Restaurant 2 3 4 5 6 7 8 9 10 10 12 13 14 15 16 17 18 19 20 21 22 23 Excellent Good Very Good Region 1 East 2 North 3 East 4 East 5 North 6 East 7 North 8 South 9 West 10 East 11 West 12 South 13 South 14 South 15 East 16 North 17 East 18 North 19 East 20 West 21 South 22 East 23 West 24 West 25 East 26 East 27 South 28 South 29 West 30 East 31 East 32 West Question 3 Quality Rating Excellent Good Good Good Excellent Good Good Excellent Very Good Good Good Good Excellent Good Good Excellent Good Good Excellent Excellent Good Excellent Excellent Very Good Good Good Good Very Good Very Good Very Good Very Good Excellent Meal Price (5) 28 37 55 14 46 23 15 18 19 25 29 13 10 10 10 13 51 36 30 23 12 17 22 10 20 26 40 47 50 Total Sales (Excellent, West) Question 4 Average Meal Price (East) Average Meal Price (Very Good East) 30 31 32 33 31 22 Restaurant 28 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 Region Quality Rating Meal Price (5) 33 East Good 54 34 North Very Good 46 35 North Good 20 36 West Good 54 37 North Very Good 38 North Very Good 44 39 South Very Good 21 40 East Excellent 55 41 East Excellent 14 42 West Very Good 23 43 East Excellent 15 44 North Excellent 44 45 West Excellent 49 46 South Very Good 43 47 East Very Good 16 48 West Good 22 49 South Very Good 16 50 East Very Good 31 51 West Very Good 35 52 West Very Good 45 53 North Very Good 38 54 North Good 34 55 South Excellent 18 56 South Very Good 55 57 East Good 39 58 South Excellent 24 59 South Excellent 51 60 West Excellent 51 61 South VeryGood 39 62 South Excellent 39 63 West Very Good 43 64 South Excellent 48 65 South Excellent 13 66 West Good 19 67 East Good 51 68 East Excellent 55 69 East Very Good 22 70 West Good 53 71 South Excellent 43 72 North Good 26 73 South Excellent 14 48 25 23 49 36 55 25 27 48 48 21 51 53 51 11 24 26 55 38 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 74 East 75 North 76 South 77 North 78 North 79 West 80 East 81 East 82 North 83 South 84 West 85 East 86 East 87 West 88 East 89 East 90 West 91 North 92 East 93 South 94 West 95 West 96 West 97 West 98 South 99 South 100 West 101 West 102 North 103 West 104 West 105 South 106 West 107 South 108 West 109 South 110 East 111 West 112 East 113 North 114 South Very Good Good Good Very Good Very Good Excellent Excellent Good Good Good Excellent Excellent Very Good Good Very Good Excellent Excellent Very Good Very Good Good Good Very Good Good Excellent Very Good Very Good Excellent Good Very Good Excellent Very Good Good Good Very Good Very Good Very Good Excellent Excellent Excellent Excellent Good 27 18 16 46 19 45 33 11 19 32 25 29 21 37 10 41 32 44 30 26 35 122 Restaurant Region Quality Rating 116 115 South Excellent 117 116 South Very Good 118 117 East Very Good 119 118 South Excellent 120 119 West Excellent 121 120 East Excellent 121 East Very Good 123 122 North Very Good 124 123 North Good 125 124 South Excellent 126 125 East Good 127 126 North Excellent 128 127 East Good 129 128 East Excellent 130 129 East Very Good 131 130 North Good 132 131 South Excellent 133 132 West Very Good 134 133 South Excellent 135 134 North Excellent 136 135 South Good 137 136 East Very Good 138 137 North Excellent 139 138 East Good 140 139 North Good 141 140 East Good 142 141 South Good 145 142 South Very Good 144 143 West Good 145 144 North Excellent 146 145 East Very Good 147 146 East Very Good 148 147 West Excellent 149 148 East Very Good 150 149 West Very Good 151 150 North Very Good 152 151 West Good 153 152 South Excellent 154 153 East Excellent 155 154 West Good 156 155 North Good Meal Price (5) 21 38 39 12 24 12 52 15 10 46 39 19 25 18 44 10 10 13 20 17 21 28 51 31 28 30 52 28 44 42 34 41 26 34 36 53 33 42 28 26 14 Restaurant Region Quality Rating Meal Price (5) 157 156 East Excellent 44 158 157 West Very Good 22 159 158 South Very Good 35 160 159 South Good 25 161 160 East Good 53 162 161 North Good 40 163 162 East Good 26 164 163 West Excellent 10 165 164 North VeryGood 12 166 165 East Excellent 26 167 166 North Very Good 21 168 167 South Very Good 19 169 168 East Excellent 20 170 169 South Excellent 29 171 170 East Very Good 28 172 171 East Excellent 36 173 172 South Excellent 47 174 173 West Excellent 35 175 174 West Excellent 17 176 175 North Excellent 177 176 North Very Good 19 178 177 South Very Good 31 179 178 West VeryGood 44 180 179 West Excellent 18 181 180 South Very Good 14 182 181 West Excellent 44 183 182 North Good 46 184 183 East Good 36 185 184 South Very Good 31 186 185 West Good 20 187 186 North Good 34 1188 187 North Good 51 189 188 West Excellent 30 190 189 South Very Good 32 191 190 South Very Good 20 192 191 East Good 37 193 192 North Good 47 194 193 West Good 195 55 194 West Very Good 31 196 195 West Good 197 24 196 South Excellent 28 26 Restaurant Region Quality Rating Meal Price (5) 198 197 North Excellent 19 199 198 South Excellent 14 200 199 West Excellent 46 201 200 East Excellent 15 202 201 West Good 44 203 202 East Excellent 19 204 203 South VeryGood 48 205 204 South Excellent 27 206 205 West Very Good 43 207 206 North Good 34 208 207 North Good 13 209 208 West Excellent 21 210 209 South Excellent 12 211 210 West Excellent 47 212 211 North Excellent 37 213 212 South Excellent 32 214 213 East Very Good 11 215 214 North Excellent 42 216 215 North Good 54 217 216 West Excellent 25 218 217 West Excellent 17 219 218 North Very Good 16 220 219 North Good 12 221 220 East Excellent 39 222 221 West Good 18 223 222 North Very Good 28 224 223 North Very Good 29 225 224 West Good 19 226 225 East Excellent 46 227 226 North Very Good 48 228 227 East Very Good 33 229 228 East Good 42 230 229 North Good 28 231 230 West Very Good 30 232 231 West Very Good 27 233 232 East Excellent 47 234 233 West Very Good 235 234 South Excellent 33 236 235 West Good 41 237 236 South Very Good 17 238 237 West Excellent 23 54 33 37 Restaurant | Region Quality Rating Meal Price (5) G 239 238 East Very Good 48 240 239 East Good 11 241 240 South Very Good 38 242 241 West Very Good 52 243 242 North Excellent 13 244 243 West Excellent 16 245 244 North Excellent 34 246 245 West Very Good 37 247 246 North Excellent 248 247 North Good 21 249 248 North Excellent 27 250 249 South Very Good 24 251 250 North Excellent 46 252 251 West Excellent 253 252 West Good 19 254 253 East Very Good 48 255 254 East Very Good 14 256 255 East Good 11 257 256 West Very Good 34 258 257 West Good 27 259 258 South Very Good 27 260 259 West Excellent 26 261 260 North Good 20 262 261 West Good 37 263 262 East Good 37 264 263 North Very Good 13 265 264 North Good 53 266 265 East Good 55 267 266 West Excellent 39 268 267 North Good 33 269 268 West Very Good 31 270 269 South Good 46 271 270 West Good 28 272 271 North Very Good 24 273 272 East Very Good 38 274 273 West Very Good 16 275 274 North Good 22 276 275 West Excellent 10 277 276 East Good 42 278 277 West Excellent 40 279 278 East Very Good 23 Restaurant Region 280 279 North 281 280 South 282 281 East 2083 282 South 284 283 West 285 284 South 286 285 South 287 286 West 288 287 South 289 288 West 290 289 South 291 290 West 292 291 North 293 292 East 294 293 South 295 294 South 296 295 South 297 296 North 298 297 East 1299 298 East 300 299 West B01 300 South Quality Rating Meal Price (5) Excellent 54 Good 52 Very Good 55 Excellent 35 Good 49 Very Good 33 Excellent 39 Excellent 21 Good 26 Excellent 19 Good 46 Excellent 26 Excellent 15 Excellent 30 Excellent 11 Good 38 Good 48 Very Good 38 Good 30 Excellent 43 Good 30 Excellent 45
