How can I use excel to solve the following questions? What formulas should I use?

a.)How many dresses were sold in Paris?

b.)What are the total sales of accessories USD?

c.)What items were sold on May 2, 2015?

d.)Which item had the lowest sales?

e.)What was the sales amount of all clothing in Milan in USD?

Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments = = = E * E 25 wrup Text Emerge & Center w General $ % A B 2 mert v E Calibri (Body) - 12 v A A BLUE - A E x fx y O 3 FOOD Cell Styles Delete 1! Format Conditional Format Formatting as Table 2 Filter ideas Sensitivity Paste 118 X v M N O P Q 1 Onder 21 4 3 Location London London London Milan London Milan Questions a) How many dresses were sold in Paris? b) Total salos of orice in USD c) What items were sold on May 2, 2015? d which item had the lowest sales c) What was the sales amount of all clothing in Milan in USD? 26 $504 SHE 12 Clothing 2019 2120 ANNERS Product Category Dress Clothing Suits Clothing Sunglasses Accessories Sunglasses Accessories Jeans Clothing Bag Accessories Suits Clothing Sunglasses Accessaries Shoes Accessories ossaries Shoes Accessories Sunglasses Accessories Suits Clothing Dress Clothing Suits Shoes Accessories Sunglasses Accessories Sunglasses Accessories Sunglasses Accessories Suits Clothing Shacs Accessories Bae Accessories Sunglasses Accessaries Sunglasses Accessories Sunglasses Accessories Jeans Clothing Dress Clothin Hat Accessories Jeans Clothine Jeans Clothing Shoes Accessories Accesta Hat Accessories Shoes Accessories Shoes Accessories Suits Clothing Shoes Accessories Shoes Accessories Shoes Accessories Dress Clothing Sunglasses Accessories Sunglasses Accessories Amount $571 8/9/15 $737 5/2/15 $1,7458 /30/15 $383 17/12/15 $520 6/2/15 5269 1/22/15 $1.242 10/5/15 $305 8/25/15 12/28/15 $1,785 6/25/15 6/1/15 $1.956 9/22/15 6/7/15 $1.775 5/1/15 $728 8/26/15 $439 2/8/15 $1,446 7 /28/15 $1,487 7/3/15 $8957 /31/15 $1,986 9/15/15 $783 8/20/15 $899 8/25/15 $1,115 $1,329 7/8/15 $1,391 9 /7/15 $1.533 5/16/15 11/9/15 $937 6/28/15 $252 10/22/15 $313 3/17/15 $1.995 9/14/15 $581 7/6/15 $1.394 9/24/15 $1.60G 1/14/15 $1.938 10/30/15 $220 4/30/15 $712 5/17/15 $1.185 5 /7/15 $1,089 7/5/15 $481 2 /14/15 Paris Milan Milan london Londor Milan Milan Milan Milan Milan Milan Londor Milan Paris Paris London Milan Parts Paris Milan Milan London Milan London London London Paris London London London Milan Parls Milan 3938 40 39 40