Sales Data By Region Using Totals, Sorting, And Table Filtering This is an INDIVIDUAL ASSIGNMENT in Microsoft Excel. You will create a sales data spreadsh
Sales Data By Region Using Totals, Sorting, And Table Filtering This is an INDIVIDUAL ASSIGNMENT in Microsoft Excel. You will create a sales data spreadsheet for a company of your choosing, and populate it with a sufficient amount of data to be able to use filtering, totals, and sorting. The completed spreadsheet is submitted via Canvas.
You need at least 9 columns and 12 rows (records). Column suggestions include:
Sale_ID: a unique field that represents the sale number
Date of the Sale
Product_ID: represents one of your products; you will create the actual products later
Size (or Color)
Quantity_Sold
Unit_Price: Remember, don’t type in the dollar signs! Use Excel formatting instead.
Customer: represents a customer that you will create later
Subtotal: Quantity_Sold * Unit_Price (use formulas!)
Sales_Tax: Some percentage * Subtotal
Item Total: Subtotal + Sales_Tax
You will turn in your Excel workbook with filtering on, showing all sales of one particular product.
