Question 11 How is Excel's 'Solver' tool used in Project 4: Portfolio Analysis? It is used to: set each security's asset weight equal to 100% by changing a cell in the assumptions. maximize a return/risk variable by changing the various asset weights (which total 100%) and setting certain constraints. O minimize the portfolio variance. O find the break-even average return by setting the total of the asset weights equal to 100%. 1 pts

How is Excel's 'Solver' tool used in Project 4: Portfolio Analysis? It is used to: set each security's asset weight equal to 100% by changing a cell in the assumptions. maximize a return/risk variable by changing the various asset weights (which total 100% ) and setting certain constraints. minimize the portfolio variance. find the break-even average return by setting the total of the asset weights equal to 100%. How is Excel's 'Solver' tool used in Project 4: Portfolio Analysis? It is used to: set each security's asset weight equal to 100% by changing a cell in the assumptions. maximize a return/risk variable by changing the various asset weights (which total 100% ) and setting certain constraints. minimize the portfolio variance. find the break-even average return by setting the total of the asset weights equal to 100%