DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
arguments
|
|
|
criteria
|
|
|
range
|
|
|
dialog
|
Detailed explanation-1: -criteria-defines the condition that tells the function which cells to count. It can be a number, text string, cell reference or expression.
Detailed explanation-2: -You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. logical test: The condition that you want to check. value if true: The value to return if the condition is True.
Detailed explanation-3: -What does criteria range in a formula refer to? The range containing a condition that must be met in order for data to be included in the result.
Detailed explanation-4: -Excel IF function with text Commonly, you write an IF statement for text values using either “equal to” or “not equal to” operator. Translated into plain English, the formula says: return “No” if B2 is equal to “delivered", “Yes” otherwise.