Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I will give thumbs up RIGHT away. atorial 1 - Pivot Tables Questions 1. What are the sales totals for each region? To answer this

I will give thumbs up RIGHT away. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
atorial 1 - Pivot Tables Questions 1. What are the sales totals for each region? To answer this question, proceed as follows. First, click on Region in the Field List and then drag it to the rows box in the Pivot Table pane. You will see the four regions enter the Pivottable. Next, drag Meal Price ($) into the values box of the Pivottable pane. The second column in the Pivot Table should now be Sum of Meal Price ($). What are the total sales for each Region and the Grand Total? Total Sales East $ North $ South $ West $ Grand Total $ 2. What are the sales totals for each Quality Rating? To answer this question, proceed as follows. First, click on Region in the rows box of the Pivot Table (where it was used to answer Question 1) and then drag it back into the Field List. Next, drag Quality Rating from the Field List into the rows box of the Pivot Table pane. What are the total sales for each Quality Rating? Total Sales Excellent $ Good $ Very Good $ 3. What is the sales total for a particular combination of Region and Quality Rating? For example, what is the sales total for Excellent restaurants in the West? To answer this question, proceed as follows. Drag Quality rating from the rows box to the column box in the Pivot Table pane. Then drag Region from the Field List into the rows box. The intersection of West and Excellent in the Pivot Table 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 meals in the East region to the nearest cent? To answer this question, proceed as follows. Select all numeric values in the Pivot Table as is appears from Question 3 above. Next, go to the Values box in the Pivot Table pane and click on Sum of Meal Prices and select Value Field Settings. In Value Field Settings select Average. Then click OK. In the Values box, it should now read Average of Meal Price ($). Ne med at 10:44 AM North $ South $ West $ Grand Total $ 2. What are the sales totals for each Quality Rating? To answer this question, proceed as follows. First, click on Region in the rows box of the PlvatTable (where it was used to answer Question 1) and then drag it back into the Field List. Next, drag Quality Rating from the Field List into the rows box of the Pivot Table pane. What are the total sales for each Quality Rating? Total Sales Excellent $ Good $ Very Good $ 3. What is the sales total for a particular combination of Region and Quality Rating? For example, what is the sales total for Excellent restaurants in the West? To answer this question, proceed as follows. Drag Quality rating from the rows box to the column box in the PivotTable pane. Then drag Region from the Field List into the rows box. The intersection of West and Excellent in the Pivot Table 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 meals in the East region to the nearest cent? To answer this question, proceed as follows. Select all numeric values in the Pivot Table as is appears from Question 3 above. Next, go to the Values box in the Pivottable pane and click on Sum of Meal Prices and select Value Field Settings. In Value Field Settings select Average. Then click OK. In the Values box, it should now read Average of Meal Price ($). Average meal price in the East Region is $ (to the nearest cent). Average meal price for Very Good meals in the East Region is $ (to the nearest cent). Check My Work Reset Problem Autosaved at 10:44 AM 1 South 2 West 3 East 4 East 5 South 6 East 7 West 8 West 9 West 10 East 11 South 12 North 13 South 14 South 15 East 16 West 17 East 18 South 19 South 20 West 21 North 22 South 23 East 24 West 25 West 26 North 27 North 28 West 29 East 30 North 31 East 32 East 33 West 34 East 35 West 36 North 37 South 38 South 39 West 40 West 41 South 42 West 43 East Excellent YecxGood Good Good Excellent Very Good Good Excellent Excellent VeryGood Excellent Excellent Good Excellent Very Good Very Good Excellent Very Good Very Good Good Good Good Excellent Good Good Very Good Good Very Good Excellent Good Good Excellent Good Good Very Good Good Good Good Very Good VocGood Excellent Good Good 45 54 51 35 46 46 18 49 24 22 36 34 53 34 23 11 28 39 19 20 41 37 14 32 27 43 54 48 50 33 25 10 26 40 30 46 26 18 15 49 52 34 47 and improvements, choose Check for Updates. 44 East 45 South 46 West 47 East 48 East 49 South 50 West 51 West 52 South 53 East 54 North 55 East 56 West 57 West 58 West 59 South 60 South 61 West 62 North 63 North 64 East 65 East 66 East 67 South 68 South 69 South 70 East 71 South 72 West 73 South 74 North 75 West 76 South 77 North 78 North 79 North 80 North 81 South 82 South 83 North 84 West 85 South 86 East Excellent Excellent Very Good Very Good Excellent Excellent Excellent Very Good Very Good Good Good Good Good Good Very Good Excellent Good Good Very Good Good Good YecxGood. Very Good VecxGood Good YecxGood Good Good Good Good Very Good Excellent Excellent Very Good Very Good Excellent VeryGond Good Very Good Good Excellent Good Very Good 37 26 40 36 25 38 37 55 52 10 28 15 39 32 24 31 16 51 19 18 27 44 45 48 31 46 12 18 38 16 20 25 28 31 23 30 34 30 39 12 29 18 87 East 88 North 89 North 90 West 91 East 92 West 93 East 94 West 95 West 96 East 97 South 98 West 99 South 100 East 101 North 102 North 103 West 104 West 105 East 106 East 107 West 108 East 109 North 110 West 111 North 112 North 113 North 114 South 115 North 116 East 117 North 118 South 119 East 120 South 121 North 122 South 123 West 124 West 125 South 126 West 127 North 128 South 129 South Excellent Excellent Excellent Excellent Very Good Very Good Excellent Very Good Very Good Excellent Very Good VeryGood Very Good Good Very Good VeryGood Excellent Good Good Good Very Good Good Excellent Very Good Vergoed VeryGood Good Excellent Excellent Good Excellent Good Very Good Good Very Good Good Good Vecy Good Good Excellent Very Gond Good Good 55 22 41 12 47 47 18 47 44 42 27 54 45 13 19 29 19 45 26 52 44 19 19 48 20 43 55 13 43 50 32 38 49 47 28 23 29 18 42 13 40 17 47 es, and improvements, choose Check for Updates. 130 South 131 North 132 North 133 South 134 North 135 West 136 West 137 East 138 South 139 South 140 North 141 West 142 West 143 South 144 East 145 South 146 South 147 East 148 East 149 North 150 North 151 South 152 West 153 South 154 North 155 North 156 North 157 South 158 South 159 East 160 East 161 North 162 West 163 West 164 North 165 East 166 South 167 South 168 West 169 West 170 North 171 East 172 East Excellent YecxGood Very Good Excellent VecxGood Excellent Good Very Good Excellent Good Very Good Excellent VeryGood Very Good Good Good Good Very Good Excellent Good Excellent VecxGood Very Good Good Very Good YecxGond. Excellent Good Excellent Good Good Good Good Good Excellent Good Good Excellent Excellent Excellent Excellent Excellent Excellent 15 36 36 39 22 31 16 49 13 38 17 13 29 13 29 45 16 28 22 36 49 44 23 30 43 37 30 12 16 24 47 25 13 48 44 39 16 49 55 49 44 44 173 West 174 North 175 East 176 North 177 South 178 North 179 North 180 West 181 North 182 West 183 West 184 North 185 South 186 North 187 North 188 West 189 East 190 East 191 West 192 South 193 East 194 West 195 East 196 South 197 West 198 East 199 South 200 West 201 East 202 North 203 East 204 East 205 North 206 North 207 East 208 West 209 East 210 South 211 West 212 North 213 West 214 West 215 West Excellent Good Good Excellent Excellent Excellent Excellent Good YecxGond. Very Good Excellent Good VecxGood Excellent Very Good Good Excellent Excellent Excellent Very Good Very Good Excellent Excellent Excellent Very Good Very Good Good Excellent Excellent Good Very Good Excellent VecxGond VecxGood Excellent Good Excellent Very Good Very Good Good Vergoed Excellent Very Good 23 22 36 51 10 39 23 47 19 33 47 34 27 34 39 46 23 49 45 36 52 25 20 35 47 11 31 33 23 24 40 52 10 31 54 25 28 26 14 31 36 49 32 and improvements, choose Check for Update 216 South 217 West 218 East 219 South 220 South 221 South 222 East 223 South 224 East 225 North 226 West 227 East 228 West 229 North 230 North 231 West 232 East 233 West 234 East 235 West 236 North 237 West 238 South 239 East 240 North 241 South 242 West 243. East 244 East 245 West 246 East 247 East 248 West 249 North 250 South 251 East 252 East 253 South 254 East 255 West 256 South 257 South 258 East Good SecGood. Excellent Excellent VeryGood YecxGood Good Excellent Very Good VecxGood Excellent Very Good Excellent Excellent Excellent Very Good Very Good Good Good Excellent Good YecxGood Good Good Excellent Good Very Good Very Good Good Yacx Gond Good Good YecxGood Good Good Yecxond Vecond Good Excellent YecxGond. Excellent Excellent Good 32 28 21 46 27 27 14 16 29 12 32 36 51 30 20 38 51 21 32 48 40 22 18 26 24 31 40 48 11 30 14 43 24 31 21 41 11 10 16 14 38 34 43 259 South 260 East 261 East 262 North 263 North 264 East 265 South 266 North 267 South 268 West 269 West 270 South 271 West 272 East 273 West 274 West 275 East 276 South 277 East 278 North 279 East 280 East 281 North 282 West 283 West 284 North 285 West 286 North 287 South 288 East 289 East 290 West 291 West 292 South 293 East 294 North 295 West 296 West 297 South 208 East 290 South 300 West Excellent Excellent Very Good Excellent Excellent Very Good Very Good Excellent Good Very Good Excellent Good Excellent Good Very Good Good Excellent Very Good Good Excellent Very Good Very Good Excellent Excellent Good Very Good Very Good Good Good Good Very Good Good Good Very Good Excellent Excellent VacxGood YecxGond Very Good Excellent Yo Good Excellent 32 19 38 40 20 15 12 50 48 17 54 40 26 41 28 43 24 41 49 17 32 15 55 28 16 46 14 15 54 33 13 32 20 29 51 24 51 34 52 44 29 42 atorial 1 - Pivot Tables Questions 1. What are the sales totals for each region? To answer this question, proceed as follows. First, click on Region in the Field List and then drag it to the rows box in the Pivot Table pane. You will see the four regions enter the Pivottable. Next, drag Meal Price ($) into the values box of the Pivottable pane. The second column in the Pivot Table should now be Sum of Meal Price ($). What are the total sales for each Region and the Grand Total? Total Sales East $ North $ South $ West $ Grand Total $ 2. What are the sales totals for each Quality Rating? To answer this question, proceed as follows. First, click on Region in the rows box of the Pivot Table (where it was used to answer Question 1) and then drag it back into the Field List. Next, drag Quality Rating from the Field List into the rows box of the Pivot Table pane. What are the total sales for each Quality Rating? Total Sales Excellent $ Good $ Very Good $ 3. What is the sales total for a particular combination of Region and Quality Rating? For example, what is the sales total for Excellent restaurants in the West? To answer this question, proceed as follows. Drag Quality rating from the rows box to the column box in the Pivot Table pane. Then drag Region from the Field List into the rows box. The intersection of West and Excellent in the Pivot Table 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 meals in the East region to the nearest cent? To answer this question, proceed as follows. Select all numeric values in the Pivot Table as is appears from Question 3 above. Next, go to the Values box in the Pivot Table pane and click on Sum of Meal Prices and select Value Field Settings. In Value Field Settings select Average. Then click OK. In the Values box, it should now read Average of Meal Price ($). Ne med at 10:44 AM North $ South $ West $ Grand Total $ 2. What are the sales totals for each Quality Rating? To answer this question, proceed as follows. First, click on Region in the rows box of the PlvatTable (where it was used to answer Question 1) and then drag it back into the Field List. Next, drag Quality Rating from the Field List into the rows box of the Pivot Table pane. What are the total sales for each Quality Rating? Total Sales Excellent $ Good $ Very Good $ 3. What is the sales total for a particular combination of Region and Quality Rating? For example, what is the sales total for Excellent restaurants in the West? To answer this question, proceed as follows. Drag Quality rating from the rows box to the column box in the PivotTable pane. Then drag Region from the Field List into the rows box. The intersection of West and Excellent in the Pivot Table 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 meals in the East region to the nearest cent? To answer this question, proceed as follows. Select all numeric values in the Pivot Table as is appears from Question 3 above. Next, go to the Values box in the Pivottable pane and click on Sum of Meal Prices and select Value Field Settings. In Value Field Settings select Average. Then click OK. In the Values box, it should now read Average of Meal Price ($). Average meal price in the East Region is $ (to the nearest cent). Average meal price for Very Good meals in the East Region is $ (to the nearest cent). Check My Work Reset Problem Autosaved at 10:44 AM 1 South 2 West 3 East 4 East 5 South 6 East 7 West 8 West 9 West 10 East 11 South 12 North 13 South 14 South 15 East 16 West 17 East 18 South 19 South 20 West 21 North 22 South 23 East 24 West 25 West 26 North 27 North 28 West 29 East 30 North 31 East 32 East 33 West 34 East 35 West 36 North 37 South 38 South 39 West 40 West 41 South 42 West 43 East Excellent YecxGood Good Good Excellent Very Good Good Excellent Excellent VeryGood Excellent Excellent Good Excellent Very Good Very Good Excellent Very Good Very Good Good Good Good Excellent Good Good Very Good Good Very Good Excellent Good Good Excellent Good Good Very Good Good Good Good Very Good VocGood Excellent Good Good 45 54 51 35 46 46 18 49 24 22 36 34 53 34 23 11 28 39 19 20 41 37 14 32 27 43 54 48 50 33 25 10 26 40 30 46 26 18 15 49 52 34 47 and improvements, choose Check for Updates. 44 East 45 South 46 West 47 East 48 East 49 South 50 West 51 West 52 South 53 East 54 North 55 East 56 West 57 West 58 West 59 South 60 South 61 West 62 North 63 North 64 East 65 East 66 East 67 South 68 South 69 South 70 East 71 South 72 West 73 South 74 North 75 West 76 South 77 North 78 North 79 North 80 North 81 South 82 South 83 North 84 West 85 South 86 East Excellent Excellent Very Good Very Good Excellent Excellent Excellent Very Good Very Good Good Good Good Good Good Very Good Excellent Good Good Very Good Good Good YecxGood. Very Good VecxGood Good YecxGood Good Good Good Good Very Good Excellent Excellent Very Good Very Good Excellent VeryGond Good Very Good Good Excellent Good Very Good 37 26 40 36 25 38 37 55 52 10 28 15 39 32 24 31 16 51 19 18 27 44 45 48 31 46 12 18 38 16 20 25 28 31 23 30 34 30 39 12 29 18 87 East 88 North 89 North 90 West 91 East 92 West 93 East 94 West 95 West 96 East 97 South 98 West 99 South 100 East 101 North 102 North 103 West 104 West 105 East 106 East 107 West 108 East 109 North 110 West 111 North 112 North 113 North 114 South 115 North 116 East 117 North 118 South 119 East 120 South 121 North 122 South 123 West 124 West 125 South 126 West 127 North 128 South 129 South Excellent Excellent Excellent Excellent Very Good Very Good Excellent Very Good Very Good Excellent Very Good VeryGood Very Good Good Very Good VeryGood Excellent Good Good Good Very Good Good Excellent Very Good Vergoed VeryGood Good Excellent Excellent Good Excellent Good Very Good Good Very Good Good Good Vecy Good Good Excellent Very Gond Good Good 55 22 41 12 47 47 18 47 44 42 27 54 45 13 19 29 19 45 26 52 44 19 19 48 20 43 55 13 43 50 32 38 49 47 28 23 29 18 42 13 40 17 47 es, and improvements, choose Check for Updates. 130 South 131 North 132 North 133 South 134 North 135 West 136 West 137 East 138 South 139 South 140 North 141 West 142 West 143 South 144 East 145 South 146 South 147 East 148 East 149 North 150 North 151 South 152 West 153 South 154 North 155 North 156 North 157 South 158 South 159 East 160 East 161 North 162 West 163 West 164 North 165 East 166 South 167 South 168 West 169 West 170 North 171 East 172 East Excellent YecxGood Very Good Excellent VecxGood Excellent Good Very Good Excellent Good Very Good Excellent VeryGood Very Good Good Good Good Very Good Excellent Good Excellent VecxGood Very Good Good Very Good YecxGond. Excellent Good Excellent Good Good Good Good Good Excellent Good Good Excellent Excellent Excellent Excellent Excellent Excellent 15 36 36 39 22 31 16 49 13 38 17 13 29 13 29 45 16 28 22 36 49 44 23 30 43 37 30 12 16 24 47 25 13 48 44 39 16 49 55 49 44 44 173 West 174 North 175 East 176 North 177 South 178 North 179 North 180 West 181 North 182 West 183 West 184 North 185 South 186 North 187 North 188 West 189 East 190 East 191 West 192 South 193 East 194 West 195 East 196 South 197 West 198 East 199 South 200 West 201 East 202 North 203 East 204 East 205 North 206 North 207 East 208 West 209 East 210 South 211 West 212 North 213 West 214 West 215 West Excellent Good Good Excellent Excellent Excellent Excellent Good YecxGond. Very Good Excellent Good VecxGood Excellent Very Good Good Excellent Excellent Excellent Very Good Very Good Excellent Excellent Excellent Very Good Very Good Good Excellent Excellent Good Very Good Excellent VecxGond VecxGood Excellent Good Excellent Very Good Very Good Good Vergoed Excellent Very Good 23 22 36 51 10 39 23 47 19 33 47 34 27 34 39 46 23 49 45 36 52 25 20 35 47 11 31 33 23 24 40 52 10 31 54 25 28 26 14 31 36 49 32 and improvements, choose Check for Update 216 South 217 West 218 East 219 South 220 South 221 South 222 East 223 South 224 East 225 North 226 West 227 East 228 West 229 North 230 North 231 West 232 East 233 West 234 East 235 West 236 North 237 West 238 South 239 East 240 North 241 South 242 West 243. East 244 East 245 West 246 East 247 East 248 West 249 North 250 South 251 East 252 East 253 South 254 East 255 West 256 South 257 South 258 East Good SecGood. Excellent Excellent VeryGood YecxGood Good Excellent Very Good VecxGood Excellent Very Good Excellent Excellent Excellent Very Good Very Good Good Good Excellent Good YecxGood Good Good Excellent Good Very Good Very Good Good Yacx Gond Good Good YecxGood Good Good Yecxond Vecond Good Excellent YecxGond. Excellent Excellent Good 32 28 21 46 27 27 14 16 29 12 32 36 51 30 20 38 51 21 32 48 40 22 18 26 24 31 40 48 11 30 14 43 24 31 21 41 11 10 16 14 38 34 43 259 South 260 East 261 East 262 North 263 North 264 East 265 South 266 North 267 South 268 West 269 West 270 South 271 West 272 East 273 West 274 West 275 East 276 South 277 East 278 North 279 East 280 East 281 North 282 West 283 West 284 North 285 West 286 North 287 South 288 East 289 East 290 West 291 West 292 South 293 East 294 North 295 West 296 West 297 South 208 East 290 South 300 West Excellent Excellent Very Good Excellent Excellent Very Good Very Good Excellent Good Very Good Excellent Good Excellent Good Very Good Good Excellent Very Good Good Excellent Very Good Very Good Excellent Excellent Good Very Good Very Good Good Good Good Very Good Good Good Very Good Excellent Excellent VacxGood YecxGond Very Good Excellent Yo Good Excellent 32 19 38 40 20 15 12 50 48 17 54 40 26 41 28 43 24 41 49 17 32 15 55 28 16 46 14 15 54 33 13 32 20 29 51 24 51 34 52 44 29 42

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions