Correct Answer:
B. LEN
Spreadsheet programs like Microsoft Excel offer a wide array of functions to manipulate and analyze data, including text strings. Understanding these functions is crucial for effective data processing.
- The correct answer is LEN. The LEN function (short for 'length') is specifically designed to return the number of characters in a given text string. For example, if a cell contains "Hello World", LEN() would return 11 (counting the space).
- COUNT is incorrect. The COUNT function is used to count the number of cells in a range that contain numbers, not the number of characters within a text string.
- MID is incorrect. The MID function extracts a specified number of characters from a text string, starting from a designated position. It does not return the total character count.
- CHAR is incorrect. The CHAR function returns the character corresponding to a specified number code (e.g., ASCII or Unicode), rather than counting characters in a string.