FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WORKBOOK THEMES

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]

Peter wnats to replace a specific text in a text string in his spreadsheet. What function should he use?

A	FIND
B	SUBSTITUTE
C	VLOOKUP
D	SEARCH

Explanation:

Detailed explanation-1: -REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.

Detailed explanation-2: -The function is called SUBSTITUTE and it is useful if you know the string in the existing text to replace and require to control the replacement occurrences. By default, the SUBSTITUTE function replaces all occurrences of the existing string by new string.

Detailed explanation-3: -=REPLACE(old text, start num, num chars, new text) The REPLACE function uses the following arguments: Old text (required argument) – This is the text we wish to replace some characters. Start num (required argument) – The position, within old text, of the first character that you want to replace.

There is 1 question to complete.