DATABASE FUNDAMENTALS
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: -Click the cell that contains the data that you want to edit, and then click anywhere in the formula bar. This starts Edit mode and positions the cursor in the formula bar at the location that you clicked. Click the cell that contains the data that you want to edit, and then press F2.
Detailed explanation-3: -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-4: -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.