Which of the following MS Excel functions is used to convert a numeric value into a text with a specific format?
-
A.
NUMBERTOTEXT()
-
B.
VALUE()
-
C.
FORMAT()
-
D.
TEXT()
Correct Answer:
D. TEXT()
Explanation:
The correct answer is TEXT().
The TEXT() function in Microsoft Excel is specifically designed to convert a numeric value into text while applying a particular format using format codes. For example, it can be used to display dates in a specific style or to add currency symbols and decimal places to a number. While functions like VALUE() perform the opposite action by converting text to numbers, and NUMBERTOTEXT() provides a basic conversion, only TEXT() allows for custom formatting during the conversion process. This makes it an essential tool for preparing data for reports or concatenating numbers with strings of text.
Click below to open Discussion & Feedback
0 Issues
Please
login to comment or Report Issues.