回复:求助microsoft excel用法

来源: 鸡毛蒜皮 2006-07-18 17:31:04 [] [博客] [旧帖] [给我悄悄话] 本文已被阅读: 0 次 (537 bytes)
Let's say that you have all the data in colume A.
In colume B, the Cell 100 (B100) type =Sum (A1:A100),
in colume C, the cell 100 (C100) type = STDEV (A1:A100).
If you want some other calculation, do the same in colume D, E,F... ...

Then select Cells (B100, C100, D100,... ..., whatever you have done), Copy (ctrl+C).
Select cell range (b200: XY) x is the letter of the last colume you have used, y is the last data,eg., 29758.
then ctrl p.

Done.

raw 200, 300, 400,... ... are the results you want!
请您先登陆,再发跟帖!

发现Adblock插件

如要继续浏览
请支持本站 请务必在本站关闭/移除任何Adblock

关闭Adblock后 请点击

请参考如何关闭Adblock/Adblock plus

安装Adblock plus用户请点击浏览器图标
选择“Disable on www.wenxuecity.com”

安装Adblock用户请点击图标
选择“don't run on pages on this domain”