FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

Detailed explanation-2: -Goal Seek can be used to set one cell to a particular value by changing the value of a different cell. The NOT function returns True when given two arguments that evaluate to True. Goal Seek will return the optimal value to set the selected cell to the desired value.

Detailed explanation-3: -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, you use the Solver add-in. For more information, see Define and solve a problem by using Solver.

Detailed explanation-4: -Absolute. a cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied and is indicated by the $ sign.

Detailed explanation-5: -You must start each formula by typing the equal sign (=). When you change the value in a cell that is referenced in a formula, you must re-enter the formula to make sure it also changes. You can click a cell or select a range to enter its address in the formula. Formulas and functions are NOT case sensitive.