USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
goal seeking
|
|
|
goal
|
|
|
test
|
|
|
trial
|
Detailed explanation-1: -If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature.
Detailed explanation-2: -If you know the result that you want from a formula, but you’re not sure what input value the formula requires to get that result, you can use the Goal Seek feature. For example, suppose that you need to borrow some money.
Detailed explanation-3: -Go to the Data tab > Forecast group, click the What if Analysis button, and select Goal Seek… In the Goal Seek dialog box, define the cells/values to test and click OK: Set cell-the reference to the cell containing the formula (B5). To value-the formula result you are trying to achieve (1000).
Detailed explanation-4: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).
Detailed explanation-5: -Essentially, an INDEX formula returns a cell reference from within a given array or range. In other words, you use INDEX when you know (or can calculate) the position of an element in a range and you want to get the actual value of that element.