On the Sales sheet, sort the data using a Custom sort. First, sort by Customer# and then by PO Number using the default values for Sort On and Order.
Added by Victor Manuel L.
Step 1
g., Microsoft Excel, Google Sheets). Show more…
Show all steps
Your feedback will help us improve your experience
Kirsty Gledhill and 81 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
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
Kirsty G.
Nicole S.
(1) For which items are there at least 5 units in quantity on hand? (2) List the invoice number, dates, and salesperson for sales made to Rodney Wern. (3) List the dates, description, and quantity for each transaction in which Stainless-color appliances were sold in October. (4) List description and sum of quantity of inventory types that sold 2 or more units in October. (5) List sale date and invoice total for each invoice in October. (6) List total sales ($) by salesperson in October, sorted by largest sales amount to smallest. (7) Report total sales ($) by state. (8) Compute the markdown for each item sold. Calculate markdown as (SoldPrice-ListPrice)/ListPrice. List description, color, and average markdown by types and colors, sorted by largest average markdown (most negative) to smallest.
Akash M.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD