[ 习题 ] 【函入5期1班】第1讲作业上交贴（6组）

宜儿6795

游客，如果您要查看本帖隐藏内容请回复

[此贴子已经被作者于2010-1-12 13:29:01编辑过]

小华970403

<table cellspacing="0" cellpadding="0" width="83" border="0" style="WIDTH: 62pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="83" style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2656;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="83" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 62pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2">第一题：=ROW(A1)&amp;"X"&amp;COLUMN(A1)&amp;"="&amp;ROW(A1)*COLUMN(A1)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2">第二题：合计销量=SUBTOTAL(9,D28:D36)，平均销量=ROUND(SUBTOTAL(1,D28:D36),2)，最大销量=SUBTOTAL(4,D28:D36)，最小销量=SUBTOTAL(5,D28:D36)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><p><font face="Tahoma" size="2">第三题：=(C71&lt;=100000)*0.01*C71+(C71&gt;100000)*(C71*0.02-100000*0.01)</font></p><p><font face="Tahoma" size="2">怎么找不到回复可见贴的按钮啊？</font></p></td></tr></tbody></table>

vbyou127

fdsdfsdfs

DELL458458

你好。