DATABASE FUNDAMENTALS
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
sometimes
|
|
|
None of the above
|
Detailed explanation-1: -If we type =TRUE() in a cell, we get the result as TRUE. One can also enter TRUE function directly into a cell. Even if we do not add the parentheses, it will return the Boolean value TRUE.
Detailed explanation-2: -In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division.
Detailed explanation-3: -Yes excel is used for mathematical calculations that is absolutely true. Excel provides us with many formulae which lets us solve simple and sometimes even complex equations on the excel sheet. These calculations can be carried out by putting simple formula in the top bar and get the output.
Detailed explanation-4: -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, "")