[40pts!!] excel問題

Pivot table
A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet.

http://www.cpearson.com/excel/pivots.htm

Scenarios
f you have more than one unknown variable in your spreadsheet, you can set up a Scenario that controls those cells in the formulas or functions that you want.

http://www.uic.edu/depts/accc/seminars/excel2000-intermed/scenarios.html

Solver
http://www.econ.ucla.edu/riley/104/LPSolver(IE).htm

2007-05-02 10:10:56 補充：
以上綱全部有圖 英文