Which of the following is not a valid Excel 2007 function for text manipulation?
ALEFT
BRIGHT
CUPPER
DCENTRE
Answer:
D. CENTRE
Read Explanation:
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.