Solved

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? ?  Customer ID First Last Sales Quantity Discount Profit  CG-12520  Claire  Gute $261.9620$41.91 DV-13045  Darrin  VanHuff $14.6220$16.87 SO-20335  Sean  O’Donnell $9557.5850.45$(383.03)  BH-11710  Brosina  Hoffman $48.8670$14.17 AA-10480  Andrew  Allen $25.5530.2$5.44 IM-15070  Irene  Maddox $407.9830.2$132.59 HP-14815  Harold  Pawlan $68.8150.8$(123.86)  PK-19075  Pete  Kriz $665.8860$13.32 AG-10270  Alejandro Grove $55.5020$9.99 ZD-21925  Zuschuss  Donatelli $8.5620$2.48\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.

Correct Answer:

verifed

Verified

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

Related Questions