USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Full
|
|
|
Unknown
|
|
|
10
|
|
|
-10
|
Detailed explanation-1: -If you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.
Detailed explanation-2: -To check if a cell contains text, select the output cell, and use the following formula: =IF(ISTEXT(cell), value to return, “"). For our example, the cell we want to check is A2, and the return value will be Yes. In this scenario, you’d change the formula to =IF(ISTEXT(A2), “Yes", “").
Detailed explanation-3: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.