Charlie Imported Data That Displays "Albany, NY" in Cell A24

question 135

Multiple Choice

Charlie imported data that displays "Albany, NY" in cell A24.What formula can he use to display "NY" in cell D3?

• A) =LEFT(A24, 2)
• B) =RIGHT(A24, 2)
• C) =LOWER(A24)
• D) =EXTRACT(A24, 2)

---

Definitions:

Proprietary Information

Confidential business information that provides a company with a competitive advantage, including trade secrets, processes, or recipes.

Economic Espionage

The illegal practice of obtaining confidential business information without permission for commercial advantage.

Electronic Hacking

Unauthorized access to or manipulation of computer systems, networks, or personal digital devices, often with malicious intent.

Noncompete Clause

A contract provision prohibiting an employee from working in a competing business for a specified period after leaving the company.