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)
Correct Answer:
Verified
Q61: After you define the scope for a
Q62: Tricia created a defined name for a
Q63: When you enter a formula such as
Q64: Charlie imported data that displays "Albany, NY"
Q65: In the formula =SUM('San Francisco'!A6:D6), the exclamation
Q67: Which of the following functions can you
Q68: After you circle invalid data on a
Q69: Which of the following are math &
Q70: Which of the following are statistical functions?
Q71: Which of the following are financial functions?
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents