Question

Explain the following categories of function with purpose and example for each : a)POWER b) LEN c) CONCATENATE​

Answer 1

Answer:

The CONCATENATE Function is categorized under Excel Text Functions. The function helps to join two or more strings into one string.

As a financial analyst, we often deal with data when doing financial analysis. The data is not always structured for analysis and we often need to combine data from one or more cells into one cell or split data from one cell into different cells. The CONCATENATE function helps us to do that.

For example, If I get a list of projects in this format:

CONCATENATE Function

The CONCATENATE function helps structure data in the following format:

Answer 2

Answer:

The CONCATENATE Function is categorized under Excel Text Functions. The function helps to join two or more strings into one string.

As a financial analyst, we often deal with data when doing financial analysis. The data is not always structured for analysis and we often need to combine data from one or more cells into one cell or split data from one cell into different cells. The CONCATENATE function helps us to do that.