DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
what-if
|
|
|
who-could
|
|
|
NOW
|
|
|
possibility
|
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: -What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.
Detailed explanation-3: -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.
Detailed explanation-4: -Precedent cells-cells that are referred to by a formula in another cell. For example, if cell D10 contains the formula =B5, then cell B5 is a precedent to cell D10. Dependent cells-these cells contain formulas that refer to other cells.