Can someone help me with this and send met the excel file so i can see what functions have been used to answer the questions?

Scenario #3: Risk & Reward

Imagine, finally, that you are applying for a position as an analyst at Blackstone Asset Management. You are attending a testing session today. Some basic portfolio analysis skills will be tested. You have been given two series of prices (below) and you guess that you will have to compute the expected return and standard deviation (risk) for the two assets and portfolios containing different combinations of them. The company's recruiters have made it clear that you can bring your spreadsheet files with you to the test, a basic framework with as much work pre-done as possible.

Using the data provided in the scenario (see assignment document), compute the average of the monthly returns for Breville and Monadel. [Note: due to spreadsheet rounding etc. your precise answer might differ slightly from the options below. However, care has been taken not to make any particular option 'too close" to the correct answer]. Select one: a. Breville = 10.78%, Monadel = 12.09% b. Breville = 5.39%, Monadel = 2.09% C. Breville = 7.01%, Monadel = 3.11% d. Breville = 4.89%, Monadel = 1.08% e. Breville = 1.12%, Monadel = -4.09% Using the data provided in the scenario (see assignment document), compute the standard deviation of the monthly returns for Breville and Monadel. [Note: due to spreadsheet rounding etc. your precise answer might differ slightly from the options below. However, care has been taken not to make any particular option 'too close' to the correct answer]. Select one: a. Breville = 16.19%, Monadel = 8.54% b. Breville = 9.04%, Monadel = 10.49% c. Breville = 12.31%, Monadel = 11.54% d. Breville = 21.32%, Monadel = 19.07% e. Breville = 8.90%, Monadel = 18.54%What is the covariance (computed using the COVAR function in Excel) between the returns series for Breville and Monadel? Select one: a. 0.0089 b. 0.0003 c. 0.02192 d. 0.01082 e. 0.002341What is the standard deviation and expected (average) return for an equally weighted portfolio of Breville and Monadel shares? Select one: a. -4.35% expected return and 20.91% standard deviation b. 1.34% expected return and 8.74% standard deviation C. 7.11% expected return and 9.04% standard deviation d. 3.74% expected return and 11.74% standard deviation e. 1.03% expected return and 3.05% standard deviation What is the standard deviation for a portfolio that is 80% invested in Breville with the remainder in Monadel? Select one: a. 14.33% b. 12.31% C. 6.77% d. 9.08% e. 11.00%\f