Please explain and include excel formulas

Complete the template to obtain the optimal risky portfolio using SPDR and LQD. Compute the portfolio average return, portfolio risk, and the Sharpe ratio for all portfolios with weights ranging from 0% to 100% at increments of 10%. The plot will be automatically generated. What is the Sharpe ratio on a portfolio containing 30\% SPDR and 70\% LQD? Type your answer... 2 points Which one of the following is the optimal risky portfolio containing SPDR and LQD? 50% SPDR and 50\% LQD 70% SPDR and 30% LQD 60% SPDR and 40% LQD 40% SPDR and 60% LQD 2 points Complete the template combining the optimal risky portfolio and the risk-free asset, which is proxied by the 1-month T-Bills. There is no right or wrong answer here: Consider your own personal risk preference and provide appropriate weight (in \%, between 0 and 150 ) on the optimal risky portfolio for your preferred complete portfolio. Complete the template to obtain the optimal risky portfolio using SPDR and LQD. Compute the portfolio average return, portfolio risk, and the Sharpe ratio for all portfolios with weights ranging from 0% to 100% at increments of 10%. The plot will be automatically generated. What is the Sharpe ratio on a portfolio containing 30\% SPDR and 70\% LQD? Type your answer... 2 points Which one of the following is the optimal risky portfolio containing SPDR and LQD? 50% SPDR and 50\% LQD 70% SPDR and 30% LQD 60% SPDR and 40% LQD 40% SPDR and 60% LQD 2 points Complete the template combining the optimal risky portfolio and the risk-free asset, which is proxied by the 1-month T-Bills. There is no right or wrong answer here: Consider your own personal risk preference and provide appropriate weight (in \%, between 0 and 150 ) on the optimal risky portfolio for your preferred complete portfolio