Assignment 2
You are going to create a workbook that keeps track of sales
revenue, costs of goods sold (COGS), and gross margin for each of your products.
You sell three products: Antiques, Bellows, and Computers. You will need five
worksheets named as follows: January, February, March, Quarter 1A, and Quarter
1B.
Each monthly worksheet needs columns for the item name, sales
revenue, COGS, and gross margin. You will also need a row for each of the three
products.
The sales revenue and COGS for each product are user input
cells in all three months. Makeup and enter amounts in all of the user input
cells.
Add data validation for all of the input cells so that:
The user inputs must be >=0
The user inputs must be whole numbers
Create an appropriate Input Message
Use the Warning style of Error Alert
Create an appropriate Error Message
Create formulas to calculate the gross margin for each
product in January, February, and March.
On the Quarter 1A worksheet, consolidate the January,
February, and March worksheets using the consolidate by category method.
Consolidate the data such that if the user input cells are changed, then the
consolidated amounts properly update.
On the Quarter 1B worksheet, consolidate the January,
February, and March worksheets using the consolidate by position method.
Consolidate the data such that if the user input cells are changed, then the
consolidated amounts do not update.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|