[练习题]【综合1系(2期)1班】第四讲作业上交贴(10组)

厉害厉害

<p>在哪里交？？？</p>

好凤凰

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

晴空

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

小名叫Tahan

<table cellspacing="0" cellpadding="0" width="751" border="0" xstr="" style="WIDTH: 563pt; BORDER-COLLAPSE: collapse;"><tbody><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" width="11" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 8pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font color="#ff0000"></font></td><td class="xl22" width="740" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 555pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体"><font color="#ff0000">1、用文字说明用excel处理数据的最佳格式是什么:<font class="font6">常规格式。</font></font></font></font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体"><font color="#ff0000">2、什么是字段:<font class="font6">数据库中表的列称之为字段。</font></font></font></font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体"><font color="#ff0000">3、ture与false用数字如何表示:<font class="font6">数值运算中,false=0,ture=1</font></font></font></font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体"><font color="#ff0000">4、ture、false与1、0是一回事么:<font class="font6">不完全相同，逻辑数值运算时零值为false，非零值为ture.</font></font></font></font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体"><font color="#ff0000">5、说出/、+、%、&amp;、&gt;的运算顺序:<font class="font6">%、/、+、&amp;、&gt;</font></font></font></font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体"><font color="#ff0000">6、如何用公式拖动，使i8：i16全部为exceljy:<font class="font6">在I8单元格编辑栏输入=$h$8,回车，下拉。</font></font></font></font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2">7、说出以下错误值所表示的原因</font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体"><font color="#ff0000">#DIV/0!原因：<font class="font6">公式试图使用0作为除数</font></font></font></font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体"><font color="#ff0000">#NAME?原因：<font class="font6">公式使用了一个错误的名称</font></font></font></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl23" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体"><font color="#ff0000">#N/A原因：<font class="font6">公式中引用的单元格中使用NA函数所标识的不能使用的数据。</font></font></font></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl23" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体"><font color="#ff0000">#NUM!<font class="font6">原因：与值有关的错误</font></font></font></font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl23" height="32" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 24pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl24" width="740" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 555pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2">8、f4和f9的作用是什么：</font><font class="font6"><font face="宋体" color="#ff0000" size="2">F4的功能 1：F4可以重复前一次操作 2：在公式编辑栏，相对引用和绝对引用来回切换。<br/>F9的功能:在编辑栏中，选中公式或公式的一部分，按F9可以直接显示结果。</font></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl23" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2">附加题：</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl23" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2"></font></td><td class="xl22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000" size="2">9、理解公式审核工具条中的内容:</font></td></tr></tbody></table>

wxldxx

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

vbyou127

fddsdsds