A Company Uses Excel to Maintain a List of Its

question 72

Multiple Choice

A company uses Excel to maintain a list of its customers.It maintains details of customer name,id,age,and region of residence (East,West,North,and South) .If a manager wants a list of only those customers living in the North,which of the following functions of Excel can the manager use?

• A)Basic Filter
• B)Custom Filter
• C)Goal Seek
• D)Conditional formatting

---

Definitions:

Stock Splits

A corporate action in which a company divides its existing stock into multiple shares to increase the liquidity of the shares, though the market capitalization remains the same.

Shareholder's Wealth

Shareholder's Wealth is the sum total of the capital value of a company's shares plus any retained earnings or losses. It represents the shareholders' stake in the company.

Stock Split

A corporate action in which a company divides its existing shares into multiple shares to boost the liquidity of the shares, although the overall value of one's holdings remains the same.

Shareholder's Wealth

The overall value that shareholders earn from their investment in a company, including dividends received and capital gains from share price appreciation.