1) Which Excel function is used to combine the contents of two or more cells into one cell a) CONCATENATE b) MERGE c) COMBINE d) JOIN 2) Which function is used to convert text to lowercase in Excel? a) LOWER b) TEXTLOWER c) CONVERTCASE d) CASELOWER 3) Which function is used to split text strings based on a delimiter in Excel? a) Converts text to uppercaseSEPARATE b) DELIMIT c) SPLIT d) BREAK 4) Which function is used to find the position of a specific character or substring within a text string? a) POSITION b) FIND c) SEARCH d) LOCATE 5) What does the LEFT function in Excel do? a) Returns the leftmost characters from a text string b) Converts text to uppercase c) Removes leading and trailing spaces d) Converts text to lowercase 6) Which function is used to extract text from the middle of a text string in Excel? a) MID b) EXTRACT c) SPLIT d) SUBSTRING 7) What does the LEN function do in Excel? a) Returns the number of characters in a text string b) Converts text to lowercase c) Removes leading and trailing spaces d) Converts text to uppercase

Microsoft Excel (Text functions)

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?