DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
IFERROR
|
|
|
VLOOKUP
|
|
|
IF
|
|
|
RAND
|
Detailed explanation-1: -In order to do so, he will type the formula =A1-B1 in an empty cell.
Detailed explanation-2: -The less than or equal to operator (<=) returns TRUE if the first value is less than or equal to the second value. 1. For example, take a look at the formula in cell C1 below. Explanation: the formula returns TRUE because the value in cell A1 is less than or equal to the value in cell B1.
Detailed explanation-3: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
Detailed explanation-4: -To display the calculated value rather than the formula, you must change the format of the cell containing the formula and re-enter the formula. To do this, follow these steps: Select the cell with the formula, and then click Cells on the Format menu. Click the Number tab.