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:

Normative Statement

An assertion that expresses a value judgment or opinion about what ought to be, rather than what is empirically verifiable.

Post Hoc

A logical fallacy that assumes a cause-and-effect relationship simply because one event follows another in time.

Causality

The relationship between cause and effect, where one event (the cause) leads to the outcome of another event (the effect).

Economics in Practice

The application of economic theories and principles to real-world scenarios and the analysis of economic behaviors and events.