FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The function used to retrieve the left side of the text data as many characters as specified ____
A
Left
B
Right
C
Mid
D
Value
Explanation: 

Detailed explanation-1: -Description. LEFT returns the first character or characters in a text string, based on the number of characters you specify. LEFTB returns the first character or characters in a text string, based on the number of bytes you specify.

Detailed explanation-2: -The LEFT Function[1] is categorized under Excel TEXT functions. The function will return a specified number of characters from the start of a given text string. In financial analysis, the LEFT function can be useful if we wish to extract characters from the left side of a text.

Detailed explanation-3: -Excel LEFT function-syntax The LEFT function in Excel returns the specified number of characters (substring) from the start of a string.

Detailed explanation-4: -The LEFT function in Excel is a type of text function in Excel that gives the number of characters from the start of the string, from left to right. So, for example, if we use this function as =LEFT ( “ANAND”, 2) this will give us AN as a result.

There is 1 question to complete.
Previous
Next