USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=PROPER(RIGHT(B4, LEN(B4)-FIND(” “, B4)))
|
|
|
=PROPER[RIGHT(B4, LEN, B4)-FIND(” “, B4))]
|
|
|
=PROPER((RIGHT(B4, LEN(B4-FIND(” “, B4)))
|
|
|
=(PROPER(RIGHT(B4, LEN(B4)-FIND(” “, B4)))
|
Detailed explanation-1: -LEN returns the number of characters in a text string.
Detailed explanation-2: -We then used the LEN function to calculate the total length of each value. For example, the length of 1035 miles is 9. To get the number of characters to extract, we subtracted 6, which is the length of ” miles” (including the space character).
Detailed explanation-3: -Nested IF functions, meaning one IF function inside of another, allows you to test multiple criteria and increases the number of possible outcomes. We want to determine a student’s grade based on their score. If Bob’s score in B2 is greater than or equal to 90, return an A.
Detailed explanation-4: -The RIGHT function is used to extract text from the right side of a text string. Use the LEFT function to extract text starting from the left side of the text, and the MID function to extract from the middle of the text. The LEN function returns the length of text as a count of characters.