logo
Ask Question

Asked by Jennifer Forest on Jul 24, 2024

verifed

Verified

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

SUBSTITUTE

A function in many programming and spreadsheet applications that replaces instances of a specified character or string within a text string with another character or string.

Text

Written or printed words that convey information or ideas.

Formula

In computing, an expression that calculates the value of some output based on one or more inputs, commonly used in spreadsheets and mathematical software.

  • Understand the application of different Excel functions to manipulate text.
verifed

Verified Answer

SA
Shihab AhmedJul 26, 2024
Final Answer :
D
Explanation :
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".

Related questions

Charlie Imported Data That Displays Albany, NY in Cell A24 ...

Which of the Following Functions Are Text Functions That Convert ...

You Use the SUMIFS Function to Sum Ranges with Multiple ...

Which of the Following Functions Can You Use to Display ...

The _____ Function Returns the Value from a Range of ...