This is an individual Excel assignment. You must use Excel functions to answer ALL calculations. Each question/problem must be on a new Excel sheet. This means that you must use 10 Excel sheets for 10 questions/problems. Stock A and Stock B produced the following returns during the past five years: b. Assume that someone held a portfolio consisting of 50 percent Stock A and 50 percent Stock B. What would have been the realized rate of return on the portfolio in each year from 2018 through 2022 ? What would have been the average return on the portfolio during this period