FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In the RIGHT function, Num ____ chars is the number of characters you want the function to extract.
A
T
B
F
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -The RIGHT function in Excel extracts a specific number of characters from a text string, starting from the rightmost character. This function relies on the relative position of characters in a text string.

Detailed explanation-2: -The RIGHT function extracts characters beginning from the rightmost side to the left. The RIGHT function accepts two arguments–“text” and “num chars.” The default value of “num chars” is set at 1. If “num chars” is greater than the length of the text, the RIGHT function returns the complete text.

Detailed explanation-3: -Num chars Optional. Specifies the number of characters you want RIGHT to extract. Num chars must be greater than or equal to zero. If num chars is greater than the length of text, RIGHT returns all of text. If num chars is omitted, it is assumed to be 1.

Detailed explanation-4: -The RIGHT function in Excel returns the specified number of characters from the end of a text string. Where: Text (required)-the text string from which you want to extract characters. Num chars (optional)-the number of characters to extract, starting from the rightmost character.

There is 1 question to complete.
Previous
Next