FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

In the function =VLOOKUP(I2, C2:G44, 5, FALSE), which is the column index number?

A	I2
B	C2:G44
C	5
D	FALSE

Explanation:

Detailed explanation-1: -The column index number is the number of columns Excel must count over to find the matching value. The VLOOKUP function also has an optional fourth argument: range lookup. This can be either TRUE or FALSE. If the range lookup argument is FALSE, VLOOKUP will find only exact matches.

Detailed explanation-2: -=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).

Detailed explanation-3: -Excel’s row numbering starts with 1.

There is 1 question to complete.