| 有一投資組合, 其中台積電佔50%, 聯電佔30%, 華邦電佔20%, 若今日收盤時台積電漲2%, 聯電漲1%, 華邦電跌3%, |
| 則投資組合漲跌幅為多少? (請用Excel設公式計算出答案) | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| Question 2: | | | | | | | | | | | | | |
| Please refer to the following chart: | | | | | | | | | | |
| (1) Calculate the percentage of monthly sales growth in 2010 (MoM Change%), | | | | |
| (2) Draw a line chart with monthly sales growth (%) of each product. | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| Sales of consumer electronics in 2010 (units) | | | | | | | | | |
  | | | | | | | | | | | | | |
| Jan. | Feb. | Mar. | Apr. | May | June | July | Aug. | Sep. | Oct. | Nov. | Dec. | |
|
| TV | 5 | 5 | 3 | 4 | 2 | 2 | 2 | 4 | 3 | 5 | 5 | 6 | |
| Refrigerator | 7 | 6 | 7 | 4 | 3 | 4 | 3 | 3 | 1 | 6 | 5 | 6 | |
| Washer | 10 | 10 | 7 | 9 | 9 | 8 | 7 | 5 | 4 | 5 | 6 | 4 | |
| Air-conditioner | 2 | 1 | 4 | 7 | 11 | 11 | 13 | 14 | 12 | 9 | 3 | 2 |