In MS Excel 2019, what is the result of the formula =RIGHT("india",2)?
2021
In MS Excel 2019, what is the result of the formula =RIGHT("india",2)?
- A.
ia
- B.
ba
- C.
aa
- D.
error
Attempted by 97 students.
Show answer & explanation
Correct answer: A
The RIGHT function in Excel extracts a specified number of characters from the end (right side) of a text string. For =RIGHT("india",2), it extracts the last 2 characters from "india", which are 'i' and 'a', resulting in the text "ia".