A.=SUM(A1:A3)
B.=SUM(B1:B3)
C.=SUM(A1:B3)
D.=SUM(D1:D3)
A.=A1/SUM($A1:$D1)
B.=A1/SUM(A1:$D$1)
C.=A1/SUM(A$1E$1)
D.=A1/SUM(A1:D1)
A.=AVERAGE(A1:A8)
B.=SUM(A1:A8)
C.=AVERAGE(A1,A8)
D.=SUM(A1,A8)
A.10,4.5
B.10,10
C.18,4.5
D.18,10
A.拖动滚动条
B.在名称框输入Y100,按回车键
C.按Ctrl+Y100键
D.先用Ctrl+→键移到Y列,再用Ctrl+↓移到100行