A "City" field has some values written as uppercase and other values as lowercase, as well as inconsistent spellings. Which processes would create a field with uppercase values that are correctly spelled? A) =TRIM B) Replace Values C) =UPPERSelect an answer:B and CA and BA, B, and C

When using Find and Replace, you want to ensure that your Replace With text uses upper and lower case letters exactly as intended. How can you ensure this?In the Replace With field, type everything in lowercase.In the Replace With field, type everything in uppercase.This will happen by default.

Question 4A data professional discovers that SUV is spelled SWV in the database column car_types. Which CASE clause will enable them to correct the misspellings?1 pointCASE WHEN car_types = 'SWV' THEN 'SUV'CASE car_types = 'SWV' THEN 'SUV'WHEN CASE car_types = 'SWV' THEN 'SUV'WHEN car_types CASE = 'SWV' THEN 'SUV'

Which of the following string methods returns the string value converted to uppercase?1 pointindexOf()toUpperCase()concat()length()charAt()equals()

Suppose you have a string - Hello! HOW are you doing - with cell reference C54. Now you need to convert the first letter of every word as capital and rest characters in lower case.Which of the following is the correct function for the same? Answer choicesSelect only one optionREVISITLOWER(C54)UPPER(C54)PROPER(C54)PROPERL(C54)

Which function helps in changing the text to uppercase in Excel?Answer( Please choose a correct answer )   CLEARLOWER()CAPITAL()UPPER()BIG()