USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
goal seekers
|
|
|
sparklines
|
|
|
assumptions
|
|
|
NOW function
|
Detailed explanation-1: -The cell references in a formula are calledassumptions. Assumptionsare values in cells that you can change to determine new values for formulas.
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: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references.