The instructions are in the first photo. Please help me solve this, & include all functions/formulas used.

A medical supply provider examines the weekly demand by hospitals for respiratory ventilators. Use Excel to construct 100 random weekly demands for ventilators based on the probability distribution. Example 16.4 I have changed the numbers but the methodology is the same \begin{tabular}{c|c|c|c} \hline & A & B & C \\ \hline & Ventilator & & \\ \hline 1 & Demand & Frequency & \\ \hline 2 & 100 & 20 & \\ \hline 3 & 200 & 25 & \\ \hline 4 & 300 & 40 & \\ \hline 5 & 400 & 15 & \\ \hline 6 & 500 & 10 & \\ \hline 7 & & & \\ \hline 8 & & & \\ \hline 9 & & & \\ \hline \end{tabular}