Which of the given options best describes the truth of the following statements?

i) The function TRIM() in MS-Excel365 is used to remove all spaces from a text string except for single spaces between words.

ii) If cell J5 contains the text " Excel ", and the formula =TRIM(J5) is entered in cell J6, the result will be "Excel".

iii) The waterfall chart in MS-Excel365 is used to show the cumulative effect of sequentially introduced positive or negative values.

1
i-correct, ii-correct, iii-incorrect
2
i-incorrect, ii-correct, iii-correct
3
i-correct, ii-incorrect, iii-correct
4
i-correct, ii-correct, iii-correct

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation