Cell B1 contains the text "Manager: Vang." What is the result of the formula = SUBSTITUTE (B1, "Vang", "Garcia")?
A) Manager: Vang
B) Vang: Manager
C) Garcia: Manager
D) Manager: Garcia

Question

Quizplus · Accepted Answer

The SUBSTITUTE function replaces existing text with new text in a string. The formula =SUBSTITUTE(B1, "Vang", "Garcia") replaces "Vang" with "Garcia" in the text "Manager: Vang", resulting in "Manager: Garcia".

Cell B1 Contains the Text "Manager: Vang