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:

Technological Skills

Abilities and expertise in specific areas related to the use, understanding, and development of tools, machines, techniques, and systems.

Assistance

The act of helping or supporting someone or something, often with resources or advice.

Social Approval

The positive recognition or acceptance from others in a social context, often influencing behavior and self-perception.

Peers

Those of similar status.