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.

Which of the Following Are Necessary to Be Determined to Define

Multiple Choice

Correct Answer:VerifiedUnlock this answer nowGet Access to more Verified Answers free of chargeAccess For Free

Correct Answer:
Verified
Unlock this answer now
Get Access to more Verified Answers free of charge