函快二期学前练习题-计算库存量

QQ9947 · 发表于 2010-11-16 00:58

<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">题目：计算库存量<p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; DIRECTION: ltr; TEXT-INDENT: 0in; LINE-HEIGHT: 14pt; unicode-bidi: embed; TEXT-ALIGN: left; language: zh-CN; mso-line-height-rule: exactly;"><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">提示：库存量<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: en-US; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">=<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">入库累计<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: en-US; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">-<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">出库累计<p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; DIRECTION: ltr; TEXT-INDENT: 0in; LINE-HEIGHT: 14pt; unicode-bidi: embed; TEXT-ALIGN: left; language: zh-CN; mso-line-height-rule: exactly;"><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">要求：以“回复可见”的形式贴出<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: en-US; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">E3<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">单元格中的公式即可。<p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; DIRECTION: ltr; TEXT-INDENT: 0in; LINE-HEIGHT: 14pt; unicode-bidi: embed; TEXT-ALIGN: left; language: zh-CN; mso-line-height-rule: exactly;"><p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; DIRECTION: ltr; TEXT-INDENT: 0in; LINE-HEIGHT: 14pt; unicode-bidi: embed; TEXT-ALIGN: left; language: zh-CN; mso-line-height-rule: exactly;"><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">附：前<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: en-US; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">10<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">位正确答案的本班同学奖励<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: en-US; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">20BB/<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">人（非本班学员不送<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: en-US; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">BB<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">）。详见附件：

bpJrq1y5.rar (22.52 KB, 下载次数: 16)

清风无语 · 发表于 2010-11-16 07:31

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

wp8680 · 发表于 2010-11-16 07:41

抢个沙发没抢到。[em01][em01]老师出手就是大方，一次20币币。

[此贴子已经被作者于2010-11-16 7:46:23编辑过]

桂林灬迷失 · 发表于 2010-11-16 08:38

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

zhaoxuefang · 发表于 2010-11-16 08:53

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

zhaoxuefang · 发表于 2010-11-16 08:56

我自己来回复，看看能能不看到我的附件

飘零茉莉花 · 发表于 2010-11-16 09:28

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

hnnyfcykl · 发表于 2010-11-16 09:33

[em17]

hnnyfcykl · 发表于 2010-11-16 09:34

[em17]

ooshenghuo · 发表于 2010-11-16 09:46

<span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">老师：  <span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">我有三个公式都可以计算库存量  <span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">我的答案1<span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">是我最习惯用的公式  <span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">但我不是十分清楚它算不算函数公式  <span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">如果不算的话，那我的答案2<span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">和答案3<span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">应该是函数公式了  <span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">而且通过这道题引发我去想有没有一个专门计算“差”的函数  <span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">比如：有没有=Margin<span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">（）？，我搜索和用Excel<span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">尝试的结果好像是没有，  <span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">不知我的这个结论是否正确？  <span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">这些疑问希望能通过上您的课得到解决，  <span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">有劳老师辛苦解答问题、批改作业

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

---------------------------------------------------------------------------------------------------------答案错误，最后结果要与参考答案一致！另外，三个答案可以写到一个文件里上传，或者直接贴出三个公式，不用上传文件也行。

[此贴子已经被QQ9947于2010-11-17 22:06:25编辑过]

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

[通知] 函快二期学前练习题-计算库存量

函快二期二班 05062 清风