Which of the Following Will You Select as X in the Series

question 44

Multiple Choice

Which of the following will you select as X in the series of clicks to circle invalid data in a worksheet: Data tab > Data Tools group > Arrow next to X > Circle Invalid Data?

• A) What-If Analysis
• B) Data Validation
• C) Remove Duplicates
• D) Consolidate worksheet data.

---

Definitions:

Marketable Securities Portfolio

A collection of liquid financial instruments and securities that can be quickly converted into cash at a value close to the market rates.

Treasury Bills

Short-term government securities with maturity periods of one year or less, sold at a discount from their face value.

Desire To Invest

The inclination or willingness of individuals or entities to allocate resources to investment opportunities with the expectation of earning a return.