<table cellspacing="0" cellpadding="0" width="398" border="0" xstr="" style="WIDTH: 299pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="398" style="WIDTH: 299pt; mso-width-source: userset; mso-width-alt: 12736;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="398" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 299pt; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">1、数值型</font></td></tr><tr height="48" style="HEIGHT: 36pt;"><td class="xl25" width="398" height="48" xstr="2、字段是数据库中的数据表中的一列,数据表是由几个或几十个字段组成,是在记录中放置数据的,一个记录就可以放置不同的数据在不同的字段中,一个数据表就是由这样的记录组成的。 " style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 299pt; BORDER-BOTTOM: #ebe9ed; HEIGHT: 36pt; BACKGROUND-COLOR: transparent;"><font size="2"><font color="#0000ff"><font face="宋体">2、字段是数据库中的数据表中的一列,数据表是由几个或几十个字段组成,是在记录中放置数据的,一个记录就可以放置不同的数据在不同的字段中,一个数据表就是由这样的记录组成的。<span style="mso-spacerun: yes;"> </span></font></font></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">3、ture=1,false=0。</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">4、逻辑值,判断真假,ture=1为真,false=0为假。</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">5、%、/、+、&、></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">6、=$G$8</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">7、说出以下错误值所表示的原因</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">#DIV/0!=公式试图使用0作为除数</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">#NAME?=公式使用了一个错误的名称</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl25" width="398" height="32" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 299pt; BORDER-BOTTOM: #ebe9ed; HEIGHT: 24pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">#N/A=公式中引用的单元格中使用NA函数所标识的不能使用的数据。查找函数找不到匹配数据时。</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">#NUM!=与值有关的错误</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#0000ff" size="2">8、f4转换相对和绝对引用值,F9计算公式中的部分</font></td></tr></tbody></table>
[此贴子已经被作者于2008-8-8 15:36:37编辑过] |