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)

인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?