please do work in excel and show formulas

Create an Excel spreadsheet that will generate random numbers based on the following probability distributions. You can keep the answers to (a), (b), (c), (d) and (e) on the same spreadsheet. If I click on F9 key, the random numbers must be refreshed; otherwise, O score will be assigned. a) Use Excel generic formula to randomly generate 10 observations following a uniform distribution between 20 and 30, i.e., U120, 30). b) Use Excel generic function to randomly generate 10 integer observations following a discrete uniform distribution between 15 and 25. c) Use VLOOKUP function to randomly generate 10 observations following a general discrete distribution described in the table below. 5 8 11 16 18 PIX = x) 0.08 0.12 0.35 0.25 0.20 d) Use Excel generic function to randomly generate 10 observations following a normal distribution with a mean of 200 and a standard deviation of 30, and use ROUND() to round these random numbers to the nearest integer. e) Use Excel generic formula to randomly generate 10 observations following a symmetric triangular distribution (30, 50, 70)