USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
allows you to see how changing one data item in a formula affects the others
|
|
|
highlights the major functions and outcomes of your data set
|
|
|
automatically sorts or totals data
|
|
|
allows you to add values in a selection of cells
|
Detailed explanation-1: -Goal Seek is Excel’s built-in What-If Analysis tool that shows how one value in a formula impacts another. More precisely, it determines what value you should enter in an input cell to get the desired result in a formula cell.
Detailed explanation-2: -You can use Goal Seek to determine what interest rate you will need to secure in order to meet your loan goal. Note: Goal Seek works only with one variable input value. If you want to accept more than one input value, for example, both the loan amount and the monthly payment amount for a loan, use the Solver add-in.
Detailed explanation-3: -Goal Seek works only with one variable input value. If you have more than one input value to be determined, you have to use the Solver add-in.
Detailed explanation-4: -A spreadsheet program like Microsoft Excel has a goal seeking tool built-in. It allows the user to determine the desired input value for a formula when the output value is already known.
Detailed explanation-5: -Goal seeking is the process of finding the correct input value when only the output is known. The function of goal seeking can be built into different kinds of computer software programs like Microsoft Excel. Goal seeking is finding the correct input when only the output is known.