FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

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]

Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?

A	VLOOKUP
B	HLOOKUP
C	LOOKUP
D	SEARCH

Explanation:

Detailed explanation-1: -VLOOKUP Formula The VLOOKUP function uses the following arguments: Lookup value (required argument) – Lookup value specifies the value that we want to look up in the first column of a table.

Detailed explanation-2: -VLOOKUP() The VLOOKUP or Vertical Lookup function is used when data is listed in columns. This function searches for a value in the left-most column and matches it with data in a specified column in the same row. You can use VLOOKUP to find data in a sorted or unsorted table.

Detailed explanation-3: -Answer. The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions. The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.

There is 1 question to complete.