设为首页收藏本站

开启辅助访问

Excel精英培训网»论坛 › Excel 培训班 › Excel 函数初级班 › [注意]函4第11讲作业上交贴（7，8，9组）

数据透视表40+个常用小技巧，让你一次学会！

12 / 2 页下一页

发新帖

查看: 3724|回复: 19

[通知] [注意]函4第11讲作业上交贴（7，8，9组）

发表于 2009-12-25 14:16 | 显示全部楼层 |阅读模式

工作中常用的Excel函数公式，全印在一张超大鼠标垫上

<p><font color="#ff6600" size="3"><strong>1、请用回复可见贴形式上交作业</strong></font></p><p><font color="#ff6600" size="3"><strong>2、非本组成员严禁回复，一经发现按抄袭论处，删贴扣币币。</strong></font></p><p><font color="#ff6600" size="3"><strong>3、作业提交截止时间：上课前一天18：00</strong></font></p><p><font size="3"><strong><font color="#ff6600">4 、交白卷的视为未交作业。</font></strong></font></p><p><strong><font color="#ff6600" size="3">5、报上组别编号</font></strong></p>

回复

使用道具举报

工作中最常用的函数公式，全印在一张超大的鼠标垫上

发表于 2009-12-25 22:13 | 显示全部楼层

工作中常用的Excel函数公式，全印在一张超大鼠标垫上

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

[此贴子已经被liyh67于2009-12-28 13:15:11编辑过]

回复

使用道具举报

发表于 2009-12-26 00:32 | 显示全部楼层

工作中最常用的Excel函数公式，全印在一张鼠标垫上

<p>

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

</p><p></p><p></p>

回复

使用道具举报

发表于 2009-12-26 00:32 | 显示全部楼层

<table width="649" border="0" cellspacing="0" cellpadding="0" style="WIDTH: 487pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" span="8" style="WIDTH: 54pt;"></col><col width="73" style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2336;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="72" height="19" class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">　</font></td><td width="72" class="xl68" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">D</font></td><td width="72" class="xl68" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">E</font></td><td width="72" class="xl68" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">F</font></td><td width="72" class="xl68" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">G</font></td><td width="72" class="xl68" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">H</font></td><td width="72" class="xl68" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">I</font></td><td width="72" class="xl68" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">J</font></td><td width="73" class="xl68" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 55pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">K</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" class="xl68" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">20</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">性别</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">电话补贴</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">部门</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">合计</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">岗位津贴</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">基本工资</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">部门</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">　</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" class="xl68" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">21</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">男</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">>180</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">B</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">>=3100</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">>200</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">>2000</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">B</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font class="font6" face="宋体">=(B2="B")*(E2>2000)</font></td></tr></tbody></table>

回复

使用道具举报

发表于 2009-12-26 16:48 | 显示全部楼层

<p>

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

</p><p></p>

回复

使用道具举报

发表于 2009-12-26 23:14 | 显示全部楼层

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

回复

使用道具举报

发表于 2009-12-28 13:16 | 显示全部楼层

[em01][em01]

回复

使用道具举报

发表于 2009-12-29 22:13 | 显示全部楼层

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

7组104 linken_1840上交作业

回复

使用道具举报

发表于 2009-12-30 16:39 | 显示全部楼层

函入4期8组员110号交作业

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

回复

使用道具举报

发表于 2009-12-30 17:36 | 显示全部楼层

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

回复

使用道具举报

12 / 2 页下一页

发新帖

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

GMT+8, 2024-5-9 10:33 , Processed in 0.266217 second(s), 5 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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