Which of the given options best describes the truth of the following statements?
i) The function LEFT() in MS-Excel365 is used to return a specified number of characters from the end of a text string.
ii) If cell H5 contains the text "Spreadsheet", and the formula =LEFT(H5, 5) is entered in cell H6, the result will be "Spree".
iii) The bubble chart in MS-Excel365 is used to display three dimensions of data.
1
i-correct, ii-correct, iii-incorrect
2
i-incorrect, ii-incorrect, iii-correct
3
i-correct, ii-incorrect, iii-correct
4
i-correct, ii-correct, iii-correct