Question

Explain with example the use of the following functions:

a) TRIM()

b) RIGHT()

c) POW()

d) NOW()​

Answer 1

Answer:

TRIM()

The TRIM function is used to “normalize” all spacing. TRIM automatically strips space at the start and end of a given string and leaves just one space between all words inside the string. It takes care of extra spaces caused by empty cells. SUBSTITUTE is used to replace each space (” “) with a comma and space (“, “).

RIGHT ()

The Microsoft Excel RIGHT function extracts a substring from a string starting from the right-most character. The RIGHT function is a built-in function in Excel that is categorized as a String/Text Function. ... As a worksheet function, the RIGHT function can be entered as part of a formula in a cell of a worksheet.

POW ()

The pow() function returns the valuef of x to the power of y (xy). If a third parameter is present, it returns x to the power of y, modulus z.

NOW ()

Description. Returns the serial number of the current date and time. ... The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.

Answer 2

Answer:

TRIM-decorate typically with contrasting items of pieces of material....

RIGHT- correctly properly...

POW-expressing the sound of a blow of explosion.........

NOW-use of sudden present...

Explanation:

please mark my question and follow me❤❤