Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
查看: 4042|回复: 14

[通知] [公告](二期)一系4班第四讲5组作业上交专贴

[复制链接]
 楼主| 发表于 2008-10-3 21:46 | 显示全部楼层 |阅读模式
<div style="MARGIN-TOP: 10px; FONT-SIZE: 9pt; MIN-HEIGHT: 200px; WORD-BREAK: break-all; TEXT-INDENT: 24px; LINE-HEIGHT: normal; WORD-WRAP: break-word;"><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">5组的同学来此交作业啦!!!!</span></strong></font></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"></span></strong></font>&nbsp;<font size="3"><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">作业上交要求<span lang="EN-US">:</span></span></strong><span lang="EN-US" style="FONT-SIZE: 9pt;"> <p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span lang="EN-US" style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">1</span></strong><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">、作业要:<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=72107">参见学委的作业贴</a>。</span></strong><span lang="EN-US" style="FONT-SIZE: 9pt;"> <p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span lang="EN-US" style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">2</span></strong><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">、</span></strong></font><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;">按题写清楚操作步骤</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; COLOR: blue; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体;"><font face="宋体, MS Song">(</font></span></strong><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;">可传演示动画</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; COLOR: blue; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体;"><font face="宋体, MS Song">)</font></span></strong><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;">,不要上传附件</span></strong></p><p><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;"><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><font color="#ff0000">&nbsp;&nbsp; 前面4个全对的BB分别为:<font size="4">5,4,3,2</font>,其他交了作业不全错的每人<font size="4">1</font>个BB。有效时间参见学委的作业贴</font></span></span></strong></p><p><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;"><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"></span></span></strong><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;">非本组交作业的学员请勿跟贴,否则即删扣分。</span></strong></p></div>
excel精英培训的微信平台,每天都会发送excel学习教程和资料。扫一扫明天就可以收到新教程
发表于 2008-10-4 19:05 | 显示全部楼层

<p>
游客,如果您要查看本帖隐藏内容请回复
</p><p><strong><font color="#ff0000">OK</font></strong></p>
[此贴子已经被一剑惊心于2008-10-5 18:56:39编辑过]
回复

使用道具 举报

发表于 2008-10-4 22:32 | 显示全部楼层

游客,如果您要查看本帖隐藏内容请回复
</p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">1.=SUM($A2,B$1)<p></p></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">2</font></span><span lang="EN-US" style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体;">.</span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体;">①</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">Alt+i</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">——函数——选择函数——确定</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 7pt; mso-char-indent-count: .5;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">②在编辑栏输入函数</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">3.</font></span><span lang="EN-US" style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;"> PCODUCT<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span>SUMPRODUCT<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp; </span>MMULT<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>DPRODUCT </span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;">(</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;">在函数集合里找到这几</span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt;">个)<span lang="EN-US"><p></p></span></span></p><p style="MARGIN-LEFT: 14pt; WORD-BREAK: break-all; TEXT-INDENT: -14pt; mso-char-indent-count: -1.0;"><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="宋体">4.</font></span><span style="FONT-SIZE: 14pt;"><font face="宋体">① </font><font face="宋体"><span lang="EN-US">=CONCATENATE(D25,B25,E25,C25,A25)<br/></span>②<span lang="EN-US"> =D25&amp;B25&amp;E25&amp;C25&amp;A25<p></p></span></font></span></p><p></p>[/hide]
回复

使用道具 举报

发表于 2008-10-5 13:51 | 显示全部楼层

[练习题]交作业

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

使用道具 举报

发表于 2008-10-5 16:13 | 显示全部楼层

[em01]
回复

使用道具 举报

发表于 2008-10-5 18:56 | 显示全部楼层

标记
回复

使用道具 举报

发表于 2008-10-6 21:25 | 显示全部楼层

<p>交作业:</p><p>
游客,如果您要查看本帖隐藏内容请回复
</p><p><strong><font color="#ff0033">OK</font></strong></p>
[此贴子已经被一剑惊心于2008-10-7 19:00:49编辑过]
回复

使用道具 举报

发表于 2008-10-7 07:20 | 显示全部楼层

看看
回复

使用道具 举报

发表于 2008-10-7 07:29 | 显示全部楼层

[练习题]课后作业

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

使用道具 举报

发表于 2008-10-7 07:54 | 显示全部楼层

[em01][em01]
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-4-28 00:39 , Processed in 0.311013 second(s), 4 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表