Balwinder Kalra

OrderDate Sales (Units*Cost) Unit Cost (Rounded) Replaced Text Day of week 6,500.45 13000.9 6,500.45 - - Matthew Alex Andrews Andrews Andrews Andrews Alex Alex Andrews Alex Matthew Andrews Alex Alex Andrews Andrews Alex Andrews Alex Andrews Andrews Matthew Matthew Alex Andrews Matthew Matthew Andrews Alex Matthew Alex Matthew Alex Andrews Matthew Matthew Andrews Matthew Alex Andrews Alex Alex Andrews Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Region Rep Item Units Unit Cost 9-1-18 North David Desk 2 9-2-18 South Alex Desk 5 9-3-18 South Andrews Pencil 7 2.15 15.05 9-4-18 South Andrews Binder 11 250.76 2758.36 9-5-18 South Andrews Pencil 14 2.15 30.1 9-6-18 North Andrews Pen 27 20.67 558.09 9-7-18 South Alex Binder 28 250.76 7021.28 9-8-18 East Alex Binder 28 250.76 7021.28 9-9-18 East Andrews Pencil 36 2.15 77.4 9-10-18 East Alex Pen Set 42 15.98 671.16 9-11-18 North David Binder 46 250.76 - 9-12-18 East Andrews Binder 50 250.76 12538 9-13-18 East Alex Pen Set 50 15.98 799 9-14-18 South Alex Pencil 53 2.15 113.95 9-15-18 North Andrews Pen Set 55 15.98 878.9 9-16-18 East Andrews Pencil 66 2.15 141.9 9-17-18 West Alex Pencil 67 2.15 144.05 9-18-18 West Andrews Pencil 75 2.15 161.25 9-19-18 North Alex Binder 80 250.76 20060.8 9-20-18 West Andrews Binder 87 250.76 - 9-21-18 South Andrews Pencil 90 2.15 193.5 9-22-18 West David Pencil 90 2.15 193.5 9-23-18 East David Binder 94 250.76 - 9-24-18 North Alex Pen Set 96 15.98 1534.08 9-25-18 North Andrews Binder 4 250.76 1003.04 9-26-18 North David Pen 15 20.67 310.05 9-27-18 East David Pen Set 16 15.98 255.68 9-28-18 East Andrews Binder 29 250.76 7272.04 9-29-18 East Alex Pencil 35 2.15 75.25 9-30-18 North David Binder 60 250.76 15045.6 10-1-18 East Alex Binder 60 250.76 15045.6 10-2-18 East David Pen Set 62 15.98 990.76 10-3-18 East Alex Pen 64 20.67 1322.88 10-4-18 East Andrews Pen Set 74 15.98 1182.52 10-5-18 East David Binder 81 250.76 - 10-6-18 East David Pencil 95 2.15 204.25 10-7-18 North Andrews Pen 96 20.67 1984.32 10-8-18 West David Desk 3 6,500.45 - 10-9-18 West Alex Binder 7 250.76 1755.32 10-10-18 West Andrews Pencil 32 2.15 68.8 10-11-18 North Alex Pencil 56 2.15 120.4 10-12-18 North Alex Binder 57 250.76 - 10-13-18 West Andrews Pen 76 20.67 1570.92 Serial Number Tasks Output 1 Find the sum of total sales made so far - 2 Find the sum of total sales made only by David using the sum if formula - 3 Count the number of sales made only by Alex using the count if formula 15 4 Find the average number of Pencils sold so far 5 Find the number of working days during which the sales happened 6 Using Vlookup formula find the item sold on September 18 7 What is the maximum and minimum number of units sold so far 8 Round the number of digits in column F to single digit 9 Replace the name David with Mathew using the replace formula 10 Using the date column(A)\, find the day in which the sales happened - Pencil 96 2 Refer column H in the above table Refer column I in the above table Refer column J in the above table