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? Customer ID First Last Sales Quantity Discount Profit CG-12520 Claire Gute $261.96 2 0 $41.91 DV-13045 Darrin VanHuff $14.62 2 0 $16.87 SO-20335 Sean O'Donnell $957.58 5 0.45 ($383.03) BH-11710 Brosina Hoffman $48.86 7 0 $14.17 AA-10480 Andrew Allen $25.55 3 0.2 $5.44 IM-15070 Irene Maddox $407.98 3 0.2 $132.59 HP-14815 Harold Pawlan $68.81 5 0.8 ($123.86) PK-19075 Pete Kriz $665.88 6 0 $13.32 AG-10270 Alejandro Grove $55.50 2 0 $9.99 ZD-21925 Zuschuss Donatelli $8.56 2 0 $2.48 Use the Filter function to organize the data into order of sales. Use the Sort function to organize the data into order of sales. Use the Cut and Paste function to reorganize the data into order of sales. Use the Order function to organize the data into order of sales.

          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.96 2 0 $41.91
DV-13045 Darrin VanHuff $14.62 2 0 $16.87
SO-20335 Sean O'Donnell $957.58 5 0.45 ($383.03)
BH-11710 Brosina Hoffman $48.86 7 0 $14.17
AA-10480 Andrew Allen $25.55 3 0.2 $5.44
IM-15070 Irene Maddox $407.98 3 0.2 $132.59
HP-14815 Harold Pawlan $68.81 5 0.8 ($123.86)
PK-19075 Pete Kriz $665.88 6 0 $13.32
AG-10270 Alejandro Grove $55.50 2 0 $9.99
ZD-21925 Zuschuss Donatelli $8.56 2 0 $2.48

Use the Filter function to organize the data into order of sales.
Use the Sort function to organize the data into order of sales.
Use the Cut and Paste function to reorganize the data into order of sales.
Use the Order function to organize the data into order of sales.

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.96 2 041.91
DV-13045 Darrin VanHuff 14.62 2 016.87
SO-20335 Sean O'Donnell 957.58 5 0.45 (383.03)
BH-11710 Brosina Hoffman 48.86 7 014.17
AA-10480 Andrew Allen 25.55 3 0.25.44
IM-15070 Irene Maddox 407.98 3 0.2132.59
HP-14815 Harold Pawlan 68.81 5 0.8 (123.86)
PK-19075 Pete Kriz 665.88 6 013.32
AG-10270 Alejandro Grove 55.50 2 09.99
ZD-21925 Zuschuss Donatelli 8.56 2 02.48

Use the Filter function to organize the data into order of sales.
Use the Sort function to organize the data into order of sales.
Use the Cut and Paste function to reorganize the data into order of sales.
Use the Order function to organize the data into order of sales.

Added by Mark F.

Question

Please give Ace some feedback