DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
(LEFT (A3; 6); A11:B16; 2; FALSE)
|
|
|
(RIGHT (A3; 3); A20:D21; 2; FALSE)
|
|
|
IF (ISERROR (VLOOKUP (LEFT (A8; 6); A16:B21; 2; FALSE)); 0; ISERROR (VLOOKUP (LEFT (A8; 6); A16:B21; 2; FALSE)))
|
|
|
IFERROR (HLOOKUP (RIGHT (A8; 3); $ A $ 20:$ D $ 21; 2; FALS E); “None")
|
|
|
D3 = IF (AND (B3 = “LED TV"; C3 = “50 inch"); “Expensive"; “Medium")
|
Detailed explanation-1: -The VLOOKUP function only looks to the right. To look up a value in any column and return the corresponding value to the left, simply use INDEX and MATCH.
Detailed explanation-2: -The VLOOKUP function searches for a specific value in a dataset. If it finds it, it returns another value from a different column in the same row. And that’s what makes VLOOKUP one of the most time-saving functions in Excel.
Detailed explanation-3: -This parameter determines whether you are looking for an exact match or approximate match. In this example, the fourth parameter is FALSE. A parameter of FALSE means that VLOOKUP is looking for an EXACT match for the value of 10251. A parameter of TRUE means that a “close” match will be returned.