Please solve in EXCEL showing all work/formulas used. NOT TYPED. Thank you in advance for your help! Will upvote!

1-

Given the following information answer the next 2 questions:

	X	Y
Variance	.02	.01
Expected Return	15%	5%
amount invested	$4,000	$10,000

Covariance between X&Y 0.0036

1) The expected return on the portfolios is:

		7.86%
		8.75%
		7.00%
		7.06%
		6.50%

2-

The variance of returns on the portfolio is:

		0.2785
		0.3333
		0.0108
		0.0082
		0.1800