DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
contains the correct value (TRUE)
|
|
|
Read data table
|
|
|
contains a false value (FALSE)
|
|
|
Value as the basis of data
|
|
|
The amount of data to be read
|
Detailed explanation-1: -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.
Detailed explanation-2: -Select ‘Function’ (Fx) > VLOOKUP and insert this formula into your highlighted cell. Enter the lookup value for which you want to retrieve new data. Enter the table array of the spreadsheet where your desired data is located. Enter the column number of the data you want Excel to return.
Detailed explanation-3: -When we have a large amount of data and do not know where to look, we can select the table and name it. While using the VLOOKUP function, instead of providing the reference, we can type the table’s name as a reference to look up the value. Such a table is known as a lookup table in Excel.
Detailed explanation-4: -What Is a LOOKUP Function? Lookup functions in Excel mean referencing a cell to match values in another row or column against the cell and thereby retrieving the corresponding results from the respective rows and columns.