USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUMIF
|
|
|
VLOOKUP
|
|
|
HLOOKUP
|
|
|
PMT
|
|
|
SLN
|
Detailed explanation-1: -VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row.
Detailed explanation-2: -VLOOKUP allows you to search a data range that is set up vertically. HLOOKUP is the exact same function, but looks up data that has been formatted by rows instead of columns.
Detailed explanation-3: -Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.
Detailed explanation-4: -In the Insert Function screen, enter VLookup in the “Search for a function” text box and click Go. In the “Select a function” box, highlight VLOOKUP and click OK. The Function Arguments screen appears. In the Lookup value field, enter the cell value you want to look up in the table array (e.g. May worksheet).
Detailed explanation-5: -Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find. The H in HLOOKUP stands for “Horizontal."