USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Horizontal reading of tables (rows) is called
|
|
Hlookup
|
|
|
Vlookup
|
|
|
CountIF
|
|
|
Sumif
|
Explanation:
Detailed explanation-1: -The HLOOKUP function is used to search for a value in the top row of an array of values, and then it retrieves the value in the same column from a row you specify in the table or array. The H in HLOOKUP stands for ‘Horizontal’.
Detailed explanation-2: -Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found.
Detailed explanation-3: -When you create a VLOOKUP or HLOOKUP function, you enter a range of cells, such as D2:F39. That range is called the table array argument, and an argument is simply a piece of data that a function needs in order to run. In this case, the function searches those cells for the data you’re trying to find.
There is 1 question to complete.