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

沙漠王子 · 发表于 2010-1-11 17:34

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

free72d · 发表于 2010-1-11 22:51

函数5期2组163：free72d的作业：

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

[em11][em11][em11]

木馬 · 发表于 2010-1-12 11:32

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

pEPzCVTR.rar (28.32 KB, 下载次数: 1)

man-hehe · 发表于 2010-1-12 11:39

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

y5Avc2sm.rar (28.32 KB, 下载次数: 1)

雨滴0531 · 发表于 2010-1-12 13:54

交作业

雨滴0531 · 发表于 2010-1-12 14:06

提交第一讲作业

幸运草009 · 发表于 2010-1-12 14:28

replyview]第一题：=row(A1)*column(A)第二题：合计销量=subtotal(9,D28:D36),然后往右拉             平均销量=round(subtotal(9,D28:D36))/9,然后往右拉            最大销量和最小销量就不懂了第三题：不懂第四题：不懂

美丽心情2008 · 发表于 2010-1-12 14:43

[hide]2组019美丽心情2008交作业第一题：<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">=ROW(A1)&"*"&COLUMN(A1)&"="&ROW(A1)*COLUMN(A1)<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">第二题：A、销售员李四销售统计，销售员选李四，李四合计销售=SUBTOTAL（109，D30：D35），之后向右填充<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">           李四平均销售=SUBTOTAL（101，D30：D35），之后向右填充<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">           李四最大销售=SUBTOTAL（104，D30：D35），之后向右填充<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">           李四最小销售=SUBTOTAL（105，D30：D35），之后向右填充<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">           B、1月份销售统计，月份先1月份，销售员选全部，1月份合计销售=SUBTOTAL（109，D28：D31），之后向右填充，后面的按照上面的依次类推， <span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">          C、销售员张三销售统计，销售员选张三，月份选全部，张三合计销售=SUBTOTAL（109，D28：D36），之后右填充，后面的按照上面的依次类推<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">           D、全年销售统计，销售员选全部，月份选全部，合计销售=SUBTOTAL（9，D28：D36），之后向填充<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">                    平均销售=SUBTOTAL（1，D28：D36），之后向右填充<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">                     最大销售=SUBTOTAL（4，D28：D36），之后向右填充<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">                     最小销售=SUBTOTAL（5，D28：D36），之后向右填充<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">第三题，第一个=（C71-100000）*0.002+100000*0.01，第二个向下填充，第三个=C73*0.01，后面依次类推<span lang="EN-US" style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><table border="0" cellspacing="0" cellpadding="0" width="675" style="WIDTH: 507pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="73" style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2336;"></col><col width="72" style="WIDTH: 54pt;"></col><col span="4" width="76" style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2432;"></col><col span="2" width="77" style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2464;"></col><col width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" width="73" align="right" xfmla="=MATCH(1,{1,2,3},)" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #33cccc; WIDTH: 55pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;">1</td><td class="xl68" width="224" colspan="3" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #99ccff; WIDTH: 168pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"> =MATCH(1,{1,2,3},)</td><td width="378" colspan="5" style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 284pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan;">返回的结果"1"是指"1"这个数值所在的位置是"1"</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" align="right" xfmla="=MATCH(1,{1,2,3})" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #33cccc; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;">1</td><td class="xl68" colspan="3" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #99ccff; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"> =MATCH(1,{1,2,3})</td><td colspan="3" style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8; mso-ignore: colspan;">返回的结果"1"</td><td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8;">是指"1"这个数值</td><td style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8;"></td></tr></tbody></table>[/replyview

美丽心情2008 · 发表于 2010-1-12 14:55

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

美丽心情2008 · 发表于 2010-1-12 15:02

2组019美丽心情2008交作业

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

		自动登录	找回密码
密码			注册

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

2组25号沙漠王子交作业

2组030:man-hehe交作业

交作业2组017

第一次交作业

交作业

交作业

交作业