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]

James wants to use an advanced function to search his spreadsheet for a specific string in a text string?

A	FIND
B	REPLACE
C	SUBSTITUTE
D	VLOOKUP

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.

There is 1 question to complete.