【基础1系1班】第二讲作业上交贴（1组）

茹杨

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

</p><p><font color="#ff0000">必2:是在未有数据之前设置用的</font></p><p><font color="#ff0000">必3,4未说出格式代码&nbsp; 必5:不对</font></p><p><font color="#ff3300" size="5">未用回复可见帖</font></p>

[此贴子已经被yuhai0012于2008-3-23 21:34:44编辑过]

曾遇见未再见

<p>

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

</p><p><font color="#ee3d11">必做题1、2对</font></p><p><font color="#ee3d11">其余你再重新想想……写的也太简单了吧</font></p><p><font color="#ee3d11">加油啊</font></p><p><font color="#ee3d11">其实第五题开始没读懂题意，是问了别的学员才会的，汗一个</font></p><p><font color="#ee3d11">谢谢批改作业！</font></p>

[此贴子已经被作者于2008-3-26 21:42:31编辑过]

曾遇见未再见

<p>谢谢老师批改作业</p>[em22]

guideming

<p>前来批改作业</p>

xchw1818

看看答案........不是偷看噢...........

布衣族

<table cellspacing="0" cellpadding="0" width="789" border="0" xstr="" style="WIDTH: 593pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="38" style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1216;"></col><col></col><col></col><col></col><col width="5" style="WIDTH: 4pt; mso-width-source: userset; mso-width-alt: 160;"></col><col></col><col></col><col></col><col width="83" style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2656;"></col><col></col><col></col><col></col><col width="4" style="WIDTH: 3pt; mso-width-source: userset; mso-width-alt: 128;"></col><col></col><col></col><col></col><col width="39" style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1248;"></col><col></col><col></col><col></col><col width="6" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 192;"></col><col></col><col></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="7" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 224;"></col><col></col><col></col><col></col><col width="104" style="WIDTH: 78pt; mso-width-source: userset; mso-width-alt: 3328;"></col><col></col><col></col><col></col><col width="6" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 192;"></col><col></col><col></col><col></col><col width="85" style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 2720;"></col><col></col><col></col><col></col><col width="7" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 224;"></col><col></col><col></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="6" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 192;"></col><col></col><col></col><col></col><col width="111" style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3552;"></col><col></col><col></col><col></col><col width="7" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 224;"></col><col></col><col></col><col></col><col width="137" style="WIDTH: 103pt; mso-width-source: userset; mso-width-alt: 4384;"></col><col></col><col></col><col></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" width="789" colspan="17" height="40" rowspan="2" style="BORDER-RIGHT: #3366ff 1.5pt solid; BORDER-TOP: #3366ff 1.5pt solid; BORDER-LEFT: #3366ff 1.5pt solid; WIDTH: 593pt; BORDER-BOTTOM: #3366ff 1.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: transparent;"><font face="宋体"><font size="2">必做一题操作过程：选中B12:R12,点右键→设置单元格格式→对齐→文本控制→合并单元格,再选择文本对齐方式,选择居中(水平和垂直对齐都是选择居中)<font color="#d52b6f">不能用合并单元格</font></font></font></td></tr><tr height="20" style="HEIGHT: 15pt;"></tr></tbody></table><table cellspacing="0" cellpadding="0" width="789" border="0" xstr="" style="WIDTH: 593pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="38" style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1216;"></col><col></col><col></col><col></col><col width="5" style="WIDTH: 4pt; mso-width-source: userset; mso-width-alt: 160;"></col><col></col><col></col><col></col><col width="83" style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2656;"></col><col></col><col></col><col></col><col width="4" style="WIDTH: 3pt; mso-width-source: userset; mso-width-alt: 128;"></col><col></col><col></col><col></col><col width="39" style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1248;"></col><col></col><col></col><col></col><col width="6" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 192;"></col><col></col><col></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="7" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 224;"></col><col></col><col></col><col></col><col width="104" style="WIDTH: 78pt; mso-width-source: userset; mso-width-alt: 3328;"></col><col></col><col></col><col></col><col width="6" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 192;"></col><col></col><col></col><col></col><col width="85" style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 2720;"></col><col></col><col></col><col></col><col width="7" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 224;"></col><col></col><col></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="6" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 192;"></col><col></col><col></col><col></col><col width="111" style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3552;"></col><col></col><col></col><col></col><col width="7" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 224;"></col><col></col><col></col><col></col><col width="137" style="WIDTH: 103pt; mso-width-source: userset; mso-width-alt: 4384;"></col><col></col><col></col><col></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt;"><td class="xl25" width="789" colspan="17" height="40" rowspan="2" style="BORDER-RIGHT: #3366ff 1.5pt solid; BORDER-TOP: #3366ff 1.5pt solid; BORDER-LEFT: #3366ff 1.5pt solid; WIDTH: 593pt; BORDER-BOTTOM: #3366ff 1.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">必做二题操作过程：选择B12:B16,点右键→设置单元格格式→数字→文本</font></td></tr><tr height="20" style="HEIGHT: 15pt;"></tr></tbody></table><table cellspacing="0" cellpadding="0" width="789" border="0" xstr="" style="WIDTH: 593pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="38" style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1216;"></col><col></col><col></col><col></col><col width="5" style="WIDTH: 4pt; mso-width-source: userset; mso-width-alt: 160;"></col><col></col><col></col><col></col><col width="83" style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2656;"></col><col></col><col></col><col></col><col width="4" style="WIDTH: 3pt; mso-width-source: userset; mso-width-alt: 128;"></col><col></col><col></col><col></col><col width="39" style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1248;"></col><col></col><col></col><col></col><col width="6" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 192;"></col><col></col><col></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="7" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 224;"></col><col></col><col></col><col></col><col width="104" style="WIDTH: 78pt; mso-width-source: userset; mso-width-alt: 3328;"></col><col></col><col></col><col></col><col width="6" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 192;"></col><col></col><col></col><col></col><col width="85" style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 2720;"></col><col></col><col></col><col></col><col width="7" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 224;"></col><col></col><col></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="6" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 192;"></col><col></col><col></col><col></col><col width="111" style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3552;"></col><col></col><col></col><col></col><col width="7" style="WIDTH: 5pt; mso-width-source: userset; mso-width-alt: 224;"></col><col></col><col></col><col></col><col width="137" style="WIDTH: 103pt; mso-width-source: userset; mso-width-alt: 4384;"></col><col></col><col></col><col></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt;"><td class="xl25" width="789" colspan="17" height="40" rowspan="2" style="BORDER-RIGHT: #3366ff 1.5pt solid; BORDER-TOP: #3366ff 1.5pt solid; BORDER-LEFT: #3366ff 1.5pt solid; WIDTH: 593pt; BORDER-BOTTOM: #3366ff 1.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">必做三题操作过程：选择J16:J24,点右键→设置单元格格式→数字→自定义→yyyy-m-d,把它改成yyyy-mm-dd，即可</font></td></tr><tr height="20" style="HEIGHT: 15pt;"><font face="宋体" size="2"></font></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl25" colspan="17" height="40" rowspan="2" style="BORDER-RIGHT: #3366ff 1.5pt solid; BORDER-TOP: #3366ff 1.5pt solid; BORDER-LEFT: #3366ff 1.5pt solid; BORDER-BOTTOM: #3366ff 1.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">必做四题操作过程：选取Ｐ16：P24，点右键→设置单元格格式→数字→自定义，在类型那里输入格式###-########，再按确定即可</font></td></tr><tr height="20" style="HEIGHT: 15pt;"><font face="宋体" size="2"></font></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl25" colspan="17" height="40" rowspan="2" style="BORDER-RIGHT: #3366ff 1.5pt solid; BORDER-TOP: #3366ff 1.5pt solid; BORDER-LEFT: #3366ff 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 30pt; BACKGROUND-COLOR: transparent;"><p><font face="宋体" size="2">必做五题操作过程：点击B32,按住SHIFT键的同时点击B46,就可以了&nbsp; <font color="#d54d2b">不是快捷方式！</font></font></p></td></tr><tr height="20" style="HEIGHT: 15pt;"></tr></tbody></table><font face="黑体" color="#dd4822" size="4">必做题两题再看一下，选做题未做！</font>

[此贴子已经被冰冰草莓于2008-3-27 16:11:41编辑过]

vbyou127

5995665