You Have Been Asked to Reorganize the Excel Table Below

question 5

Multiple Choice

You have been asked to reorganize the Excel table below into order of sales using the Sales column. Which option will allow you to do this quickly? ? $\begin{array}{llllrlclr}\text { Customer ID }&\text {First}&\text { Last }&\text {Sales }&\text {Quantity}&\text { Discount }&\text {Profit }\\\text { CG-12520 } & \text { Claire } & \text { Gute } & \$ 261.96 & 2 & 0 & \$ 41.91 \\\text { DV-13045 } & \text { Darrin } & \text { VanHuff } & \$ 14.62 & 2 & 0 & \$ 16.87 \\\text { SO-20335 } & \text { Sean } & \text { O'Donnell } & \$ 9557.58 & 5 & 0.45 & \$ (383.03) \\\text { BH-11710 } & \text { Brosina } & \text { Hoffman } & \$ 48.86 & 7 & 0 & \$ 14.17 \\\text { AA-10480 } & \text { Andrew } & \text { Allen } & \$ 25.55 & 3 & 0.2 & \$ 5.44 \\\text { IM-15070 } & \text { Irene } & \text { Maddox } & \$ 407.98 & 3 & 0.2 & \$ 132.59 \\\text { HP-14815 } & \text { Harold } & \text { Pawlan } & \$ 68.81 & 5 & 0.8 & \$(123.86) \\\text { PK-19075 } & \text { Pete } & \text { Kriz } & \$ 665.88 & 6 & 0 & \$ 13.32 \\\text { AG-10270 } & \text { Alejandro Grove } & \$ 55.50 & 2 & 0 & \$ 9.99 \\\text { ZD-21925 } & \text { Zuschuss } & \text { Donatelli } & \$ 8.56 & 2 & 0 & \$ 2.48\end{array}$ ?
?

• A)?Use the Cut and Paste function to reorganize the data into order of sales.
• B)?Use the Filter function to organize the data into order of sales.
• C)?Use the Order function to organize the data into order of sales.
• D)?Use the Sort function to organize the data into order of sales.

---

Definitions:

Installment Note

A debt instrument that requires regular payments, or installments, of principal and interest over a specified period.

Fiscal Year

A one-year period used for financial reporting and budgeting, which does not necessarily coincide with the calendar year.

Principal Repayment

The portion of a loan payment that goes toward reducing the amount borrowed, not including interest.

Federal Income Tax

A tax levied by the United States federal government on the annual earnings of individuals, corporations, trusts, and other legal entities.