Question

Which of the following is not a valid Excel 2007 function for text manipulation?

• A. LEFT
• B. RIGHT
• C. UPPER
• D. CENTRE

Answer 1

Answer:

D. CENTRE

MS Excel Text Manipulation Functions

• Microsoft Excel provides a wide array of functions for manipulating text strings within cells. These functions are crucial for data cleaning, analysis, and presentation.

Commonly Used Text Functions in Excel:

• CONCATENATE: Joins two or more text strings into one. (e.g., CONCATENATE("Hello", " ", "World") results in "Hello World"). In newer versions, the '&' operator or the CONCAT function can be used similarly.

• LEFT: Returns a specified number of characters from the beginning of a text string. (e.g., LEFT("Excel", 2) returns "Ex").

• RIGHT: Returns a specified number of characters from the end of a text string. (e.g., RIGHT("Excel", 2) returns "el").

• MID: Returns characters from the middle of a text string, given a starting position and a number of characters. (e.g., MID("Excel", 2, 3) returns "xce").

• LEN: Returns the number of characters in a text string. (e.g., LEN("Excel") returns 5).

• FIND/SEARCH: Locates one text string within another, returning the starting position. FIND is case-sensitive, while SEARCH is not.

• SUBSTITUTE: Replaces existing text with new text in a text string. (e.g., SUBSTITUTE("Hello World", "World", "Excel") returns "Hello Excel").

• REPLACE: Replaces part of a text string based on the number of characters you specify.

• TRIM: Removes extra spaces from text, leaving only single spaces between words.

• UPPER/LOWER/PROPER: Convert text to all uppercase, all lowercase, or proper case (first letter capitalized) respectively.

Understanding the `CENTRE` Function:

• The term `CENTRE` is not a standard built-in function within Microsoft Excel for text manipulation or any other purpose. It might be confused with alignment options in Excel (e.g., Center Alignment for text display) or perhaps a function from a different software or a custom-defined function.

• Excel functions are typically named with concise, descriptive keywords, often in all uppercase, followed by parentheses. Examples include `SUM`, `AVERAGE`, `VLOOKUP`, `LEFT`, `RIGHT`, `MID`, etc.