Cell D1 Contains the Text "Office Locations

question 277

Multiple Choice

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)

---

Definitions:

Question Mark (?)

A punctuation mark used at the end of a sentence to indicate a query or request for information.

Built-In Statistics

Predefined statistical functions or tools integrated within a software application that allow users to perform analyses without external programs.

STDEV

A statistical function that calculates the standard deviation of a set of numbers, indicating how much the numbers deviate from the average.

VAR

Stands for Value-Added Reseller; a company that adds features or services to an existing product, then resells it (usually to end-users) as an integrated product or complete "turn-key" solution.