Match the Microsoft Excel function with its description.

LEN ==> It is used to return the number of characters in a cell
COUNTA ==> It is used to return the number of blank or non-blank cells in a range
CONCATENATE ==> It is used to combine the data from one or more columns into a single column
SUMIF ==> It is used to create a sum of values based on multiple criteria
INDEX ==> It is used to return a value or the reference to a value from within a table or range
UPPER ==> It is used to convert text to all capital letters (UPPERCASE)

Explanation & Hint:

Place the options in the following order:

LEN	It is used to return the number of characters in a cell
COUNTA	It is used to return the number of blank or non-blank cells in a range
CONCATENATE	It is used to combine the data from one or more columns into a single column
SUMIF	It is used to create a sum of values based on multiple criteria
INDEX	It is used to return a value or the reference to a value from within a table or range
UPPER	It is used to convert text to all capital letters (UPPERCASE)

For more Questions and Answers: