Question: what is the difference between average and percentage in excel?
Answer: Average in simple terms is sum of all products/ values divided by no of items/product. Percentage share of Apple will be- 4/10*100 which is 40% , so 60 % price is of mangoes and 40 % is of apples. Hope you have understood the difference.