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:

Comparability

An accounting principle that allows stakeholders to compare financial information across different time periods effectively.

Generally Accepted Accounting Principles

A collection of commonly-followed accounting rules and standards for financial reporting that is adopted by most countries.

ASPE

Accounting Standards for Private Enterprises, which are the accounting standards used by private companies in Canada.

Earnings Per Share

A measure of a company's profitability that calculates how much money shareholders would receive for each share they own if all profits were distributed.