Ellen Is a Recent College Graduate

question 16

Multiple Choice

Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2013. She need to keep track of her expenses and income for the year.
-Ellen wants to find out what her median monthly spending is.The monthly totals for her spending appear in the range A10:L10.Which of the following is NOT a way to enter the MEDIAN function into her database?

• A)Type =MEDIAN(A10:L10) into an empty cell.
• B)Select the range A10:L10, click the Quick Analysis button, click TOTALS, and then click Median.
• C)Click the More Functions button in the Function Library group on the FORMULAS tab, point to Statistical, and then click MEDIAN.
• D)Click the Insert Function button in the Function Library group on the FORMULAS tab, scroll the Select a function list, then click MEDIAN.

---

Definitions:

Retained Earnings

The portion of net earnings not paid out as dividends, but retained by the company to be reinvested in its core business, or to pay debt.

Plant Expansion

The process of increasing the capacity or capabilities of existing facilities through additional space, equipment, or technology.

Dividend Declarations

A corporate action where a company announces the payment of dividends to its shareholders.

Retained Earnings

The portion of net earnings not paid out as dividends, but retained by the company to be reinvested in its core business or to pay debt.