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.

Question

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.

Quizplus · Accepted Answer

The Sort function in Excel allows you to quickly organize data in ascending or descending order based on the values in one or more columns. In this case, sorting by the Sales column will reorganize the table into order of sales efficiently.

You Have Been Asked to Reorganize the Excel Table Below