Asked by Kyndal Hampton on Jul 24, 2024
Verified
Which of the following functions are text functions that convert the case of text? Select all the options that apply.
A) UPPER
B) LEN
C) LOWER
D) PROPER
Text Functions
Features or commands in software that allow manipulation and formatting of text, such as changing case or concatenating strings.
UPPER
A function typically used in programming and spreadsheet applications to convert text data into uppercase letters.
LOWER
In the context of text manipulation, a function or method used to convert all characters in a string to lowercase.
- Familiarize yourself with the utilization of various Excel functionalities for text alteration.
Verified Answer
CK
Christina KearnsJul 25, 2024
Final Answer :
A, C, D
Explanation :
A) UPPER function converts all letters in a text string to uppercase
C) LOWER function converts all letters in a text string to lowercase
D) PROPER function capitalizes the first letter in each word of a text string and converts the rest of the letters to lowercase.
B) LEN function is not a text function that converts the case of text; it is used to find the number of characters in a text string.
C) LOWER function converts all letters in a text string to lowercase
D) PROPER function capitalizes the first letter in each word of a text string and converts the rest of the letters to lowercase.
B) LEN function is not a text function that converts the case of text; it is used to find the number of characters in a text string.
Learning Objectives
- Familiarize yourself with the utilization of various Excel functionalities for text alteration.