FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What does the Goal Seek tool do?
A
allows you to see how changing one data item in a formula affects the others
B
highlights the major functions and outcomes of your data set
C
automatically sorts or totals data
D
allows you to add values in a selection of cells
Explanation: 

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: -What Is Goal Seeking? 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.

Detailed explanation-4: -The Solver add-in is similar to Goal Seek, but it can accommodate more variables. You can also create forecasts by using the fill handle and various commands that are built into Excel. For more advanced models, you can use the Analysis ToolPak add-in.

Detailed explanation-5: -Goal Seek requires a formula that uses the input value to give result in the target value. Then, by varying the input value in the formula, Goal Seek tries to arrive at a solution for the input value. Goal Seek works only with one variable input value.

There is 1 question to complete.