You Have Been Asked to Reorganize the Excel Table Below

question 42

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}{llllcccc}\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 { ODonnell } & \$ 957.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 } & \text { 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:

Psychic Costs

The mental and emotional energy expended by an individual in the process of decision-making or as a result of stressful economic conditions.

Real GDP

The measure of the value of economic output adjusted for price changes (inflation or deflation), reflecting the real quantity of goods and services produced.

GDP Deflator

An economic metric that converts output measured at current prices into constant-dollar GDP, reflecting the effects of inflation.

Real GDP

The value of all finished goods and services produced within a country's borders in a specific time period, adjusted for inflation.