Please review the Excel file below to answer the question and perform it by MS:

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
750-67-8428	A	Yangon	Member	Female	Health and beauty	74.69	7	522.83	26.14	548.97	1/05/2019	13:08	Ewallet
226-31-3081	C	Naypyitaw	Normal	Female	Electronic accessories	15.28	5	76.40	3.82	80.22	3/08/2019	10:29	Cash
631-41-3108	A	Yangon	Normal	Male	Home and lifestyle	46.33	7	324.31	16.22	340.53	3/03/2019	13:23	Credit card
123-19-1176	A	Yangon	Member	Male	Health and beauty	58.22	8	465.76	23.29	489.05	1/27/2019	20:33	Ewallet
373-73-7910	A	Yangon	Normal	Male	Sports and travel	86.31	7	604.17	30.21	634.38	2/08/2019	10:37	Ewallet
699-14-3026	C	Naypyitaw	Normal	Male	Electronic accessories	85.39	7	597.73	29.89	627.62	3/25/2019	18:30	Ewallet
355-53-5943	A	Yangon	Member	Female	Electronic accessories	68.84	6	413.04	20.65	433.69	2/25/2019	14:36	Ewallet
315-22-5665	C	Naypyitaw	Normal	Female	Home and lifestyle	73.56	10	735.60	36.78	772.38	2/24/2019	11:38	Ewallet
665-32-9167	A	Yangon	Member	Female	Health and beauty	36.26	2	72.52	3.63	76.15	1/10/2019	17:15	Credit card
692-92-5582	B	Mandalay	Member	Female	Food and beverages	54.84	3	164.52	8.23	172.75	2/20/2019	13:27	Credit card
351-62-0822	B	Mandalay	Member	Female	Fashion accessories	14.48	4	57.92	2.90	60.82	2/06/2019	18:07	Ewallet
529-56-3974	B	Mandalay	Member	Male	Electronic accessories	25.51	4	102.04	5.10	107.14	3/09/2019	17:03	Cash
365-64-0515	A	Yangon	Normal	Female	Electronic accessories	46.95	5	234.75	11.74	246.49	2/12/2019	10:25	Ewallet
252-56-2699	A	Yangon	Normal	Male	Food and beverages	43.19	10	431.90	21.60	453.50	2/07/2019	16:48	Ewallet
829-34-3910	A	Yangon	Normal	Female	Health and beauty	71.38	10	713.80	35.69	749.49	3/29/2019	19:21	Cash
299-46-1805	B	Mandalay	Member	Female	Sports and travel	93.72	6	562.32	28.12	590.44	1/15/2019	16:19	Cash
656-95-9349	A	Yangon	Member	Female	Health and beauty	68.93	7	482.51	24.13	506.64	3/11/2019	11:03	Credit card
765-26-6951	A	Yangon	Normal	Male	Sports and travel	72.61	6	435.66	21.78	457.44	1/01/2019	10:39	Credit card
329-62-1586	A	Yangon	Normal	Male	Food and beverages	54.67	3	164.01	8.20	172.21	1/21/2019	18:00	Credit card
319-50-3348	B	Mandalay	Normal	Female	Home and lifestyle	40.30	2	80.60	4.03	84.63	3/11/2019	15:30	Ewallet
300-71-4605	C	Naypyitaw	Member	Male	Electronic accessories	86.04	5	430.20	21.51	451.71	2/25/2019	11:24	Ewallet
371-85-5789	B	Mandalay	Normal	Male	Health and beauty	87.98	3	263.94	13.20	277.14	3/05/2019	10:40	Ewallet
273-16-6619	B	Mandalay	Normal	Male	Home and lifestyle	33.20	2	66.40	3.32	69.72	3/15/2019	12:20	Credit card
636-48-8204	A	Yangon	Normal	Male	Electronic accessories	34.56	5	172.80	8.64	181.44	2/17/2019	11:15	Ewallet
549-59-1358	A	Yangon	Member	Male	Sports and travel	88.63	3	265.89	13.29	279.18	3/02/2019	17:36	Ewallet
227-03-5010	A	Yangon	Member	Female	Home and lifestyle	52.59	8	420.72	21.04	441.76	3/22/2019	19:20	Credit card
649-29-6775	B	Mandalay	Normal	Male	Fashion accessories	33.52	1	33.52	1.68	35.20	2/08/2019	15:31	Cash
189-17-4241	A	Yangon	Normal	Female	Fashion accessories	87.67	2	175.34	8.77	184.11	3/10/2019	12:17	Credit card
145-94-9061	B	Mandalay	Normal	Female	Food and beverages	88.36	5	441.80	22.09	463.89	1/25/2019	19:48	Cash
848-62-7243	A	Yangon	Normal	Male	Health and beauty	24.89	9	224.01	11.20	235.21	3/15/2019	15:36	Cash
871-79-8483	B	Mandalay	Normal	Male	Fashion accessories	94.13	5	470.65	23.53	494.18	2/25/2019	19:39	Credit card
149-71-6266	B	Mandalay	Member	Male	Sports and travel	78.07	9	702.63	35.13	737.76	1/28/2019	12:43	Cash
640-49-2076	B	Mandalay	Normal	Male	Sports and travel	83.78	8	670.24	33.51	703.75	1/10/2019	14:49	Cash
595-11-5460	A	Yangon	Normal	Male	Health and beauty	96.58	2	193.16	9.66	202.82	3/15/2019	10:12	Credit card

1. In the MS Excel provided, graphically illustrate the number of female and male customers. Name your graph Task 1.1. Provide a brief explanation on your observation.

2. In the MS Excel provided, graphically illustrate which payment methods are more common amongst female customers versus male customers. Name your graph Task 1.2 Provide a brief explanation on your observation.

3. In the MS Excel provided, graphically illustrate which products are more common amongst women customers versus male customers. You are required to graphically compare the quantity of products purchased by female customers versus male customers. Name your graph Task 1.3. Provide a brief explanation on your observation.

4. In the MS Excel provided, graphically illustrate that in which city female customers purchase the highest number of food and beverages products? Name your graph Task 1.4. Provide a brief explanation on your observation.

5. In the MS Excel provided, graphically illustrate that in which city male customers purchase the highest number of health and beauty products? Name your graph Task 1.5. Provide a brief explanation on your observation.

6. In the MS Excel provided, graphically illustrate the sales revenue that the sale of each product provides to Walmart Myanmar. Which product provides the highest sales revenue, and which one provides the lowest sales revenue? Name your graph Task 1.6. Provide a brief explanation on your observation.

7. In the MS Excel provided, graphically illustrate that for the purchase of which product female customers mainly used cash, and for the purchase of which product female customers mainly used Ewallet? Name your graph Task 1.7. Provide a brief explanation on your observation.

8. In the MS Excel provided, graphically illustrate that for the purchase of which product male customers mainly used Ewallet, and for the purchase of which product male customers mainly used cash? Name your graph Task 1.8. Provide a brief explanation on your observation.

9. In the MS Excel provided, graphically illustrate the sales revenue made by each branch. Illustrate that which branch made the highest sales revenue? Name your graph Task 1.9. Provide a brief explanation on your observation.

10. In the MS Excel provided, graphically illustrate the top five best selling products by quantity of those products in Mandalay city. Name your graph Task 1.10. Provide a brief explanation on your observation.