Which of the given options best describes the truth of the following statements?
i) The function LOWER() in MS-Excel365 is used to convert all letters in a text string to lowercase.
ii) If cell I10 contains the text "EXCEL", and the formula =LOWER(I10) is entered in cell I11, the result will be "excel".
iii) The stacked column chart in MS-Excel365 is used to show the parts of a whole.
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