DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Returns the value rounded upto 0 decimal place.
|
|
|
Checks if two text values are identical.
|
|
|
Creates duplicate values.
|
|
|
None
|
Detailed explanation-1: -Description. Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.
Detailed explanation-2: -Comparing strings in Excel can be done with a simple function. The =EXACT(A1, B1) function will return TRUE if the two cells contain the same text string.
Detailed explanation-3: -What is the EXACT Function? The EXACT Function[1] is categorized under Excel TEXT functions. The function helps to test if two or more than two supplied text strings or values are exactly equal and, if so, returns TRUE. Otherwise, it returns FALSE.
Detailed explanation-4: -The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 25, and 38, then the formula =MATCH(25, A1:A3, 0) returns the number 2, because 25 is the second item in the range.