contestada

Rohan has 50,000 that he wants to invest in two mutual funds for one year. Func low risk fund with 18% interest rate and Fund B is a higher risk fund 1% interest rate. Which feature of spreadsheets (Calc) will be help him to decide } Solver (b) Subtotal (c) Linking sheets d) Macros​

Respuesta :

The feature of spreadsheets that will help Rohan decide where to invest his money is;

Option A; Solver

Since he wants to find where to invest his funds for one year between the two fund types. This means in excel, he will make of what we call "IF function".

  • The "IF" function helps in making logical comparisons between a particular value and what you will expect and as a result, it implies that the "IF" statement can have two results.

  • The first result of the IF function will be the one to show that the comparison is True while the second is to show the comparison is False.

Now, in Microsoft Excel, we make use of an add-in program called "SOLVER" that is used for what-if analysis.

Solver is used to find the maximum or minimum value for a formula in the objective cell which is subject to constraints, on the values of other formula cells in that particular worksheet.

Read more at; https://brainly.com/question/15032995

Otras preguntas