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:

Esters

Organic compounds derived from carboxylic acids where the hydrogen in the hydroxyl group is replaced by an alkyl or aryl group, often responsible for the aroma of fruits.

Transesterification

A chemical reaction in which an ester is transformed into another ester through the exchange of the alkoxy group.

Methyl Benzoate

An ester formed from methanol and benzoic acid, commonly used in perfumery and flavorings.

Sodium Ethoxide

A strong base formed by the reaction of ethanol with sodium metal, commonly used in organic synthesis.