Question: Make an excel table with 18 records, listing the goods sold by your company during the last three years. Order ID Year Product type Units
- Make an excel table with 18 records, listing the goods sold by your company during the last three years.
| Order ID | Year | Product type | Units sold | Price/Unit | Cost/Unit | Revenue | Profit |
| 1 | 2020 |
|
|
|
|
|
|
| 2 | 2020 |
|
|
|
|
|
|
| 3 | 2020 |
|
|
|
|
|
|
| 4 | 2020 |
|
|
|
|
|
|
| 5 | 2020 |
|
|
|
|
|
|
| 6 | 2020 |
|
|
|
|
|
|
| 7 | 2021 |
|
|
|
|
|
|
| 8 | 2021 |
|
|
|
|
|
|
| 9 | 2021 |
|
|
|
|
|
|
| 10 | 2021 |
|
|
|
|
|
|
| 11 | 2021 |
|
|
|
|
|
|
| 12 | 2021 |
|
|
|
|
|
|
| 13 | 2022 |
|
|
|
|
|
|
| 14 | 2022 |
|
|
|
|
|
|
| 15 | 2022 |
|
|
|
|
|
|
| 16 | 2022 |
|
|
|
|
|
|
| 17 | 2022 |
|
|
|
|
|
|
| 18 | 2022 |
|
|
|
|
|
|
- Fill in the table with RANDOM values for: Product type Units sold Price/Unit Cost/Unit Revenue Profit
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help