Please answer using Excel and show your work (ie the functions used)

A bike company receives bike orders every week and fulfills them according to order's type. The following table shows frequency and price of the company's products. a) Assuming each order is for only one product, simulate 12 orders using the following table. Fill out gray areas with appropriate Excel functions. NOTE: Use the random numbers shown in the table. b) Calculate average and total price. Order # Product# Price 1 Frequency Cml.Freq 0.1 0 0.15 0.1 0.15 0.25 0.2 0.4 0.25 0.6 0.15 0.85 2 Product# Price 4015 250 4025 250 1075 100 1085 100 3 4 1095 5 100 250 Rand# 0.564067 0.576834 0.158209 0.43311 0.519704 0.806837 0.5777 0.064811 0.273217 0.088406 0.04846 4035 6 7 8 9 10 11 12 0.777738 Total= Average= A bike company receives bike orders every week and fulfills them according to order's type. The following table shows frequency and price of the company's products. a) Assuming each order is for only one product, simulate 12 orders using the following table. Fill out gray areas with appropriate Excel functions. NOTE: Use the random numbers shown in the table. b) Calculate average and total price. Order # Product# Price 1 Frequency Cml.Freq 0.1 0 0.15 0.1 0.15 0.25 0.2 0.4 0.25 0.6 0.15 0.85 2 Product# Price 4015 250 4025 250 1075 100 1085 100 3 4 1095 5 100 250 Rand# 0.564067 0.576834 0.158209 0.43311 0.519704 0.806837 0.5777 0.064811 0.273217 0.088406 0.04846 4035 6 7 8 9 10 11 12 0.777738 Total= Average=