Answered step by step
Verified Expert Solution
Question
1 Approved Answer
AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11
AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Format Sensitivity Formatting as Table Styles v Filter Select Data E25 X V fx Male B E G N Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 2 750-67-8428 A fangon Member Female Health and beauty 74.69 522.83 26.14 548.97 5/1/19 13:08 Ewallet 226-31-3081 C Naypyitaw Normal Female Electronic accessories 15.28 76.40 3.82 80.22 8/3/15 10:29 Cash 631-41-3108 A Yangon Normal Male Home and lifestyle 46.33 324.3 16.22 340.53 3/3/19 13:23 Credit card 5 123-19-1176 A fangor Member Male Health and beauty 58.22 165.76 23.29 189.05 1/27/2019 20:33 Ewallet 6 373-73-7910 A fangon Normal Male Sports and travel 86.31 504.17 30.21 634.38 8/2/19 10:37 Ewallet 7 699-14-3026 C Naypyitaw Normal Male Electronic accessories 85.39 597.73 29.89 527.62 3/25/2019 18:30 Ewallet 8 355-53-5943 A Yangon Member Female Electronic accessories 68.84 413.04 20.65 433.69 2/25/2019 14:36 Ewallet 9 315-22-5665 C Naypyitaw Normal Female Home and lifestyle 73.56 735.6 36.78 772.38 2/24/2019 1:38 Ewallet 10 665-32-9167 Yangon Member Female Health and beauty 36.26 72.52 3.63 76.15 10/1/19 17:15 Credit card 11 692-92-5582 B Mandalay Member Female Food and beverages 54.84 164.52 8.23 172.75 2/20/2019 13:27 Credit card 12 351-62-0822 B Mandalay Member Female Fashion accessories 14.48 57.92 2.90 60.82 6/2/19 18:07 Ewallet 13 529-56-3974 B Mandalay Member Male Electronic accessories 25.51 102.04 5.10 107.14 9/3/19 17:03 Cash 14 365-64-0515 A Yangon Normal Female Electronic accessories 46.95 234.75 11.74 246.4 12/2/19 10:25 Ewallet 15 252-56-2699 fangon Normal Male Food and beverages 43.19 131.90 21.60 153.50 7/2/19 16:48 Ewallet 16 829-34-3910 A fangon Normal Female Health and beauty 71.38 713.80 35.69 749.49 3/29/2019 19:21 Cash 17 299-46-1805 B Mandalay Member Female Sports and travel 93.72 562.32 28.12 590.44 1/15/2019 16:19 Cash 18 656-95-9349 A Yangon Member Female Health and beauty 68.93 182.51 24.13 506.6 11/3/19 11:03 Credit card 19 765-26-6951 Yangon Normal Male Sports and travel 72.61 435.66 21.78 457.44 1/1/19 10:39 Credit card 20 329-62-1586 fangon Normal Male Food and beverages 54.67 164.01 8.20 72.21 1/21/2019 18:00 Credit card 21 319-50-3348 B Mandalay Normal Female Home and lifestyle 40.30 80.60 4.03 84.63 11/3/19 15:30 Ewallet 22 300-71-4605 C Naypyitaw Member Male Electronic accessories 86.04 30.20 21.51 51.71 2/25/2019 11:24 Ewallet 23 371-85-5789 B Mandalay Normal Male Health and beauty 87.98 263.94 13.20 277.14 5/3/19 10:40 Ewallet 24 273-16-6619 B Mandalay Normal Male Home and lifestyle 33.20 66.40 3.32 69.72 3/15/2019 12:20 Credit card 25 636-48-8204 fangor Normal Male Electronic accessories 34.56 172.80 8.64 181.44 2/17/201 11:15 Ewallet 26 549-59-1358 A fangon Member Male Sports and trave 88.63 265.89 13.29 279.18 2/3/19 17:36 Ewallet 27 227-03-5010 A fangon Member Female Home and lifestyle 52.59 420.72 21.04 441.76 3/22/2019 19:20 Credit card 28 649-29-6775 B Mandalay Normal Male Fashion accessories 33.52 33.52 1.6 35.20 8/2/19 15:31 Cash 29 189-17-4241 Yangon Normal Female Fashion accessories 87.67 175.34 8.77 184.11 10/3/1 12:17 Credit card 30 145-94-9061 B Mandalay Normal Female Food and beverages 88.36 141.80 22.09 163.89 1/25/201 19:48 Cash 31 848-62-7243 A Yangon Normal Male Health and beauty 24.89 224.01 11.20 235.21 3/15/2019 15:36 Cash 32 871-79-8483 B Mandalay Normal Male Fashion accessories 94.13 470.65 23.53 494.18 2/25/2019 19:39 Credit card 33 149-71-6266 B Mandalay Member Male Sports and travel 78.07 702.63 35.13 737.76 1/28/2019 12:43 Cash 34 640-49-2076 B Mandalay Normal Male Sports and travel 83.78 670.24 33.51 703.75 10/1/1 14:49 Cash 35 595-11-5460 fangon Norma Male Health and beauty 96.58 193.16 9.66 202.82 3/15/2019 10:12 Credit card 36 183-56-6882 Naypyitaw Member Female Food and beverages 99.42 97.68 19.88 17.56 6/2/19 10:42 Ewallet 37 232-16-2483 Naypyitaw Member Female Sports and travel 68.12 68.12 3.41 71.53 7/1/19 12:28 Ewallet 38 129-29-8530 A fangor Member Male Sports and travel 62.62 313.10 15.66 328.76 10/3/19 19:15 Ewallet 39 272-65-1806 A Yangon Normal Female Electronic accessories 60.88 547.92 27.40 575.32 1/15/2019 17:17 Ewallet 10 333-73-7901 Naypyitaw Norma Female Health and beauty 54.92 139.36 21.97 161.33 3/23/2019 13:24 Ewallet 41 777-82-7220 B Mandalay Member Male Home and lifestyle 30.12 240.96 12.05 253.01 3/3/19 13:01 Cash 42 280-35-5823 B Mandalay Member Female Home and lifestyle 86.72 86.72 4.34 91.06 1/17/2019 18:45 Ewallet 43 554-53-8700 c Naypyitaw Member Male Home and lifestyle 56.11 112.22 5.61 117.83 2/2/19 10:11 Cash 44 354-25-5821 B Mandalay Member Female Sports and travel 69.12 414.72 20.74 435.46 8/2/19 13:03 Cash Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male E G N Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 44 354-25-5821 B Mandalay Member Female Sports and travel 69.12 6 414.72 20.74 135.46 8/2/19 13:03 Cash 45 228-96-1411 C Naypyitaw Member Female Food and beverages 98.70 789.60 39.48 329.08 4/3/19 20:39 Cast 46 617-15-4209 C Naypyitaw Member Male Health and beauty 15.37 30.74 1.54 32.28 3/16/2019 19:47 Cash 47 132-32-9879 B Mandalay Member Female Electronic accessories 93.96 375.84 18.79 394.63 9/3/19 18:00 Cash 48 370-41-7321 B Mandalay Member Male Health and beauty 56.69 510.21 25.51 535.72 2/27/2019 17:24 Credit card 49 727-46-3608 B Mandalay Member Female Food and beverages 20.01 180.09 9.00 189.09 6/2/19 15:47 Ewallet 50 669-54-1719 B Mandalay Member Male Electronic accessories 18.93 113.58 5.68 119.26 10/2/19 12:45 Credit card 51 574-22-5561 C Naypyitaw Member Female Fashion accessories 82.63 826.30 41.32 867.62 3/19/2019 17:08 Ewallet 52 326-78-5178 C Naypyitaw Member Male Food and beverages 91.40 639.80 31.99 571.79 3/2/19 10:19 Cash 53 162-48-8011 A Yangon Member Female Food and beverages 44.59 222.95 11.15 234.10 10/2/1 15:10 Cash 54 616-24-2851 B Mandalay Member Female Fashion accessories 17.87 71.48 3.57 75.05 3/22/2019 14:42 Ewallet 55 778-71-5554 C Naypyitaw Member Male Fashion accessories 15.43 15.43 0.77 16.20 1/25/2019 15:46 Credit card 56 242-55-6721 B Mandalay Normal Male Home and lifestyle 16.16 32.32 1.62 33.94 7/3/19 11:49 Ewallet 57 399-46-5918 C Naypyitaw Normal Female Electronic accessories 85.98 587.84 34.39 722.23 2/28/2019 19:01 Cash 58 106-35-6779 A fangon Member Male Home and lifestyle 44.34 88.68 4.43 93.11 3/27/2019 11:26 Cash 59 635-40-6220 A fangor Norma Male Health and beauty 89.60 716.80 35.84 752.64 7/2/19 11:28 Ewallet 60 817-48-8732 A Yangon Member Female Home and lifestyle 72.35 723.50 36.18 759.68 1/20/2019 15:55 Cash 61 120-06-4233 C Naypyitaw Normal Male Electronic accessories 30.61 183.66 9.18 192.84 12/3/19 20:36 Cash 62 285-68-5083 C Naypyitaw Member Female Sports and travel 24.74 74.22 3.71 77.93 2/15/2019 17:47 Credit card 63 803-83-5989 Naypyitaw Norma Male Home and lifestyle 55.73 334.38 16.72 351.10 2/24/2019 10:55 Ewallet 54 347-34-2234 B Mandalay Member Female Sports and travel 55.07 495.63 24.78 520.41 3/2/19 13:40 Ewallet 65 199-75-8169 A Yangon Member Male Sports and travel 15.81 158.10 7.91 166.01 6/3/19 12:27 Credit card 66 853-23-2453 B Mandalay Member Male Health and beauty 75.74 302.96 15.15 318.11 2/14/201 14:35 Cash 67 877-22-3308 fangon Member Male Health and beauty 15.87 158.70 7.94 166.64 3/13/2019 16:40 Cash 68 838-78-4295 Naypyitaw Norma Female Health and beauty 33.47 66.94 3.35 70.29 10/2/19 15:43 Ewallet 69 109-28-2512 B Mandalay Member Female Fashion accessories 97.61 585.66 29.28 614.94 7/1/19 15:01 Ewallet 70 232-11-3025 A Yangon Normal Male Sports and travel 78.77 787.70 39.39 327.0 1/24/2019 10:04 Cash 71 382-03-4532 A fangon Member Female Health and beauty 18.33 18.33 0.92 19.25 2/2/19 18:50 Cash 72 393-65-2792 C Naypyitaw Normal Male Food and beverages 89.48 894.80 44.74 139.54 6/1/19 12:46 Credit card 73 796-12-2025 Naypyitaw Normal Male Fashion accessories 62.12 621.20 31.06 52.26 11/2/19 16:19 Cash 74 510-95-6347 B Mandalay Member Female Food and beverages 48.52 145.56 7.28 152.84 5/3/19 18:17 Ewallet 75 841-35-6630 C Naypyitaw Normal Female Electronic accessories 75.91 455.46 22.77 478.23 9/3/19 18:21 Cash 76 287-21-9091 A Yangon Normal Male Home and lifestyle 74.67 672.03 33.60 705.6 1/22/2019 10:55 Ewallet 77 732-94-0499 C Naypyitaw Normal Female Electronic accessories 41.65 $16.50 20.83 137.33 1/13/2019 17:04 Credit card 78 263-10-3913 Naypyitaw Member Male Fashion accessories 49.04 141.36 22.07 163.43 9/1/1 14:20 Credit card 79 381-20-0914 A Yangon Member Female Fashion accessories 20.01 180.09 9.00 189.0 12/1/19 15:48 Credit card 80 829-49-1914 C Naypyitaw Member Female Food and beverages 78.31 783.10 39.16 322.26 5/3/19 16:24 Ewallet 81 756-01-7507 c Naypyitaw Normal Female Health and beauty 20.38 101.90 5.10 107.00 1/22/2019 18:56 Cash 82 870-72-4431 C Naypyitaw Normal Female Health and beauty 99.19 595.14 29.76 524.90 1/21/2019 14:42 Credit card 83 847-38-7188 Mandalay Norma Female Food and beverages 96.68 290.04 14.50 304.5 1/26/2019 19:56 Ewallet 84 480-63-2856 Naypyitaw Normal Male Food and beverages 19.25 154.00 7.70 161.70 1/23/2019 18:37 Ewallet 85 787-56-0757 C Naypyitaw Member Female Food and beverages 80.36 321.44 16.07 337.51 2/23/2019 18:45 Credit card 86 360-39-5055 c Naypyitaw Member Male Sports and travel 48.91 244.55 12.23 256.78 9/3/19 10:17 Cash Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste Analyse BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male B E G N Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 86 360-39-5055 C Naypyitaw Member Male Sports and travel 48.91 244.55 12.23 256.78 9/3/19 10:17 Cash 87 730-50-9884 C Naypyitaw Normal Female Sports and travel 83.06 581.42 29.07 610.49 5/3/19 14:31 Ewallet 88 362-58-8315 C Naypyitaw Normal Male Fashion accessories 76.52 382.60 19.13 101.73 3/25/2019 10:23 Cash 89 633-44-8566 A fangor Member Male Food and beverages 49.38 345.66 17.28 362.94 3/27/2019 20:35 Credit card 90 504-35-8843 A Yangon Normal Male Sports and travel 42.47 42.47 2.12 44.59 2/1/19 16:57 Cash 91 318-68-5053 B Mandalay Normal Female Health and beauty 76.99 461.94 23.10 485.04 2/27/2019 17:55 Cash 2 565-80-5980 C Naypyitaw Member Female Home and lifestyle 17.38 189.52 9.48 199.00 1/23/2019 10:25 Cash 93 225-32-0908 C Naypyitaw Normal Female Sports and travel 44.86 448.6 22.43 171.03 1/26/2019 19:54 Ewallet 34 873-51-0671 A Yangon Member Female Sports and travel 21.98 153.8 7.69 161.55 10/1/1 16:42 Ewallet 95 152-08-9985 B Mandalay Member Male Health and beauty 64.36 579.24 28.96 08.20 12/3/19 12:09 Credit card 96 512-91-0811 C Naypyitaw Normal Male Health and beauty 89.75 89.75 4.49 94.24 6/2/19 20:05 Credit card 97 594-34-4444 Yangon Normal Male Electronic accessories 97.16 97.16 4.86 102.02 8/3/19 20:38 Ewallet 98 766-85-7061 B Mandalay Normal Male Health and beauty 87.87 878.70 13.94 322.6 3/29/2019 10:25 Ewallet 99 871-39-9221 C Naypyitaw Normal Female Electronic accessories 12.45 74.70 3.74 78.44 9/2/ 19 13:11 Cash 100 865-92-6136 A Yangon Normal Male Food and beverages 52.75 158.25 7.91 166.16 3/23/2019 10:16 Ewallet 101 733-01-9107 B Mandalay Normal Male Home and lifestyle 82.70 496.20 4.8 21.01 5/3/19 18:14 Cash 102 163-56-7055 C Naypyitaw Member Male Fashion accessories 48.71 48.71 2.44 51.15 3/26/2019 19:20 Cash 103 189-98-2939 Naypyitaw Normal Male Fashion accessories 78.55 706.95 35.35 42.30 1/3/19 13:22 Cash 104 551-21-3069 C Naypyitaw Normal Female Electronic accessories 23.07 207.63 10.38 218.01 1/2/19 11:27 Cash 105 212-62-1842 A Yangon Normal Male Food and beverages 58.26 349.56 17.48 367.04 3/28/2019 16:44 Cash 106 716-39-1409 B Mandalay Normal Male Health and beauty 30.35 212.45 10.62 223.07 3/19/2019 18:19 Cash 107 704-48-3927 Yangon Member Male Electronic accessories 88.67 886.70 44.34 931.04 12/1/19 14:50 Ewallet 108 628-34-3388 C Naypyitaw Normal Male Fashion accessories 27.38 164.28 8.21 172.49 5/1/19 20:54 Credit card 109 630-74-5166 A Yangon Normal Male Sports and travel 62.13 372.78 18.64 391.4 3/22/2019 20:19 Cash 110 588-01-7461 C Naypyitaw Normal Female Food and beverages 33.98 305.82 15.29 321.11 3/24/2019 10:43 Cash 111 861-77-0145 C Naypyitaw Member Male Electronic accessories 31.97 819.70 40.99 360.6 3/3/19 14:30 Cash 112 479-26-8945 B Mandalay Member Female Sports and travel 16.49 32.98 1.65 34.63 5/2/19 11:32 Ewallet 113 210-67-5886 C Naypyitaw Member Female Health and beauty 98.21 294.63 14.73 09.36 5/2/19 10:41 Credit card 114 227-78-1148 B Mandalay Norma Female Fashion accessories 72.84 509.88 25.49 535.37 2/15/20 12:44 Cash 115 645-44-1170 A Yangon Member Male Home and lifestyle 58.07 522.63 26.13 548.76 1/19/2019 20:07 Ewallet 116 237-01-6122 C Naypyitaw Member Female Home and lifestyle 80.79 727.11 36.36 763.47 1/2/19 20:31 Credit card 117 225-98-1496 C Naypyitaw Normal Female Fashion accessories 27.02 81.06 4.05 85.11 2/3/19 13:01 Credit card 118 291-32-1427 B Mandalay Member Male Fashion accessories 21.94 109.70 5.49 15.19 5/3/19 12:29 Ewallet 119 659-65-8956 B Mandalay Member Male Fashion accessories 51.36 51.36 2.57 53.93 1/16/201 15:26 Ewallet 120 642-32-2990 A Yangon Normal Female Food and beverages 10.96 109.60 5.48 115.08 2/2/19 20:48 Ewallet 121 378-24-2715 B Mandalay Normal Male Home and lifestyle 53.44 106.88 5.34 112.22 1/20/2019 20:38 Ewallet 122 638-60-7125 fangon Normal Female Electronic accessories 99.56 796.48 39.82 836.30 2/14/2019 17:03 Credit card 123 659-36-1684 Naypyitaw Member Male Sports and travel 57.12 399.84 19.99 $19.83 12/1/1 12:02 Credit 124 219-22-9386 B Mandalay Member Male Sports and travel 99.96 899.64 44.98 344.62 9/3/19 17:26 Credit card 125 336-78-2147 Naypyitaw Member Male Home and lifestyle 63.91 511.2 25.56 536.84 3/13/2019 19:52 Credit card 126 268-27-6179 Mandalay Member Female Fashion accessories 56.47 151.76 22.59 474.35 9/3/19 14:57 Ewallet 127 668-90-8900 Yangon Normal Female Home and lifestyle 3.69 $55.83 32.79 588.62 10/3/19 18:44 Credit card 128 870-54-3162 A Yangon Normal Female Sports and travel 32.25 161.25 8.06 169.31 1/27/2019 13:26 Cash Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v ZAY- O. Ex Delete Paste BIUV CvAv E Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Formatting as Table Styles Format Sensitivity v Filter Select Data E25 X V fx Male B E G N 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 128 870-54-3162 A fangon Normal Female Sports and travel 32.25 161.2 8.06 169.31 1/27/2019 13:26 Cash 129 189-08-9157 C Naypyitaw Normal Female Fashion accessories 31.73 285.57 14.28 299.85 8/1/19 16:17 Credit card 130 663-86-9076 C Naypyitaw Member Female Food and beverages 68.54 548.32 27.42 575.74 8/1/19 15:57 Ewallet 131 549-84-7482 B Mandalay Norma Female Sports and travel 90.28 312.52 40.63 353.15 8/2/19 11:15 Ewallet 132 191-10-6171 B Mandalay Normal Female Fashion accessories 39.62 277.34 13.87 291.21 1/25/2019 13:18 Cash 133 802-70-5316 A fangon Member Female Sports and trave 92.13 552.78 27.64 580.42 6/3/19 20:34 Cash 134 695-51-0018 B Mandalay Normal Female Sports and travel 34.84 139.36 6.97 146.33 10/2/19 18:36 Cash 135 590-83-4591 B Mandalay Member Male Electronic accessories 87.45 524.70 26.24 550.94 2/17/2019 14:40 Credit card 136 483-71-1164 Naypyitaw Normal Female Health and beauty 81.30 87.80 24.39 512.19 8/3/19 16:43 Ewallet 137 597-78-7908 Naypyitaw Normal Male Fashion accessories 90.22 270.66 13.53 284.19 2/18/2019 19:39 Cash 138 700-81-1757 A fangor Normal Female Electronic accessories 26.31 131.55 6.58 138.13 1/18/2019 20:59 Credit card 139 354-39-5160 A fangor Member Female Home and lifestyle 34.42 206.52 10.33 216.85 2/18/2019 15:39 Cash 140 241-72-9525 B Mandalay Normal Male Sports and travel 1.91 519.10 5.96 545.06 2/16/2019 12:21 Cash 141 575-30-8091 fangon Norma Male Sports and travel 72.50 580.00 29.00 509.00 3/16/201 19:25 Ewallet 142 731-81-9469 Naypyitaw Member Female Sports and travel 89.80 898.00 44.90 942.90 1/23/2019 13:00 Credit card 143 280-17-4359 Naypyitav Member Male Health and beauty 90.50 10 905.0 45.25 950.25 1/25/2019 13:48 Cash 144 338-65-2210 C Naypyitaw Member Female Health and beauty 68.60 586.00 34.30 20.30 5/2/19 19:57 Cash 145 488-25-4221 C Naypyitaw Member Female Food and beverages 30.41 30.41 1.57 31.93 2/22/2019 10:36 Credit card 146 239-10-7476 fangon Normal Female Home and lifestyle 77.95 167.70 23.39 191.09 1/21/2019 16:37 Ewallet 147 458-41-1477 Naypyitaw Normal Female Health and beauty 46.26 277.56 13.88 291.44 8/3/19 17:11 Credit card 148 685-64-1609 A fangon Member Female Fashion accessories 30.14 10 301.40 15.07 316.47 10/2/19 12:28 Ewallet 149 568-90-5112 C Naypyitaw Normal Male Health and beauty 66.14 264.56 13.23 277.7 3/19/2019 12:46 Credit card 150 262-47-2794 B Mandalay Member Male Home and lifestyle 71.86 574.88 28.74 603.62 6/3/19 15:07 Credit card 151 238-49-0436 fangon Norma Male Health and beauty 32.46 259.68 12.98 272.66 3/27/2019 13:48 Credit card 152 608-96-3517 B Mandalay Member Female Fashion accessories 91.54 366.16 18.31 384.47 3/23/2019 19:20 Credit card 153 584-86-7256 C Naypyitaw Member Male Sports and travel 34.56 241.92 12.10 254.02 11/3/19 16:07 Credit card 154 746-94-0204 A Yangon Normal Male Fashion accessories 83.24 749.16 37.46 786.62 1/29/2019 11:56 Credit card 155 214-17-6927 C Naypyitaw Normal Female Food and beverages 16.48 98.88 4.94 103.82 7/2/19 18:23 Ewallet 156 400-89-4171 Naypyitaw Norma Female Sports and travel 80.97 47.76 32.39 580.15 1/28/201 13:05 Cash 157 782-95-9291 A Yangon Member Male Food and beverages 92.29 161.45 23.07 184.52 2/20/2019 15:55 Credit card 158 279-74-2924 B Mandalay Member Male Electronic accessories 72.17 72.17 3.61 75.78 4/1/19 19:40 Cash 159 307-85-2293 B Mandalay Normal Male Home and lifestyle 50.28 251.40 12.57 263.97 7/3/19 13:58 Ewallet 160 743-04-1105 B Mandalay Member Male Health and beauty 97.22 374.98 13.7 918.73 3/30/2019 14:43 Ewallet 161 423-57-2993 B Mandalay Normal Male Sports and travel 93.39 560.34 28.02 588.36 3/27/201 19:18 Ewallet 162 894-41-5205 Naypyitaw Normal Female Food and beverages 43.18 345.44 17.27 362.71 1/19/2019 19:39 Credit card 163 275-28-0149 A fangor Normal Male Sports and travel 63.69 63.69 3.18 66.87 2/25/2019 16:21 Cash 164 101-17-6199 A Yangon Normal Male Food and beverages 45.79 320.53 16.03 336.56 3/13/2019 19:44 Credit card 165 423-80-0988 C Naypyitaw Normal Male Sports and travel 76.40 152.80 7.64 160.44 1/30/2019 19:42 Ewallet 166 548-46-9322 B Mandalay Normal Male Food and beverages 39.90 $99.00 19.95 $18.95 2/20/201 15:24 Credit card 167 505-02-0892 B Mandalay Member Male Health and beauty 42.57 340.56 17.03 357.59 2/25/2019 14:12 Ewallet 168 234-65-2137 Naypyitaw Normal Male Home and lifestyle 95.58 10 955.8 47.79 1,003.59 1/16/2019 13:32 Cash 169 687-47-8271 A Yangon Normal Male Fashion accessories 98.98 10 989.80 49.49 1,039.29 8/2/19 16:20 Credit card 170 796-32-9050 A Yangon Normal Male Food and beverages 51.28 307.68 15.38 $23.06 1/19/2019 16:31 Cash Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male E G 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 170 796-32-9050 A angon Normal Male Food and beverages 51.28 6 307.68 15.38 323.06 1/19/2019 16:31 Cash 171 105-31-1824 A Yangon Member Male Sports and travel 69.52 486.64 24.33 510.97 1/2/19 15:10 Credit card 172 249-42-3782 A Yangon Normal Male Health and beauty 70.01 350.05 17.50 367.5 3/1/19 11:36 Ewallet 173 316-55-4634 B Mandalay Member Male Food and beverages 80.05 400.25 20.01 420.26 1/26/2019 12:45 Credit card 174 733-33-4967 Naypyitaw Norma Male Electronic accessories 20.85 166.80 8.34 175.14 3/3/19 19:17 Cash 175 608-27-6295 B Mandalay Member Male Electronic accessories 52.89 317.3 15.87 333.21 1/19/2019 17:34 Credit card 176 414-12-7047 B Mandalay Normal Male Food and beverages 19.79 158.32 7.92 166.24 1/18/2019 12:04 Ewallet 177 827-26-2100 A fangor Member Male Home and lifestyle 33.84 304.56 15.23 319.79 3/21/2019 16:21 Ewallet 178 175-54-2529 fangon Member Male Food and beverages 22.17 177.36 8.87 186.23 3/3/19 17:01 Credit card 179 139-52-2867 Naypyitaw Normal Female Fashion accessories 22.51 157.57 7.88 165.45 2/13/2019 10:50 Credit card 180 407-63-8975 A Yangon Normal Male Food and beverages 73.88 143.28 22.16 465.44 3/23/2019 19:16 Ewallet 181 342-65-4817 Naypyitaw Member Male Health and beauty 86.80 260.40 13.02 273.42 1/28/2019 16:47 Ewallet 182 130-98-8941 Naypyitaw Normal Male Fashion accessories 64.26 449.82 22.49 472.31 9/2/19 10:00 Cash 183 434-83-9547 Naypyitaw Member Male Food and beverages 38.47 07.76 15.39 323.15 1/23/2019 1:51 Cash 184 851-28-6367 fangon Member Male Sports and travel 15.50 155.00 7.75 162.75 3/23/201 10:55 Ewallet 185 824-88-3614 Naypyitaw Normal Male Health and beauty 34.31 274.48 13.72 1/25/2019 15:00 Ewallet 186 586-25-0848 A Yangon Normal Female Sports and travel 12.34 86.38 4.32 90.70 4/3/19 11:19 Credit card 187 895-66-0685 B Mandalay Member Male Food and beverages 18.08 54.24 2.71 56.95 5/3/19 19:46 Ewallet 188 305-14-0245 B Mandalay Member Female Home and lifestyle 94.49 755.92 37.80 793.72 3/3/19 19:00 Ewallet 189 732-04-5373 B Mandalay Member Male Home and lifestyle 46.47 185.88 9.29 195.17 8/2/15 10:53 Cash 190 400-60-7251 A Yangon Normal Male Home and lifestyle 74.07 74.07 3.70 77.77 10/2/19 12:50 Ewallet 191 593-65-1552 C Naypyitaw Normal Female Home and lifestyle 69.81 279.24 13.96 293.20 1/28/2019 20:50 Credit card 192 284-34-9626 B Mandalay Normal Female Home and lifestyle 77.04 231.12 11.56 242.68 11/2/19 10:39 Credit card 193 437-58-8131 B Mandalay Normal Female Fashion accessories 73.52 147.04 7.35 154.39 1/15/2019 13:41 Ewallet 194 286-43-6208 Naypyitaw Norma Female Food and beverages 87.80 790.20 39.51 829.71 3/16/201 19:08 Cash 195 641-43-2399 B Mandalay Normal Male Home and lifestyle 25.55 102.20 5.11 107.31 1/26/2019 20:23 Ewallet 196 831-07-6050 A Yangon Normal Male Electronic accessories 32.71 163.55 8.18 171.73 3/19/2019 11:30 Credit card 197 556-86-3144 C Naypyitaw Member Female Fashion accessories 74.29 74.29 3.71 78.00 1/13/2019 19:30 Cash 198 848-24-9445 C Naypyitaw Member Male Health and beauty 43.70 87.40 4.37 91.77 3/26/2019 18:03 Cash 199 856-22-8149 Yangon Norma Female Home and lifestyle 25.29 25.29 1.26 26.55 3/23/2019 10:13 Ewallet 200 699-01-4164 Naypyitaw Normal Male Health and beauty 41.50 166.00 8.30 174.30 12/3/19 19:58 Credit card 201 420-11-4919 C Naypyitav Member Female Food and beverages 71.39 356.95 17.85 374.80 2/17/2019 19:57 Credit card 202 606-80-4905 C Naypyitaw Member Female Sports and travel 19.15 114.90 5.75 120.65 1/29/2019 10:01 Credit card 203 542-41-0513 B Mandalay Member Female Electronic accessories 57.49 229.96 11.50 241.46 3/15/2019 11:57 Cash 204 426-39-2418 Naypyitaw Normal Male Electronic accessories 61.41 429.87 21.49 151.36 1/14/2019 10:02 Cash 205 875-46-5808 B Mandalay Member Male Health and beauty 25.90 259.00 12.95 271.95 6/2/19 14:51 Ewallet 206 394-43-4238 B Mandalay Member Male Home and lifestyle 17.77 88.85 4.44 93.29 2/15/2019 12:42 Credit card 207 749-24-1565 A Yangon Normal Female Health and beauty 23.03 207.27 0.3 217.63 3/1/1 12:02 Ewallet 208 672-51-8681 C Naypyitaw Member Female Electronic accessories 66.65 99.85 29.99 529.84 4/1/19 18:19 Credit card 209 263-87-5680 Naypyitaw Member Female Home and lifestyle 28.53 85.30 14.27 299.5 3/18/2019 17:38 Ewallet 210 573-58-9734 B Mandalay Normal Female Fashion accessories 30.37 91.11 4.56 95.67 3/28/2019 13:41 Ewallet 211 817-69-8206 B Mandalay Normal Female Electronic accessories 99.73 897.57 44.88 942.45 2/3/19 19:42 Credit card 212 888-02-0338 A Yangon Normal Male Electronic accessories 26.23 236.07 11.80 247.87 1/25/2019 20:24 Ewallet Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Formatting as Table Styles Format Sensitivity v Filter Select Data E25 X V fx Male E G N 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 212 888-02-0338 A angon Normal Male Electronic accessories 26.23 236.07 11.80 247.87 1/25/2019 20:24 Ewallet 213 677-11-0152 C Naypyitaw Normal Female Food and beverages 93.26 839.34 41.97 881.31 1/16/2019 18:08 Cash 214 142-63-6033 B Mandalay Normal Male Home and lifestyle 92.36 161.80 23.09 484.89 3/20/2019 19:17 Ewallet 215 656-16-1063 B Mandalay Normal Male Sports and travel 46.42 139.26 6.96 146.27 4/1/19 13:24 Credit card 216 891-58-8335 B Mandalay Member Female Sports and travel 29.61 207.27 10.36 217.63 11/3/19 15:53 Cash 217 802-43-8934 A fangon Normal Male Home and lifestyle 18.28 18.28 0.91 19.19 3/22/2019 15:05 Credit card 218 560-30-5617 B Mandalay Normal Female Sports and travel 24.77 123.85 6.19 130.04 3/24/2019 18:27 Cash 219 319-74-2561 A Yangon Member Female Electronic accessories 94.64 283.92 14.20 298.12 2/21/2019 16:55 Cash 220 549-03-9315 B Mandalay Normal Male Fashion accessories 94.87 758.96 37.95 796.91 12/2/19 12:58 Ewallet 221 790-29-1172 B Mandalay Normal Female Food and beverages 57.34 172.02 8.60 180.62 10/3/19 18:59 Credit card 222 239-36-3640 B Mandalay Normal Male Electronic accessories 45.35 272.10 13.61 285.71 1/31/2019 13:44 Ewallet 223 468-01-2051 B Mandalay Normal Male Food and beverages 62.08 434.56 21.73 156.29 6/3/19 13:46 Ewallet 224 389-25-3394 C Naypyitaw Normal Male Electronic accessories 11.81 59.05 2.95 62.00 2/17/2019 18:06 Cash 225 279-62-1445 Naypyitaw Member Female Fashion accessories 12.54 12.54 0.63 13.17 2/21/201 12:38 Cash 226 213-72-6612 A Yangon Normal Male Food and beverages 43.25 86.50 4.33 90.83 3/20/2019 15:56 Cash 227 746-68-6593 Naypyitaw Member Female Sports and travel 87.16 174.32 8.72 183.04 11/1/19 14:29 Credit card 228 836-82-5858 B Mandalay Member Male Health and beauty 69.37 624.33 31.22 655.55 1/26/2019 19:14 Ewallet 229 583-72-1480 C Naypyitaw Member Male Electronic accessories 37.06 148.24 7.41 155.6 1/31/2019 16:24 Ewallet 230 466-61-5506 B Mandalay Member Female Electronic accessories 90.70 544.20 27.21 571.41 2/26/201 10:52 Cash 231 721-86-6247 A Yangon Normal Female Home and lifestyle 63.42 507.36 25.37 532.73 11/3/19 12:55 Ewallet 232 289-65-5721 B Mandalay Normal Female Fashion accessories 81.37 162.74 8.14 170.88 1/26/201 19:28 Cash 233 545-46-3100 B Mandalay Member Female Electronic accessories 10.59 31.77 1.59 33.36 12/3/19 13:52 Credit card 234 418-02-5978 B Mandalay Normal Female Health and beauty 84.09 756.81 37.84 794.65 11/2/1 10:54 Cash 235 269-04-5750 B Mandalay Member Male Fashion accessories 73.82 295.28 14.76 310.04 2/21/201 18:31 Cash 236 157-13-5295 A fangon Member Male Health and beauty 51.94 519.40 25.97 545.37 9/3/19 18:24 Ewallet 237 645-78-8093 A fangor Normal Female Sports and travel 93.14 186.28 9.31 195.59 1/20/2019 18:09 Ewallet 238 211-30-9270 C Naypyitaw Normal Male Health and beauty 17.41 87.05 4.35 91.40 1/28/2019 15:16 Credit card 239 755-12-3214 C Naypyitaw Member Female Fashion accessories 44.22 21.10 11.06 232.16 5/3/19 17:07 Credit card 240 346-84-3103 B Mandalay Member Female Electronic accessories 13.22 66.10 3.31 69.41 2/3/19 19:26 Cash 241 478-06-7835 A fangon Normal Male Fashion accessories 89.69 89.69 4.48 94.17 11/1/19 11:20 Ewallet 242 540-11-4336 A fangor Normal Male Food and beverages 24.94 224.46 11.22 235.68 11/1/19 16:49 Credit card 243 448-81-5016 A Yangon Normal Male Health and beauty 59.77 119.54 5.98 125.52 11/3/19 12:01 Credit card 244 142-72-4741 C Naypyitaw Member Male Fashion accessories 93.20 186.4 9.32 195.72 2/28/2019 18:37 Credit card 245 217-58-1179 Yangon Member Male Home and lifestyle 62.65 250.60 12.53 263.13 5/1/19 11:25 Cash 246 376-02-8238 B Mandalay Normal Male Home and lifestyle 93.87 50.96 17.55 788.51 2/2/19 18:42 Credit card 247 530-90-9855 A fangon Member Male Home and lifestyle 47.59 380.72 19.04 399.7 1/1/19 14:47 Cash 248 866-05-7563 B Mandalay Member Female Electronic accessories 81.40 244.20 12.21 256.41 9/2/19 19:43 Cash 249 604-70-6476 Yangon Member Male Fashion accessories 17.94 89.70 4.49 94.19 1/23/2019 14:04 Ewallet 250 799-71-1548 fangon Member Male Electronic accessories 77.72 10.88 15.54 326.42 7/1/19 16:11 Credit card 251 785-13-7708 B Mandalay Normal Male Food and beverages 73.06 511.42 25.57 536.99 1/14/2019 19:06 Credit card 252 845-51-0542 B Mandalay Member Male Food and beverages 46.55 418.95 :0.95 139.90 2/2/19 15:34 Ewallet 253 662-47-5456 C Naypyitaw Member Male Fashion accessories 35.19 351.90 17.60 369.50 3/17/2019 19:06 Credit card 254 883-17-4236 C Naypvitaw Normal Female Sports and travel 14.39 28.78 1.44 30.22 2/3/19 19:44 Credit card Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male B E G 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 254 883-17-4236 C Naypyitaw Normal Female Sports and travel 14.39 28.78 1.44 30.22 2/3/19 19:44 Credit card 255 290-68-2984 A Yangon Normal Male Home and lifestyle 23.75 95.00 4.75 99.75 3/16/2019 11:22 Cash 256 704-11-6354 A Yangon Member Male Home and lifestyle 58.90 71.20 23.56 494.76 6/1/19 11:23 Cash 257 110-48-7033 B Mandalay Member Male Fashion accessories 32.62 130.48 6.52 137.00 1/29/201 14:12 Cash 258 366-93-0948 A fangon Member Male Electronic accessories 66.35 66.35 3.32 69.67 1/31/2019 10:46 Credit card 259 729-09-9681 A fangor Member Male Home and lifestyle 25.91 155.4 7.77 163.2 5/2/19 10:16 Ewallet 260 151-16-1484 A Yangon Member Male Electronic accessories 32.25 129.00 6.45 135.49 2/13/2019 12:38 Ewallet 261 380-94-4661 C Naypyitaw Member Male Electronic accessories 65.94 63.76 13.19 276.95 7/2/19 13:05 Credit card 262 850-41-9669 fangon Normal Female Electronic accessories 75.06 675.54 33.78 709.32 3/19/201 13:25 Ewallet 263 821-07-3596 Naypyitaw Normal Female Fashion accessories 16.45 65.80 3.29 69.09 7/3/19 14:53 Ewallet 264 655-85-5130 B Mandalay Member Female Fashion accessories 38.30 153.20 7.66 160.8 3/13/2019 19:22 Cash 265 447-15-7839 A Yangon Member Female Sports and travel 22.24 222.40 11.12 233.52 9/2/19 11:00 Cash 266 154-74-7179 B Mandalay Normal Male Sports and trave 54.45 54.45 2.72 57.17 2/26/2019 19:24 Ewallet 267 253-12-6086 fangon Member Female Sports and travel 98.40 588.80 34.44 723.24 12/3/15 12:43 Credit card 268 808-65-0703 Naypyitaw Normal Male Home and lifestyle 35.47 141.88 7.09 148.97 3/14/2019 17:22 Credit card 269 571-94-0759 B Mandalay Member Female Food and beverages 74.60 746.00 37.30 783.30 8/1/19 20:55 Cash 270 144-51-6085 Yangon Member Male Home and lifestyle 70.74 282.96 14.15 297.11 5/1/19 16:05 Credit card 271 731-14-2199 Yangon Member Female Home and lifestyle 35.54 355.4 7.7 373.17 4/1/19 13:34 Ewallet 272 783-09-1637 Mandalay Norma Female Sports and travel 67.43 837.15 16.86 354.01 6/3/19 18:13 Ewallet 273 687-15-1097 Naypyitaw Member Female Health and beauty 21.12 42.24 2.11 44.35 3/1/19 19:17 Cash 274 126-54-1082 A fangor Member Female Home and lifestyle 21.54 193.86 9.69 203.55 7/1/19 11:44 Credit card 275 633-91-1052 A fangor Normal Female Home and lifestyle 12.03 24.06 1.20 25.26 1/27/2019 15:51 Cash 276 477-24-6490 B Mandalay Normal Female Health and beauty 99.71 598.26 29.91 528.17 2/26/2019 16:52 Ewallet 277 566-19-5475 B Mandalay Normal Male Fashion accessories 47.97 335.79 16.79 352.58 7/1/19 0:52 Cash 278 526-86-8552 Naypyitaw Member Female Home and lifestyle 21.82 218.20 10.91 229.11 7/1/19 17:36 Cash 279 376-56-3573 Naypyitav Norma Female Fashion accessories 95.42 4 81.68 19.08 400.76 2/2/19 13:23 Ewallet 280 537-72-0426 Naypyitaw Member Male Fashion accessories 70.99 10 709.90 35.50 745.40 3/20/2019 16:28 Cash 281 828-61-5674 A Yangon Member Male Sports and travel 44.02 440.20 22.01 462.21 3/20/2019 19:57 Credit card 282 136-08-6195 fangon Normal Female Home and lifestyle 69.96 559.68 27.98 87.66 2/15/2019 17:01 Credit card 283 523-38-0215 Naypyitaw Normal Male Home and lifestyle 37.00 37.00 1.85 38.85 6/3/19 13:29 Credit card 284 490-29-1201 A fangon Normal Female Sports and travel 15.34 15.34 0.77 16.11 6/1/19 11:09 Cash 285 667-92-0055 Yangon Member Male Health and beauty 99.83 598.98 29.95 528.9 4/3/19 15:02 Ewallet 286 565-17-3836 Yangon Member Female Health and beauty 47.67 190.68 9.53 200.2 12/3/19 14:21 Cash 287 498-41-1961 B Mandalay Norma Male Health and beauty 66.68 333.40 16.67 350.07 2/20/2019 18:01 Cash 288 593-95-4461 Naypyitaw Member Male Home and lifestyle 74.86 74.86 3.74 78.60 3/24/2019 14:49 Cash 289 226-71-3580 Naypyitaw Normal Female Sports and travel 23.75 213.75 10.69 224.44 1/31/2019 12:02 Cash 290 283-79-9594 B Mandalay Normal Female Food and beverages 48.51 339.57 16.98 356.59 1/25/2019 13:30 Credit card 291 430-60-3493 Yangon Member Female Home and lifestyle 94.88 564.16 33.21 597.37 3/2/19 14:38 Cash 292 139-20-0155 B Mandalay Member Male Electronic accessories 40.30 103.00 20.15 123.15 1/24/201 17:37 Credit card 293 558-80-4082 Naypyitaw Normal Male Electronic accessories 27.85 194.95 9.75 204.70 3/14/2019 17:20 Ewallet 294 278-97-7759 A fangor Member Female Electronic accessories 62.48 62.48 3.12 65.60 2/18/2019 20:29 Cash 295 316-68-6352 A Yangon Member Female Food and beverages 36.36 72.72 3.64 76.36 1/21/2019 10:00 Cash 296 585-03-5943 Mandalay Normal Male Health and beauty 18.11 9.06 190.16 3/13/2019 11:46 Ewallet Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male E G N Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 296 585-03-5943 B Mandalay Norma Male Health and beauty 18.11 181.10 9.06 190.16 3/13/2019 11:46 Ewallet 297 211-05-0490 C Naypyitaw Member Female Electronic accessories 51.92 259.60 12.98 272.58 3/3/19 13:42 Cas 298 727-75-6477 C Naypyitaw Normal Male Electronic accessories 28.84 115.36 5.77 121.1 3/29/2019 14:44 Cash 299 744-02-5987 Yangon Member Male Home and lifestyle 78.38 170.28 23.51 493.79 10/1/19 14:16 Ewallet 300 307-83-9164 Yangon Member Male Home and lifestyle 60.01 40.04 12.00 252.0 1/25/2019 15:54 Cash 301 779-06-0012 Naypyitaw Member Female Home and lifestyle 88.61 88.61 4.43 93.04 1/19/2019 10:21 Cash 302 446-47-6729 Naypyitaw Norma Male Fashion accessories 99.82 199.64 9.98 09.62 2/1/19 18:09 Credit card 303 573-10-3877 B Mandalay Member Male Health and beauty 39.01 39.01 1.95 40.96 12/3/19 16:46 Credit card 304 735-06-4124 C Naypyitaw Normal Male Food and beverages 48.61 48.61 2.43 51.04 2/25/2019 15:31 Cash 305 439-54-7422 A Yangon Norma Female Electronic accessories 51.19 204.76 10.24 215.0 3/18/2019 17:15 Credit card 306 396-90-2219 B Mandalay Normal Female Electronic accessories 14.96 119.68 5.98 125.66 2/23/2019 12:29 Cash 307 411-77-0180 A Yangon Member Male Electronic accessories 72.20 505.40 25.27 530.67 3/26/2019 20:14 Ewallet 308 286-01-5402 A fangor Normal Female Sports and travel 40.23 281.61 14.08 295.69 3/30/2019 13:22 Cash 309 803-17-8013 Yangon Member Female Home and lifestyle 88.79 710.32 35.52 745.84 2/17/2019 17:09 Cash 310 512-98-1403 A Yangon Member Female Electronic accessories 26.48 79.44 3.97 83.41 3/21/2019 10:40 Ewallet 311 848-42-2560 A fangon Norma Female Fashion accessories 81.91 163.82 8.19 172.01 5/3/19 17:43 Cash 312 532-59-7201 B Mandalay Member Male Sports and travel 79.93 479.58 23.98 503.56 1/31/2019 14:04 Cash 313 181-94-6432 C Naypyitaw Member Male Fashion accessories 69.33 138.66 6.93 145.5 5/2/19 19:05 Ewallet 314 870-76-1733 Yangon Member Female Food and beverages 14.23 71.15 3.56 74.71 1/2/19 10:08 Credit card SNOWNOBUNGNWO 315 423-64-4619 Yangon Membe Female Health and beauty 15.55 139.95 7.00 146.95 7/3/19 13:12 Cash 316 227-07-4446 Naypyitaw Member Female Electronic accessories 78.13 781.30 39.07 820.3 10/2/19 20:51 Cash 317 174-36-3675 c Naypyitaw Member Male Food and beverages 99.37 198.74 9.94 208.68 2/14/2019 17:29 Cash 318 428-83-5800 C Naypyitav Member Female Food and beverages 21.08 63.24 3.16 66.40 9/2/1 10:25 Cash 319 603-07-0961 Naypyitaw Member Male Electronic accessories 74.79 373.95 18.70 392.65 10/1/19 1:34 Cash 320 704-20-4138 Naypyitaw Member Female Health and beauty 29.67 207.69 10.38 218.07 11/3/1 18:58 Credit card 321 787-15-1757 Naypyitaw Member Male Health and beauty 44.07 176.28 8.81 2/18/201 16:28 Ewallet 322 649-11-3678 C Naypyitaw Normal Female Food and beverages 22.93 206.37 10.32 216.69 2/26/2019 20:26 Cash 323 622-20-1945 C Naypyitaw Normal Female Health and beauty 39.42 39.42 1.97 41.39 1/18/2019 15:08 Cash 324 372-94-8041 Yangon Normal Male Health and beauty 15.26 91.56 4.58 96.14 2/15/2019 18:03 Ewallet 325 563-91-7120 Yangon Normal Female Fashion accessories 61.77 308.85 15.44 324.29 8/3/19 13:21 Cash 326 746-54-5508 A fangon Normal Male Home and lifestyle 21.52 129.12 6.46 1/17/2019 12:48 Credit card 327 276-54-0879 B Mandalay Normal Male Sports and travel 97.74 390.96 19.55 410.51 12/3/19 19:53 Ewallet 328 815-11-1168 A Yangon Member Male Food and beverages 99.78 498.90 24.95 523.85 9/3/15 19:09 Cash 329 719-76-3868 C Naypyitaw Member Male Food and beverages 94.26 377.04 18.85 395.89 12/3/19 16:30 Cash 330 730-61-8757 B Mandalay Member Male Health and beauty 51.13 204.52 10.23 214.75 1/25/2019 10:11 Credit card 331 340-66-0321 A Yangon Member Male Electronic accessories 36.36 145.44 7.27 152.71 3/25/2019 13:07 Cash 332 868-81-1752 B Mandalay Normal Male Home and lifestyle 22.02 198.18 9.91 208.09 7/2/19 18:48 Cash 333 634-97-8956 Yangon Normal Male Food and beverages 32.90 98.70 4.94 103.64 2/17/2019 17:27 Credit card 334 566-71-1091 Yangon Normal Male Fashion accessories 77.02 $85.10 19.26 104.36 3/2/19 15:59 Cash 335 442-48-3607 fangon Member Male Food and beverages 23.48 46.96 2.35 49.31 3/14/2019 11:21 Credit card 336 835-16-0096 Naypyitaw Member Male Sports and travel 14.70 73.50 3.68 77.18 3/24/2019 13:48 Ewallet 337 527-09-6272 A Yangon Member Female Electronic accessories 28.45 142.25 7.11 149.36 3/21/2019 10:17 Credit card 338 898-04-2717 A Yangon Normal Male Fashion accessories 76.40 587.60 34.38 721.98 3/19/2019 15:49 Ewallet Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Formatting as Table Format Sensitivity Styles v Filter Select Data E25 X V fx Male E G N 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 338 898-04-2717 A Yangon Normal Male Fashion accessories 76.40 687.60 34.38 721.98 3/19/2019 15:49 Ewallet 339 692-27-8933 B Mandalay Normal Female Sports and travel 57.95 347.70 17.39 365.09 2/24/2019 13:02 Cash 340 633-09-3463 C Naypyitaw Normal Female Electronic accessories $7.65 142.95 7.15 150.10 3/28/2019 12:58 Credit card 341 374-17-3652 B Mandalay Member Female Food and beverages 42.82 385.38 19.27 104.65 5/2/19 15:26 Credit card 342 378-07-7001 B Mandalay Member Male Electronic accessories 48.09 144.27 7.21 151.48 10/2/19 18:23 Credit card 343 433-75-6987 B Mandalay Member Female Health and beauty 55.97 391.79 19.59 411.38 5/3/19 19:06 Ewallet 344 873-95-4984 B Mandalay Member Female Health and beauty 76.90 538.30 26.92 565.27 2/15/2019 20:21 Cash 345 416-13-5917 C Jaypyitaw Normal Female Food and beverages 97.03 185.15 24.26 509.41 1/30/2019 16:24 Ewallet 346 150-89-8043 fangor Normal Male Sports and travel 44.65 133.95 6.70 140.65 2/14/201 15:04 Cash 347 135-84-8019 A fangon Normal Female Fashion accessories 77.93 701.37 35.07 2/27/2019 16:10 Ewallet 348 441-94-7118 A fangon Member Male Electronic accessories 71.95 71.95 3.60 75.55 4/2/19 12:14 Cash 349 725-96-3778 Naypyitaw Member Female Home and lifestyle 89.25 714.00 35.70 749.70 1/20/2019 10:13 Cash 350 531-80-1784 Yangon Normal Male Electronic accessories 26.02 182.14 9.11 191.25 3/28/2019 17:38 Cash 351 400-45-1220 B Mandalay Normal Female Health and beauty 13.50 10 135.00 6.75 141.75 2/27/2015 11:06 Credit card 352 860-79-0874 C Naypyitaw Member Female Fashion accessories 99.30 10 993.00 49.65 1,042.65 2/15/2019 14:53 Credit card 353 834-61-8124 A fangon Norma Male Electronic accessories 51.69 361.83 18.09 379.92 1/26/2019 18:22 Cash 354 115-99-4379 B Mandalay Member Female Fashion accessories 54.73 383.11 19.16 402.27 3/14/2019 19:02 Credit card 355 565-67-6697 B Mandalay Member Male Home and lifestyle 27.00 243.0 12.15 255.15 2/3/19 14:16 Cash 356 320-49-6392 Naypyitav Norma Female Electronic accessories 30.24 30.24 1.51 31.75 4/3/19 15:44 Cash 357 889-04-9723 B Mandalay Member Female Food and beverages 89.14 356.56 17.83 374.39 7/1/19 12:20 Credit card 358 632-90-0281 C Naypyitav Normal Female Fashion accessories 37.55 375.5 18.78 394.28 8/3/19 20:01 Credit card 359 554-42-2417 Naypyitaw Normal Female Sports and travel 95.44 954.40 $7.72 1,002.12 9/1/19 13:45 Cash 360 453-63-6187 B Mandalay Normal Male Electronic accessories 27.50 C N DO CO WO O A B U 82.50 4.13 86.63 1/3/19 15:40 Ewallet 361 578-80-7669 B Mandalay Normal Male Sports and travel 74.97 74.97 3.75 78.72 3/16/2019 16:58 Cash 362 612-36-5536 A Yangon Member Male Food and beverages 80.96 ;47.68 32.38 580.06 2/17/2019 11:12 Credit card 363 605-72-4132 C Naypyitaw Normal Female Food and beverages 94.47 755.76 37.79 793.55 2/27/2019 15:12 Cash 364 471-41-2823 Naypyitaw Normal Male Food and beverages 99.79 199.58 9.98 209.56 7/3/19 20:37 Ewallet 365 462-67-9126 Yangon Normal Male Home and lifestyle 73.22 439.32 21.97 61.29 1/21/2019 17:44 Cash 366 272-27-9238 Naypyitaw Normal Female Food and beverages 41.24 164.96 8.25 173.21 2/19/201 16:23 Cash 367 834-25-9262 Naypyitaw Normal Female Fashion accessories 81.68 326.72 16.34 343.06 6/1/19 12:12 Cash 368 122-61-9553 Naypyitaw Normal Female Electronic accessories 51.32 161.88 23.09 184.97 3/14/2019 19:33 Cash 369 468-88-0009 A Yangon Member Male Home and lifestyle 65.94 263.76 13.19 276.9 3/24/2019 10:29 Cash 370 613-59-9758 C Naypyitaw Normal Female Sports and travel 14.36 143.60 7.18 150.78 1/27/2019 14:28 Cash 371 254-31-0042 Yangon Member Male Electronic accessories 21.50 193.50 9.68 203.18 6/3/19 12:46 Credit card 372 201-86-2184 B Mandalay Member Female Electronic accessories 26.26 183.82 9.19 2/2/19 19:40 Cash 373 261-12-8671 B Mandalay Normal Female Fashion accessories 60.96 121.92 6.10 128.02 1/25/2019 19:39 Credit card 374 730-70-9830 C Naypyitaw Normal Female Home and lifestyle 70.11 420.66 21.03 441.69 3/14/2019 17:54 Ewallet 375 382-25-8917 C Naypyitaw Normal Male Fashion accessories 42.08 252.48 12.6. 265.10 1/29/2019 12:25 Cash 376 422-29-8786 fangor Normal Female Home and lifestyle 67.09 335.45 16.77 352.22 3/1/19 16:47 Credit card 377 667-23-5919 A Yangon Member Female Fashion accessories 96.70 483.50 4.18 507.68 1/14/2019 12:52 Ewallet 378 843-01-4703 B Mandalay Member Female Home and lifestyle 35.38 318.42 15.92 34.34 5/1/19 19:50 Credit card 379 743-88-1662 C Naypyitaw Normal Male Sports and travel 95.49 568.43 33.42 701.85 2/22/2019 18:17 Ewallet 380 595-86-2894 C Naypvitaw Member Male Fashion accessories 96.98 387.92 19.40 407.32 6/2/19 17:20 Ewallet Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v ZAY - O. Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male B E G N 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 380 595-86-2894 C Naypyitaw Member Male Fashion accessories 96.98 387.92 19.40 107.32 6/2/19 17:20 Ewallet 381 182-69-8360 B Mandalay Normal Female Electronic accessories 23.65 94.60 4.73 99.33 1/30/2019 13:32 Credit card 382 289-15-7034 A Yangon Member Male Sports and travel 82.33 329.32 16.47 345.79 11/1/19 10:37 Credit card 383 462-78-5240 Naypyitaw Norma Female Electronic accessories 26.61 53.22 2.66 55.88 3/19/201 14:35 Cas 384 868-52-7573 B Mandalay Normal Female Food and beverages 99.69 498.45 24.92 523.37 1/14/2019 12:09 Cash 385 153-58-4872 C Naypyitaw Member Female Food and beverages 74.89 99.56 14.98 314.54 1/3/19 15:32 Ewallet 386 662-72-2873 Yangon Normal Female Food and beverages 40.94 204.70 10.24 214.9 6/1/19 13:58 Ewallet 387 525-88-7307 B Mandalay Member Male Sports and travel 75.82 75.82 3.79 79.61 1/31/2019 13:19 Cash 388 689-16-9784 Naypyitaw Norma Male Food and beverages 46.77 280.62 14.03 294.65 11/3/19 13:37 Cash 389 725-56-0833 A Yangon Normal Female Health and beauty 32.32 323.20 16.16 339.36 2/20/2019 16:49 Credit card 390 394-41-0748 C Naypyitaw Member Female Fashion accessories 54.07 486.63 24.33 510.96 1/27/2019 14:55 Ewallet 391 596-42-3999 B Mandalay Normal Male Food and beverages 18.22 127.54 6.38 133.9 10/3/19 14:04 Credit card 392 541-89-9860 C Naypyitaw Member Female Fashion accessories 80.48 241.4 2.0 253.51 2/15/2019 12:31 Cash 393 173-82-9529 B Mandalay Norma Female Fashion accessories 37.95 379.50 18.98 398.48 1/26/201 14:51 Cash 394 563-36-9814 A fangon Member Male Electronic accessories 76.82 76.82 3.84 80.66 2/13/2019 18:27 Ewallet 395 308-47-4913 A angon Member Female Sports and travel 52.26 522.6 26.13 548.73 9/3/19 12:45 Credit card 396 885-17-6250 Yangon Normal Female Health and beauty 79.74 79.74 3.99 83.73 6/3/19 10:36 Ewallet 397 726-27-2396 Yangon Normal Female Health and beauty 77.50 387.50 19.38 406.88 1/24/2019 0:36 Ewallet 398 316-01-3952 fangon Normal Female Food and beverages 54.27 271.35 13.57 284.92 3/13/201 14:16 Ewallet 399 760-54-1821 Mandalay Normal Male Home and lifestyle 13.59 122.31 6.12 128.43 3/15/2019 10:26 Cash 400 793-10-3222 B Mandalay Member Female Health and beauty 41.06 246.36 12.32 258.68 5/3/19 13:30 Credit card 401 346-12-3257 B Mandalay Member Male Electronic accessories 19.24 173.16 8.66 181.82 4/3/19 16:28 Cash 402 110-05-6330 c Naypyitaw Normal Female Food and beverages 39.43 236.58 11.83 248.41 3/25/2019 20:18 Credit card 403 651-61-0874 Naypyitaw Norma Male Home and lifestyle 46.22 184.88 9.24 194.12 12/3/19 20:04 Credit card 404 236-86-3015 Naypyitaw Member Male Home and lifestyle 13.98 13.98 0.70 14.68 4/2/19 13:38 Ewallet 405 831-64-0259 Mandalay Norma Female Fashion accessories 39.75 198.75 9.94 208.69 2/22/2019 10:43 Ewallet 406 587-03-7455 Naypyitaw Member Female Fashion accessories 97.79 684.53 34.23 718.76 2/16/2019 17:30 Ewallet 107 882-40-4577 Yangon Member Male Sports and travel 57.26 269.04 13.45 282.49 1/19/2019 15:28 Credit card 408 732-67-5346 fangon Norma Male Food and beverages 13.79 68.95 3.45 72.40 11/1/1 19:07 Credit card 409 725-32-9708 B Mandalay Member Female Fashion accessories 68.71 274.84 13.74 288.58 4/1/19 19:01 Cash 410 256-08-8343 A fangon Normal Female Home and lifestyle 56.53 226.12 11.31 237.43 4/3/19 19:48 Ewallet 411 372-26-1506 C Naypyitaw Normal Female Fashion accessories 23.82 119.10 5.96 125.06 1/28/2019 19:24 Ewallet 412 244-08-0162 B Mandalay Normal Female Health and beauty 34.21 $42.10 17.11 359.21 2/1/19 13:00 Cash 413 569-71-4390 B Mandalay Normal Male Sports and travel 21.87 43.74 2.19 45.93 1/25/2019 14:29 Ewallet HOWUNOUT A 414 132-23-6451 A fangon Member Male Health and beauty 20.97 104.85 5.24 110.09 4/1/19 13:21 Cash 415 696-90-2548 A fangor Normal Male Sports and travel 25.84 77.52 3.88 81.40 10/3/19 18:55 Ewallet 416 472-15-9636 A Yangon Normal Male Home and lifestyle 50.93 407.44 10.37 427.81 3/22/2019 19:36 Ewallet 417 268-03-6164 B Mandalay Normal Male Health and beauty 96.11 96.11 4.81 100.92 1/25/2019 16:28 Ewallet 418 750-57-9686 Naypyitaw Normal Female Home and lifestyle 45.38 181.52 9.08 190.60 8/1/19 13:48 Credit card 419 186-09-3669 Naypyitaw Member Female Health and beauty 81.51 81.51 4.08 85.59 1/22/2019 10:57 Ewallet 420 848-07-1692 B Mandalay Normal Female Health and beauty 57.22 114.44 5.72 120.16 12/1/19 17:13 Ewallet 421 745-71-3520 A Yangon Member Female Electronic accessories 25.22 176.5 8.83 185.37 4/2/19 10:23 Cash 422 266-76-6436 C Naypvitaw Member Female Food and beverages 38.60 15.80 5.79 121.59 3/28/2019 13:57 Ewallet Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male B E G 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 122 266-76-6436 C Naypyitaw Member Female Food and beverages 38.60 115.80 5.79 121.59 3/28/2019 13:57 Ewallet 423 740-22-2500 C Naypyitaw Normal Female Electronic accessories 84.05 252.15 12.61 264.76 1/23/2019 13:29 Cash 424 271-88-8734 C Naypyitaw Member Female Fashion accessories 7.21 72.10 18.6 1,020.71 8/2/19 13:00 Credit card 125 301-81-8610 B Mandalay Member Male Fashion accessories 25.42 03.36 10.17 213.53 3/19/2019 19:42 Credit card 126 489-64-4354 Naypyitaw Normal Male Fashion accessories 16.28 16.28 0.81 17.09 9/3/19 15:36 Cash 427 198-84-7132 B Mandalay Member Male Fashion accessories 40.61 365.4 18.27 383.76 2/1/19 13:40 Cash 428 269-10-8440 A Yangon Member Male Health and beauty 53.17 372.19 18.61 390.80 1/21/2019 18:01 Cash 429 650-98-6268 B Mandalay Member Female Food and beverages 20.87 62.61 3.13 65.74 3/20/2019 13:53 Credit card $30 741-73-3559 Mandalay Norma Male Sports and travel 67.27 836.35 16.82 353.17 2/27/2019 17:27 Cash 431 325-77-6186 A Yangon Member Female Home and lifestyle 90.65 906.50 15.33 951.83 8/3/19 10:53 Ewallet 432 286-75-7818 B Mandalay Normal Male Fashion accessories 69.08 138.16 6.91 145.07 1/31/2019 19:48 Credit card 433 574-57-9721 Naypyitaw Normal Male Food and beverages 43.27 86.54 1.33 90.87 8/3/19 16:53 Ewallet 434 459-50-7686 Yangon Normal Female Electronic accessories 23.46 140.76 7.04 147.80 1/13/201 19:14 Ewallet 435 616-87-0016 B Mandalay Normal Male Fashion accessories 95.54 568.78 33.44 702.22 9/3/15 14:36 Credit card 436 837-55-7229 B Mandalay Normal Female Fashion accessories 47.44 47.44 2.37 49.81 2/22/2019 18:19 Credit card 437 751-69-0068 C Naypyitaw Normal Male Sports and trave 99.24 393.16 14.6 937.82 3/19/2019 19:09 Ewallet 438 257-73-1380 Naypyitaw Member Male Sports and travel 82.93 331.72 16.59 348.31 1/20/2019 16:51 Ewallet 439 345-08-4992 rangon Normal Male Home and lifestyle 33.99 203.94 0.20 214.14 8/3/19 15:37 Credit card 440 549-96-4200 Naypyitaw Member Male Food and beverages 17.04 68.16 3.41 71.57 8/3/19 10:15 Ewallet 441 810-60-6344 Naypyitaw Normal Female Electronic accessories 40.86 326.88 16.34 343.22 7/2/19 14:38 Credit card 442 450-28-2866 Naypyitaw Member Male Food and beverages 17.44 87.20 4.36 91.56 1/15/2019 19:25 Cash 443 394-30-3170 B Mandalay Member Female Sports and travel 88.43 707.44 35.37 742.81 3/22/2019 19:35 Credit card 444 138-17-5109 Yangon Member Female Home and lifestyle 89.21 302.89 40.14 343.0 1/15/2019 15:42 Credit card 445 192-98-7397 Naypyitaw Norma Male Fashion accessories 12.78 12.78 0.64 13.42 8/1/19 14:11 Ewallet 446 301-11-9629 A Yangon Normal Female Sports and travel 19.10 133.70 6.69 140.39 1/15/2019 10:43 Cash 147 390-80-5128 B Mandalay Member Female Health and beauty 19.15 19.15 0.96 20.11 1/28/2019 17:58 Credit card 448 235-46-8343 c Naypyitaw Member Male Food and beverages 27.66 276.60 13.83 290.43 2/14/2019 11:26 Credit card 449 453-12-7053 C Naypyitaw Normal Male Fashion accessories 45.74 137.22 6.86 144.08 10/3/1 17:38 Credit card 450 296-11-7041 B Mandalay Member Female Health and beauty 27.07 27.07 1.35 28.42 2/1/19 20:07 Credit card 451 449-27-2918 B Mandalay Member Female Sports and travel 39.12 39.12 1.96 41.08 3/26/2019 11:02 Credit card 452 891-01-7034 B Mandalay Normal Female Electronic accessories 74.71 148.26 22.41 470.67 1/1/19 19:07 Cash 453 744-09-5786 B Mandalay Normal Male Electronic accessories 22.01 132.06 6.60 138.6 2/1/19 18:50 Cash 154 727-17-0390 Yangon Normal Female Food and beverages 63.61 18.0 15.90 33.9 3/16/2019 12:43 Ewallet 455 568-88-3448 fangon Normal Male Health and beauty 25.00 25.00 1.25 26.25 3/3/19 15:09 Ewallet 456 187-83-5490 A Yangon Member Male Electronic accessories 20.77 83.08 4.15 87.23 1/31/2019 13:47 Cash 457 767-54-1907 B Mandalay Member Female Fashion accessories 29.56 147.80 7.39 155.19 2/13/2019 16:59 Cash 458 710-46-4433 B Mandalay Member Female Food and beverages 77.40 596.60 34.83 731.43 2/15/2019 14:15 Credit card 459 533-33-5337 B Mandalay Normal Male Electronic accessories 79.39 793.90 39.70 833.60 7/2/19 20:24 Cash 460 325-90-8763 Naypyitaw Member Female Electronic accessories 46.57 465.70 23.29 188.99 1/27/201 13:58 Cash 461 729-46-7422 Naypyitaw Normal Male Food and beverages 35.89 35.89 1.79 37.68 2/23/2019 16:52 Credit card 462 639-76-1242 Naypyitaw Normal Male Food and beverages 40.52 202.6 10.13 212.73 3/2/19 15:19 Cash 463 234-03-4040 B Mandalay Member Female Food and beverages 73.05 730.50 36.53 767.03 3/3/15 12:25 Credit card 464 326-71-2155 C Naypvitaw Normal Female Sports and travel 73.95 95.80 14.79 310.59 3/2/19 10:02 Cash Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments ap Wrap Text v General Insert v Calibri (Body) * 11 AA Ex Delete Paste BIUV CvAv E Merge & Centre v ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male E G N B 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 464 326-71-2155 C Naypyitaw Norma Female Sports and travel 73.95 95.80 14.79 310.59 3/2/19 10:02 Cash 465 320-32-8842 c Naypyitaw Member Female Food and beverages 22.62 22.62 1.13 23.75 3/17/2019 18:58 Cash 466 470-32-9057 A Yangon Member Male Food and beverages 51.34 256.7 12.84 269.5 3/28/2019 15:31 Credit card 467 878-30-2331 C Naypyitaw Member Female Sports and travel 54.55 $45.50 27.28 $72.78 2/3/19 11:22 Credit card 468 440-59-5691 Naypyitaw Member Female Health and beauty 37.15 260.05 13.00 73.05 8/2/19 13:12 Credit card 469 554-53-3790 B Mandalay Normal Male Sports and travel 37.02 22.12 11.11 3/22/2019 18:33 Cash 470 746-19-0921 C Naypyitaw Normal Male Food and beverages 21.58 21.58 1.08 22.66 9/2/19 10:02 Ewallet 471 233-34-0817 C Naypyitaw Member Female Electronic accessories 98.84 98.84 4.94 103.78 2/15/201 1:21 Cash 472 767-05-1286 Naypyitaw Member Female Home and lifestyle 83.77 502.62 25.13 $27.75 1/23/2019 12:10 Ewallet 173 340-21-9136 A Yangor Member Female Sports and travel 40.05 160.2 8.01 168.21 1/25/2019 11:40 Cash 474 405-31-3305 A Yangon Member Male Fashion accessories 43.13 21.57 152.87 2/2/19 18:31 Credit card 475 731-59-7531 B Mandalay Member Male Health and beauty 72.57 580.56 29.03 509.5 3/30/2019 17:58 Cash 476 676-39-6028 A Yangon Member Female Electronic accessories 64.44 322.20 16.11 338.31 3/30/2019 17:04 Cash 477 502-05-1910 Yangon Normal Male Health and beauty 65.18 195.54 3.78 205.37 2/25/2019 20:35 Credit card 478 485-30-8700 fangon Norma Female Sports and travel 33.26 166.3 8.32 174.62 3/18/2019 16:10 Credit card 479 598-47-9715 Naypyitaw Normal Male Electronic accessories 84.07 336.28 16.81 353.09 7/3/19 16:54 Ewallet 480 701-69-8742 B Mandalay Normal Male Sports and travel 34.37 343.70 17.19 360.89 3/16/2019 10:11 Ewallet 481 575-67-1508 A Yangon Normal Male Electronic accessories 38.60 38.60 1.93 40.53 1/29/2019 1:26 Ewallet 482 541-08-3113 C Naypyitaw Normal Male Food and beverages 65.97 527.76 26.39 554.15 2/2/19 20:29 Cash 483 246-11-3901 Naypyitaw Norma Female Electronic accessories 32.80 328.00 16.40 344.40 2/15/2019 12:12 Cash 484 674-15-9296 A Yangon Normal Male Sports and travel 37.14 185.70 9.29 194.9 8/1/19 13:05 Ewallet 485 305-18-3552 B Mandalay Member Male Home and lifestyle 60.38 603.80 30.19 633.99 12/2/19 16:19 Cash 486 493-65-6248 C Naypyitaw Member Female Sports and travel 36.98 10 369.80 18.49 388.29 1/1/19 19:48 Credit card 487 438-01-4015 B Mandalay Member Female Sports and travel 49.49 197.96 9.90 207.86 3/21/2019 15:25 Ewallet 488 709-58-4068 B Mandalay Norma Female Fashion accessories 41.09 10.90 20.55 131.4 2/28/201 14:42 Cash 489 795-49-7276 A Yangon Normal Male Fashion accessories 37.15 148.60 7.43 156.03 3/23/2019 18:59 Ewallet 490 556-72-8512 C Naypyitaw Normal Male Home and lifestyle 22.96 22.96 1.15 24.11 1/30/2019 20:47 Cash 491 627-95-3243 B Mandalay Member Female Home and lifestyle 77.68 599.12 34.96 734.08 4/2/19 13:21 Ewallet 492 686-41-0932 B Mandalay Normal Female Fashion accessories 34.70 69.40 3.47 72.87 3/13/2019 19:48 Ewallet 493 510-09-5628 Yangon Member Female Fashion accessories 19.66 196.60 9.83 206.43 3/15/2019 18:20 Credit card ONCONOCO NUMA O 494 608-04-3797 B Mandalay Member Female Health and beauty 25.32 202.56 10.13 212.69 5/3/19 20:24 Ewallet 495 148-82-2527 C Naypyitaw Member Female Home and lifestyle 12.12 121.20 6.06 127.26 5/3/19 13:44 Credit card 496 437-53-3084 B Mandalay Normal Male Fashion accessories 99.89 199.78 9.99 209.7 2/26/201 11:48 Ewallet 497 632-32-4574 B Mandalay Normal Male Sports and travel 75.92 507.36 30.37 537.7 3/20/2019 14:14 Cash 498 556-97-7101 Naypyitaw Norma Female Electronic accessories 63.22 126.4 6.32 132.76 1/1/15 15:51 Cash 499 862-59-8517 Naypyitaw Normal Female Food and beverages 90.24 541.44 27.07 568.51 1/27/2019 11:17 Cash 500 401-18-8016 B Mandalay Member Female Sports and travel 98.13 98.13 4.91 103.04 1/21/2019 17:36 Cash 501 420-18-8989 A fangon Member Female Sports and trave 51.52 12.16 20.61 132.77 2/2/1 15:47 Cash 502 277-63-2961 B Mandalay Member Male Sports and travel 73.97 73.97 3.70 77.67 3/2/19 15:53 Credit card NNPROP 503 573-98-8548 Naypyitaw Member Female Fashion accessories 31.90 31.90 1.60 33.50 5/1/19 12:40 Ewallet 504 620-02-2046 Naypyitaw Normal Male Home and lifestyle 69.40 138.8 6.94 145.74 1/27/2019 19:48 Ewallet 505 282-35-2475 B Mandalay Normal Female Sports and travel 93.31 186.62 9.33 195.95 3/25/2019 17:53 Cash 506 511-54-3087 Mandalay Normal Male Sports and travel 88.45 88.45 4.42 92.87 2/25/2019 16:36 Credit card Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre v ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male B E
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started