Asked by Viviana Gomez on May 17, 2024
Verified
Cell D1 contains the text "Office Locations." Min wants to convert the text to "OFFICE LOCATIONS." Which of the following formulas should he use?
A) =LOWER(D1)
B) =PROPER(D1)
C) =UPPER(D1)
D) =CONCAT(D1)
Text
Strings of characters used to represent words, sentences, or other forms of written communication.
- Understand how to use Excel functions for uppercasing, concatenation, and text joining.
Verified Answer
AS
Alexis StaabMay 20, 2024
Final Answer :
C
Explanation :
The UPPER formula converts all text to capital letters. Therefore, =UPPER(D1) would convert "Office Locations" to "OFFICE LOCATIONS."
Learning Objectives
- Understand how to use Excel functions for uppercasing, concatenation, and text joining.
Related questions
Which of the Following Functions Can You Use to Combine ...
Which of the Following Functions Are Text Functions That Convert ...
Charlie Imported Data That Displays Albany, NY in Cell A24 ...
Cell B1 Contains the Text Manager: Vang ...
Excel's ____________________ Function,which Adds All of the Numbers in a ...