Asked by Jennifer Forest on Jul 24, 2024
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.
Verified Answer
Learning Objectives
- Understand the application of different Excel functions to manipulate text.
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 ...
An Excel Table Contains Columns Named Salary and Commission ...