USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
James wants to use an advanced function to search his spreadsheet for aspecific string in a text string. What function should he use?
|
|
FIND
|
|
|
SUBSTITUTE
|
|
|
VLOOKUP
|
|
|
REPLACE
|
Explanation:
Detailed explanation-1: -What function should he use? James wants to use an advanced function to search his spreadsheet for a specific string in a text string? workbook.
Detailed explanation-2: -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-3: -To remove conditional formatting from specific cells, select the cells, click the Quick Analysis button, and click Clear Format. To remove all conditional formatting from the entire worksheet, click the Conditional Formatting button on the HOME tab, point to Clear Rules, and click Clear Rules from Entire Sheet.
There is 1 question to complete.