What is Text Manipulation Function ? Explain its syntax.

OR

Write the steps to change format of selected chart element.

The function converts a numeric value to text in a specific number format………….1 Syntax. (value, format_____ text) ………………………………………………… $\displaystyle 1$ where Value: is a numeric value, a formula that evaluates to a numeric value or reference to cell containing a numeric value. ……………………….………………………………… $\displaystyle 1$ Format – txt is a numeric format as a text string enclosed in quotation marks……….1 Q. (b) Write the steps to change……… Ans. The function that converts a numeric value to text in a specific number format……. $\displaystyle 1$ Syntax ( value, format_text) ……………………………………………………….… $\displaystyle 1$ Where value: is a numeric value a formula that evaluate to a numeric value or a reference to a cell containing a numeric value……………………………………….…………..… $\displaystyle 1$ Format ____ text is a numeric format or text string enclosed in quotation Marks…… $\displaystyle 1$