DATABASE FUNDAMENTALS
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: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).
Detailed explanation-4: -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.
Detailed explanation-5: -VLOOKUP() The VLOOKUP or Vertical Lookup function is used when data is listed in columns. This function searches for a value in the left-most column and matches it with data in a specified column in the same row. You can use VLOOKUP to find data in a sorted or unsorted table.