我将这些数据保存在Excel中
根据左边的数据得到最小值、最大值和平均值的公式,与公司无关。
Product Company Price
Keyboard A 50
Keyboard B 10
Keyboard C 30
Mouse A 100
Mouse B 50
Printer A 75
Printer B 100
Printer C
我有以下Excel电子表格:
A B C D
1 Product A 500 Product A 500
2 Product B 800 Product A 700
3 Product C 450 Product A 300
4 Product A 700 Product B 800
5 Product A 300 Product B 400
6