Can somone help me solve this question in Excel? The data is listed below. You c

Question

Can somone help me solve this question in Excel? The data is listed below. You can just tell me what to do.

------------

6: Sandwich shop data for pivot table    Location Week Type Size Price Quantity Revenue North 1 turkey Large 12.00 1195 14340 North 1 turkey Small 4.00 853 3412 North 1 tuna Large 10.00 1551 15510 North 1 tuna Small 2.50 1215 3037.5 North 1 ham&cheese Large 11.00 1376 15136 North 1 ham&cheese Small 2.90 1056 3062.4 North 1 turkey Large 12.00 1183 14196 North 2 turkey Small 4.00 818 3272 North 2 tuna Large 10.00 1530 15300 North 2 tuna Small 2.50 1222 3055 North 2 ham&cheese Large 11.00 1401 15411 North 2 ham&cheese Small 2.90 1015 2943.5 North 2 turkey Large 12.00 1175 14100 North 2 turkey Small 4.00 842 3368 North 3 tuna Large 10.00 1540 15400 North 3 tuna Small 2.50 1210 3025 North 3 ham&cheese Large 11.00 1397 15367 North 3 ham&cheese Small 2.90 1059 3071.1 North 3 turkey Large 12.00 1149 13788 North 3 turkey Small 4.00 833 3332 North 3 tuna Large 10.00 1583 15830 North 4 tuna Small 2.50 1196 2990 North 4 ham&cheese Large 11.00 1374 15114 North 4 ham&cheese Small 2.90 1009 2926.1 North 4 turkey Large 12.00 1198 14376 North 4 turkey Small 4.00 864 3456 North 4 tuna Large 10.00 1567 15670 North 4 tuna Small 2.50 1192 2980 North 5 ham&cheese Large 11.00 1386 15246 North 5 ham&cheese Small 2.90 1027 2978.3 North 5 turkey Large 12.00 1196 14352 North 5 turkey Small 4.00 844 3376 North 5 tuna Large 10.00 1578 15780 North 5 tuna Small 2.50 1191 2977.5 North 5 ham&cheese Large 11.00 1372 15092 North 6 ham&cheese Small 2.90 1019 2955.1 North 6 turkey Large 12.00 1205 14460 North 6 turkey Small 4.00 813 3252 North 6 tuna Large 10.00 1552 15520 North 6 tuna Small 2.50 1249 3122.5 North 6 ham&cheese Large 11.00 1352 14872 North 6 ham&cheese Small 2.90 1038 3010.2 North 7 turkey Large 12.00 1164 13968 North 7 turkey Small 4.00 842 3368 North 7 tuna Large 10.00 1575 15750 North 7 tuna Small 2.50 1181 2952.5 North 7 ham&cheese Large 11.00 1344 14784 North 7 ham&cheese Small 2.90 1001 2902.9 North 7 turkey Large 12.00 1164 13968 North 8 turkey Small 4.00 805 3220 North 8 tuna Large 10.00 1554 15540 North 8 tuna Small 2.50 1243 3107.5 North 8 ham&cheese Large 11.00 1341 14751 North 8 ham&cheese Small 2.90 1032 2992.8 North 8 turkey Large 12.00 1150 13800 North 8 turkey Small 4.00 800 3200 North 9 tuna Large 10.00 1523 15230 North 9 tuna Small 2.50 1196 2990 North 9 ham&cheese Large 11.00 1354 14894 North 9 ham&cheese Small 2.90 1049 3042.1 North 9 turkey Large 12.00 1171 14052 North 9 turkey Small 4.00 850 3400 North 9 tuna Large 10.00 1570 15700 North 10 tuna Small 2.50 1182 2955 North 10 ham&cheese Large 11.00 1352 14872 North 10 ham&cheese Small 2.90 1024 2969.6 North 10 turkey Large 12.00 1210 14520 North 10 turkey Small 4.00 874 3496 North 10 tuna Large 10.00 1523 15230 North 10 tuna Small 2.50 1231 3077.5 North 11 ham&cheese Large 11.00 1394 15334 North 11 ham&cheese Small 2.90 1030 2987 North 11 turkey Large 12.00 1151 13812 North 11 turkey Small 4.00 848 3392 North 11 tuna Large 10.00 1529 15290 North 11 tuna Small 2.50 1188 2970 North 11 ham&cheese Large 11.00 1396 15356 North 12 ham&cheese Small 2.90 1044 3027.6 North 12 turkey Large 12.00 1155 13860 North 12 turkey Small 4.00 840 3360 North 12 tuna Large 10.00 1549 15490 North 12 tuna Small 2.50 1235 3087.5 North 12 ham&cheese Large 11.00 1411 15521 North 12 ham&cheese Small 2.90 1027 2978.3 North 13 turkey Large 12.00 1184 14208 North 13 turkey Small 4.00 840 3360 North 13 tuna Large 10.00 1530 15300 North 13 tuna Small 2.50 1196 2990 North 13 ham&cheese Large 11.00 1365 15015 North 13 ham&cheese Small 2.90 1039 3013.1 North 13 turkey Large 12.00 1177 14124 North 14 turkey Small 4.00 834 3336 North 14 tuna Large 10.00 1560 15600 North 14 tuna Small 2.50 1225 3062.5 North 14 ham&cheese Large 11.00 1349 14839 North 14 ham&cheese Small 2.90 1049 3042.1 North 14 turkey Large 12.00 1164 13968 North 14 turkey Small 4.00 829 3316 North 15 tuna Large 10.00 1587 15870 North 15 tuna Small 2.50 1250 3125 North 15 ham&cheese Large 11.00 1378 15158 North 15 ham&cheese Small 2.90 1003 2908.7 North 15 turkey Large 12.00 1154 13848 North 15 turkey Small 4.00 827 3308 North 15 tuna Large 10.00 1533 15330 North 16 tuna Small 2.50 1235 3087.5 North 16 ham&cheese Large 11.00 1369 15059 North 16 ham&cheese Small 2.90 1009 2926.1 North 16 turkey Large 12.00 1159 13908 North 16 turkey Small 4.00 803 3212 North 16 tuna Large 10.00 1545 15450 North 16 tuna Small 2.50 1252 3130 North 17 ham&cheese Large 11.00 1394 15334 North 17 ham&cheese Small 2.90 1023 2966.7 North 17 turkey Large 12.00 1160 13920 North 17 turkey Small 4.00 801 3204 North 17 tuna Large 10.00 1531 15310 North 17 tuna Small 2.50 1208 3020 North 17 ham&cheese Large 11.00 1397 15367 North 18 ham&cheese Small 2.90 1003 2908.7 North 18 turkey Large 12.00 1175 14100 North 18 turkey Small 4.00 867 3468 North 18 tuna Large 10.00 1564 15640 North 18 tuna Small 2.50 1225 3062.5 North 18 ham&cheese Large 11.00 1371 15081 North 18 ham&cheese Small 2.90 1044 3027.6 North 19 turkey Large 12.00 1176 14112 North 19 turkey Small 4.00 817 3268 North 19 tuna Large 10.00 1521 15210 North 19 tuna Small 2.50 1214 3035 North 19 ham&cheese Large 11.00 1388 15268 North 19 ham&cheese Small 2.90 1017 2949.3 Central 1 turkey Large 11.50 1048 12052 Central 1 turkey Small 3.80 745 2831 Central 1 tuna Large 9.75 1467 14303.25 Central 1 tuna Small 2.40 1135 2724 Central 1 ham&cheese Large 10.20 1301 13270.2 Central 1 ham&cheese Small 2.70 954 2575.8 Central 1 turkey Large 11.50 1092 12558 Central 2 turkey Small 3.80 715 2717 Central 2 tuna Large 9.75 1481 14439.75 Central 2 tuna Small 2.40 1148 2755.2 Central 2 ham&cheese Large 10.20 1312 13382.4 Central 2 ham&cheese Small 2.70 901 2432.7 Central 2 turkey Large 11.50 1089 12523.5 Central 2 turkey Small 3.80 753 2861.4 Central 3 tuna Large 9.75 1430 13942.5 Central 3 tuna Small 2.40 1109 2661.6 Central 3 ham&cheese Large 10.20 1268 12933.6 Central 3 ham&cheese Small 2.70 942 2543.4 Central 3 turkey Large 11.50 1083 12454.5 Central 3 turkey Small 3.80 722 2743.6 Central 3 tuna Large 9.75 1453 14166.75 Central 4 tuna Small 2.40 1107 2656.8 Central 4 ham&cheese Large 10.20 1311 13372.2 Central 4 ham&cheese Small 2.70 966 2608.2 Central 4 turkey Large 11.50 1104 12696 Central 4 turkey Small 3.80 721 2739.8 Central 4 tuna Large 9.75 1437 14010.75 Central 4 tuna Small 2.40 1120 2688 Central 5 ham&cheese Large 10.20 1295 13209 Central 5 ham&cheese Small 2.70 945 2551.5 Central 5 turkey Large 11.50 1087 12500.5 Central 5 turkey Small 3.80 760 2888 Central 5 tuna Large 9.75 1473 14361.75 Central 5 tuna Small 2.40 1111 2666.4 Central 5 ham&cheese Large 10.20 1287 13127.4 Central 6 ham&cheese Small 2.70 918 2478.6 Central 6 turkey Large 11.50 1075 12362.5 Central 6 turkey Small 3.80 773 2937.4 Central 6 tuna Large 9.75 1471 14342.25 Central 6 tuna Small 2.40 1150 2760 Central 6 ham&cheese Large 10.20 1289 13147.8 Central 6 ham&cheese Small 2.70 902 2435.4 Central 7 turkey Large 11.50 1042 11983 Central 7 turkey Small 3.80 765 2907 Central 7 tuna Large 9.75 1430 13942.5 Central 7 tuna Small 2.40 1090 2616 Central 7 ham&cheese Large 10.20 1272 12974.4 Central 7 ham&cheese Small 2.70 947 2556.9 Central 7 turkey Large 11.50 1065 12247.5 Central 8 turkey Small 3.80 758 2880.4 Central 8 tuna Large 9.75 1440 14040 Central 8 tuna Small 2.40 1153 2767.2 Central 8 ham&cheese Large 10.20 1312 13382.4 Central 8 ham&cheese Small 2.70 950 2565 Central 8 turkey Large 11.50 1108 12742 Central 8 turkey Small 3.80 772 2933.6 Central 9 tuna Large 9.75 1427 13913.25 Central 9 tuna Small 2.40 1122 2692.8 Central 9 ham&cheese Large 10.20 1302 13280.4 Central 9 ham&cheese Small 2.70 969 2616.3 Central 9 turkey Large 11.50 1058 12167 Central 9 turkey Small 3.80 735 2793 Central 9 tuna Large 9.75 1474 14371.5 Central 10 tuna Small 2.40 1123 2695.2 Central 10 ham&cheese Large 10.20 1288 13137.6 Central 10 ham&cheese Small 2.70 932 2516.4 Central 10 turkey Large 11.50 1044 12006 Central 10 turkey Small 3.80 720 2736 Central 10 tuna Large 9.75 1436 14001 Central 10 tuna Small 2.40 1087 2608.8 Central 11 ham&cheese Large 10.20 1248 12729.6 Central 11 ham&cheese Small 2.70 966 2608.2 Central 11 turkey Large 11.50 1051 12086.5 Central 11 turkey Small 3.80 757 2876.6 Central 11 tuna Large 9.75 1484 14469 Central 11 tuna Small 2.40 1130 2712 Central 11 ham&cheese Large 10.20 1264 12892.8 Central 12 ham&cheese Small 2.70 910 2457 Central 12 turkey Large 11.50 1109 12753.5 Central 12 turkey Small 3.80 768 2918.4 Central 12 tuna Large 9.75 1482 14449.5 Central 12 tuna Small 2.40 1122 2692.8 Central 12 ham&cheese Large 10.20 1291 13168.2 Central 12 ham&cheese Small 2.70 928 2505.6 Central 13 turkey Large 11.50 1073 12339.5 Central 13 turkey Small 3.80 709 2694.2 Central 13 tuna Large 9.75 1446 14098.5 Central 13 tuna Small 2.40 1138 2731.2 Central 13 ham&cheese Large 10.20 1312 13382.4 Central 13 ham&cheese Small 2.70 914 2467.8 Central 13 turkey Large 11.50 1084 12466 Central 14 turkey Small 3.80 715 2717 Central 14 tuna Large 9.75 1443 14069.25 Central 14 tuna Small 2.40 1113 2671.2 Central 14 ham&cheese Large 10.20 1262 12872.4 Central 14 ham&cheese Small 2.70 935 2524.5 Central 14 turkey Large 11.50 1083 12454.5 Central 14 turkey Small 3.80 758 2880.4 Central 15 tuna Large 9.75 1457 14205.75 Central 15 tuna Small 2.40 1080 2592 Central 15 ham&cheese Large 10.20 1271 12964.2 Central 15 ham&cheese Small 2.70 954 2575.8 Central 15 turkey Large 11.50 1044 12006 Central 15 turkey Small 3.80 717 2724.6 Central 15 tuna Large 9.75 1468 14313 Central 16 tuna Small 2.40 1103 2647.2 Central 16 ham&cheese Large 10.20 1306 13321.2 Central 16 ham&cheese Small 2.70 925 2497.5 Central 16 turkey Large 11.50 1102 12673 Central 16 turkey Small 3.80 743 2823.4 Central 16 tuna Large 9.75 1427 13913.25 Central 16 tuna Small 2.40 1107 2656.8 Central 17 ham&cheese Large 10.20 1258 12831.6 Central 17 ham&cheese Small 2.70 926 2500.2 Central 17 turkey Large 11.50 1053 12109.5 Central 17 turkey Small 3.80 707 2686.6 Central 17 tuna Large 9.75 1475 14381.25 Central 17 tuna Small 2.40 1110 2664 Central 17 ham&cheese Large 10.20 1273 12984.6 Central 18 ham&cheese Small 2.70 974 2629.8 Central 18 turkey Large 11.50 1094 12581 Central 18 turkey Small 3.80 767 2914.6 Central 18 tuna Large 9.75 1487 14498.25 Central 18 tuna Small 2.40 1115 2676 Central 18 ham&cheese Large 10.20 1291 13168.2 Central 18 ham&cheese Small 2.70 906 2446.2 Central 19 turkey Large 11.50 1104 12696 Central 19 turkey Small 3.80 706 2682.8 Central 19 tuna Large 9.75 1457 14205.75 Central 19 tuna Small 2.40 1100 2640 Central 19 ham&cheese Large 10.20 1314 13402.8 Central 19 ham&cheese Small 2.70 922 2489.4 South 1 turkey Large 12.80 1309 16755.2 South 1 turkey Small 4.20 991 4162.2 South 1 tuna Large 11.00 1670 18370 South 1 tuna Small 3.10 1330 4123 South 1 ham&cheese Large 11.90 1561 18575.9 South 1 ham&cheese Small 2.98 1212 3611.76 South 1 turkey Large 12.80 1303 16678.4 South 2 turkey Small 4.20 965 4053 South 2 tuna Large 11.00 1691 18601 South 2 tuna Small 3.10 1395 4324.5 South 2 ham&cheese Large 11.90 1492 17754.8 South 2 ham&cheese Small 2.98 1161 3459.78 South 2 turkey Large 12.80 1311 16780.8 South 2 turkey Small 4.20 983 4128.6 South 3 tuna Large 11.00 1675 18425 South 3 tuna Small 3.10 1354 4197.4 South 3 ham&cheese Large 11.90 1540 18326 South 3 ham&cheese Small 2.98 1204 3587.92 South 3 turkey Large 12.80 1335 17088 South 3 turkey Small 4.20 1002 4208.4 South 3 tuna Large 11.00 1688 18568 South 4 tuna Small 3.10 1349 4181.9 South 4 ham&cheese Large 11.90 1560 18564 South 4 ham&cheese Small 2.98 1171 3489.58 South 4 turkey Large 12.80 1311 16780.8 South 4 turkey Small 4.20 971 4078.2 South 4 tuna Large 11.00 1707 18777 South 4 tuna Small 3.10 1397 4330.7 South 5 ham&cheese Large 11.90 1500 17850 South 5 ham&cheese Small 2.98 1162 3462.76 South 5 turkey Large 12.80 1355 17344 South 5 turkey Small 4.20 967 4061.4 South 5 tuna Large 11.00 1707 18777 South 5 tuna Small 3.10 1361 4219.1 South 5 ham&cheese Large 11.90 1500 17850 South 6 ham&cheese Small 2.98 1211 3608.78 South 6 turkey Large 12.80 1356 17356.8 South 6 turkey Small 4.20 993 4170.6 South 6 tuna Large 11.00 1744 19184 South 6 tuna Small 3.10 1337 4144.7 South 6 ham&cheese Large 11.90 1550 18445 South 6 ham&cheese Small 2.98 1179 3513.42 South 7 turkey Large 12.80 1336 17100.8 South 7 turkey Small 4.20 1006 4225.2 South 7 tuna Large 11.00 1734 19074 South 7 tuna Small 3.10 1360 4216 South 7 ham&cheese Large 11.90 1491 17742.9 South 7 ham&cheese Small 2.98 1181 3519.38 South 7 turkey Large 12.80 1298 16614.4 South 8 turkey Small 4.20 1005 4221 South 8 tuna Large 11.00 1683 18513 South 8 tuna Small 3.10 1356 4203.6 South 8 ham&cheese Large 11.90 1563 18599.7 South 8 ham&cheese Small 2.98 1173 3495.54 South 8 turkey Large 12.80 1334 17075.2 South 8 turkey Small 4.20 1002 4208.4 South 9 tuna Large 11.00 1673 18403 South 9 tuna Small 3.10 1386 4296.6 South 9 ham&cheese Large 11.90 1560 18564 South 9 ham&cheese Small 2.98 1189 3543.22 South 9 turkey Large 12.80 1346 17228.8 South 9 turkey Small 4.20 951 3994.2 South 9 tuna Large 11.00 1683 18513 South 10 tuna Small 3.10 1382 4284.2 South 10 ham&cheese Large 11.90 1509 17957.1 South 10 ham&cheese Small 2.98 1176 3504.48 South 10 turkey Large 12.80 1346 17228.8 South 10 turkey Small 4.20 988 4149.6 South 10 tuna Large 11.00 1685 18535 South 10 tuna Small 3.10 1382 4284.2 South 11 ham&cheese Large 11.90 1494 17778.6 South 11 ham&cheese Small 2.98 1162 3462.76 South 11 turkey Large 12.80 1341 17164.8 South 11 turkey Small 4.20 968 4065.6 South 11 tuna Large 11.00 1706 18766 South 11 tuna Small 3.10 1352 4191.2 South 11 ham&cheese Large 11.90 1522 18111.8 South 12 ham&cheese Small 2.98 1195 3561.1 South 12 turkey Large 12.80 1291 16524.8 South 12 turkey Small 4.20 950 3990 South 12 tuna Large 11.00 1683 18513 South 12 tuna Small 3.10 1346 4172.6 South 12 ham&cheese Large 11.90 1563 18599.7 South 12 ham&cheese Small 2.98 1173 3495.54 South 13 turkey Large 12.80 1329 17011.2 South 13 turkey Small 4.20 1004 4216.8 South 13 tuna Large 11.00 1721 18931 South 13 tuna Small 3.10 1348 4178.8 South 13 ham&cheese Large 11.90 1529 18195.1 South 13 ham&cheese Small 2.98 1165 3471.7 South 13 turkey Large 12.80 1352 17305.6 South 14 turkey Small 4.20 954 4006.8 South 14 tuna Large 11.00 1734 19074 South 14 tuna Small 3.10 1364 4228.4 South 14 ham&cheese Large 11.90 1532 18230.8 South 14 ham&cheese Small 2.98 1176 3504.48 South 14 turkey Large 12.80 1352 17305.6 South 14 turkey Small 4.20 975 4095 South 15 tuna Large 11.00 1677 18447 South 15 tuna Small 3.10 1374 4259.4 South 15 ham&cheese Large 11.90 1496 17802.4 South 15 ham&cheese Small 2.98 1186 3534.28 South 15 turkey Large 12.80 1295 16576 South 15 turkey Small 4.20 981 4120.2 South 15 tuna Large 11.00 1675 18425 South 16 tuna Small 3.10 1362 4222.2 South 16 ham&cheese Large 11.90 1538 18302.2 South 16 ham&cheese Small 2.98 1216 3623.68 South 16 turkey Large 12.80 1311 16780.8 South 16 turkey Small 4.20 959 4027.8 South 16 tuna Large 11.00 1719 18909 South 16 tuna Small 3.10 1401 4343.1 South 17 ham&cheese Large 11.90 1559 18552.1 South 17 ham&cheese Small 2.98 1193 3555.14 South 17 turkey Large 12.80 1295 16576 South 17 turkey Small 4.20 981 4120.2 South 17 tuna Large 11.00 1675 18425 South 17 tuna Small 3.10 1362 4222.2 South 18 ham&cheese Large 11.90 1496 17802.4 South 18 ham&cheese Small 2.98 1186 3534.28 South 18 turkey Large 12.80 1295 16576 South 18 turkey Small 4.20 981 4120.2 South 18 tuna Large 11.00 1675 18425 South 18 tuna Small 3.10 1362 4222.2 South 19 ham&cheese Large 11.90 1538 18302.2 South 19 ham&cheese Small 2.98 1216 3623.68 South 19 turkey Large 12.80 1311 16780.8 South 19 turkey Small 4.20 959 4027.8 South 19 tuna Large 11.00 1719 18909 South 19 tuna Small 3.10 1401 4343.1

Explanation / Answer

Pivot Table view-1 Revinue central North South Total ham&cheese 283.8 48913 344517.6 393714.4 large 224.4 28327 288935.4 317486.8 small 59.4 20586 55582.2 76227.6 tuna 267.3 56618 371414 428299.3 large 214.5 32045 312438.8 344698.3 small 52.8 24573 58975.2 83601 turkey 336.6 39978 334344.8 374659.4 large 253 23692 272458 296403 small 83.6 16286 61886.8 78256.4 choose Data from drop down from the above options and choose filter option from then select the attribute according to the required table Pivot Table view-2 Revinue central North South Total ham&cheese tuna turkey 336.6 352 374 1062.6 total Pivot Table view-3 Revinue Large Small Total ham&cheese 716.3 185.78 902.08 tuna 676.5 176 852.5 turkey total Pivot Table view-4 Revinue Quantity Revinue ham&cheese cental north south tuna cental north south turkey cental north south Grand Total

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.