1期透视表快速入门班作业贴—[学号1-45号]

轩辕轼轲 · 发表于 2010-10-18 22:28

1：作业尽量通过自己思考独立完成，不会的可在同学之间私聊讨论，禁止在QQ群公开索要答案。2：作业以回复可见方式提交，上交后不得编辑修改，否则按抄袭论。3：禁止非本组学员回复，任何以马甲抄袭他人作业一经发现，删帖、扣BB。4：有不能正确修改头衔的学员，请在作业贴或者签名中注明组别和学号。作业上交以后再投票。回复可见及头衔修改操作方法见：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=114926" target="_blank">http://www.excelpx.com/forum.php?mod=viewthread&tid=114926</a>作业批改记录及评语：<table cellspacing="0" cellpadding="0" width="702" border="0" style="WIDTH: 527pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="38" style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1216;"></col><col width="91" style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 2912;"></col><col width="216" style="WIDTH: 162pt; mso-width-source: userset; mso-width-alt: 6912;"></col><col width="357" style="WIDTH: 268pt; mso-width-source: userset; mso-width-alt: 11424;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="38" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ff6600 0.5pt solid; WIDTH: 29pt; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">学号</td><td class="xl24" width="91" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ebe9ed; WIDTH: 68pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">ID</td><td class="xl28" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">总评</td><td class="xl28" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">细节点评</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">1</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">厦门行</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">全部正确，完美的解答</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">所有操作都正解</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">2</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">lxx822</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">全部正确，完美的解答</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">所有操作都正解</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">3</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl26" align="right" height="32" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: white;">4</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">ddcl</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">虽然漏了细节，但总体上符合要求</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">作业1中隐藏一三科的操作未做，其他所有操作都达到要求，并且正解</td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl26" align="right" height="32" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: white;">5</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">StudyUP</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">注意作业题目，漏掉了两个操作</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">在第一个题目中，没有将每列显示3个字段，并且没有进行分页显示的操作。漏掉了两个操作，其他操作正确。</td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl26" align="right" height="32" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: white;">6</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">林玲玲</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">大部分符合要求，注意完成细节</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">在透视表活用操作中，未能统计出每行非空单元格的个数，第二个作业中，大纲显示后未能插入空白行，其他操作正解</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">7</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">tiankongwuy</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">全部正确，完美的解答</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">所有操作都正解</td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl26" align="right" height="32" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: white;">8</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">wengrobert</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">上交的作业不完整</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">第一题没有进行分页操作，第二个作业中未能将“求和项”替换，数据表活用的作业未见上传</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">9</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">鹤雪</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">全部正确，完美的解答</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">所有操作都正解</td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl26" align="right" height="32" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: white;">10</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">新手之家</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">上传的作业不完整</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">第一题没有进行分页操作，第二个作业中未能将“求和项”替换，数据表活用的作业未见上传</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">11</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">红心</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">全部正确，完美的解答</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">所有操作都正解</td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl26" align="right" height="32" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: white;">12</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">yuelin21720</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">上传的作业不完整</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">第一题没有进行分页显示，第二题第一步上传的压缩包无法正确解压</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">13</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">禾火亦</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">全部正确，完美的解答</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">所有操作都正解</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">14</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">15</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">adinge</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">大部分符合要求，注意完成细节</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">除了第一个作业中的分页显示的要求未操作，其他操作都完成。</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">16</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">岸芷汀兰</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">大部分符合要求，注意完成细节</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">除了第一个作业中的分页显示的要求未操作，其他操作都完成。</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">17</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">轩轩的祝福</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">符合作业要求，注意完成细节要求</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">除了未能将透视表中“（空白）”消除，其他操作全部完成。　</td></tr><tr height="48" style="HEIGHT: 36pt;"><td class="xl26" align="right" height="48" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 36pt; BACKGROUND-COLOR: white;">18</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">songlo407</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">大部分符合要求，注意完成细节</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">第一个作业中的分页显示的要求未操作，第二个作业中未能将透视表中“（空白）”消除，数据表活用中没有按照要求做出统计。</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">19</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">20</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">liutian</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">21</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">22</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">Stradivarius</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">操作非常熟练，作业完成的非常好</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">全部正确无误</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">23</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">深蓝00</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">大部分符合要求，注意完成细节</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">除了第一个作业中的分页显示的要求未操作，其他操作都完成。</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">24</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">薄荷蓝</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">操作都正确，完成的很好</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">全部正确</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">25</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">35°6</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">大部分符合要求，注意完成细节</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">除了第一个作业中的分页显示的要求未操作，其他操作都完成。</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">26</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">27</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">28</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">29</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">宁波：小天</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">操作都正确，完成的很好</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">全部正确</td></tr><tr height="48" style="HEIGHT: 36pt;"><td class="xl26" align="right" height="48" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 36pt; BACKGROUND-COLOR: white;">30</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">7°</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">大部分符合要求，注意完成细节</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">第一次提交的作业漏掉了一个项目，经提醒后补交，该同学数据透视表操作流畅熟练，作业1中的分页显示未操作,隐藏一三科的操作未做，其他操作正解。</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">31</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">32</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">33</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">34</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">35</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">36</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl26" align="right" height="32" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: white;">37</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">anniequeenie</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">上交的作业不完整</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">没有进行分页操作和每列显示3个字段的操作，透视表活用的作业没有上传</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">38</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">39</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">pixyhoney</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">大部分符合要求，注意完成细节</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">第二个作业漏掉了插入分页符的操作，其他的都正确</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">40</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl26" align="right" height="32" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: white;">41</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">crz258824165</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">上交的作业不完整</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">第二个作业中未能将“求和项”替换，数据透视表活用的作业未上传</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">42</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">43</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">44</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">玉玺</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">大部分符合要求，注意完成细节</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">第二题中未能将“求和项:"消除，其他都正确。</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" height="19" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;">45</td><td class="xl27" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="216" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 162pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td><td class="xl29" width="357" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 268pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: white;">　</td></tr></tbody></table>

[此贴子已经被作者于2010-10-25 15:43:47编辑过]

7° · 发表于 2010-10-19 11:48

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

作业没能达到示例图效果，虽然作业2的第1小题在6楼做了补充，但仍然没有完全达到要求。

[此贴子已经被dongqing1998于2010-10-19 21:29:30编辑过]

dongqing1998 · 发表于 2010-10-19 15:59

来看作业

ddcl · 发表于 2010-10-19 16:34

01004：ddcl 作业

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

作业1中隐藏一三科的操作未做，其他所有操作都达到要求，基本正确

[此贴子已经被泡泡于2010-10-24 17:21:42编辑过]

林玲玲 · 发表于 2010-10-19 16:40

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

在透视表活用操作中，未能统计出每行非空单元格的个数，第二个作业中，大纲显示后未能插入空白行，其他操作正确

[此贴子已经被轩辕轼轲于2010-10-19 21:35:29编辑过]

7° · 发表于 2010-10-19 18:43

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

第一次提交的作业漏掉了一个项目，经提醒后补交，该同学数据透视表操作流畅熟练，作业1中的分页显示未操作,隐藏一三科的操作未做，其他操作正解。

[此贴子已经被轩辕轼轲于2010-10-19 21:33:11编辑过]

tiankongwuy · 发表于 2010-10-19 21:01

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

非常好，所有的操作都正确

[此贴子已经被轩辕轼轲于2010-10-19 21:34:11编辑过]

Stradivarius · 发表于 2010-10-19 22:16

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

完全正确，非常棒

[此贴子已经被轩辕轼轲于2010-10-19 23:07:22编辑过]

轩轩的祝福 · 发表于 2010-10-20 10:55

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

一次只能传两个[em06]

轩轩的祝福 · 发表于 2010-10-20 11:14

终于又可以了

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

[em06]点评：整体完成的不错，只是漏掉了一个细节，未能将透视表中的（空白）消除。

[此贴子已经被轩辕轼轲于2010-10-20 11:32:32编辑过]

		自动登录	找回密码
密码			注册

1期透视表快速入门班作业贴—[学号1-45号]

1期数透快入班02030交作业，请审阅。

01004：ddcl作业

01006林玲玲

补交做漏的题目，谢学委提醒--！

1期数透快入班08107交作业，请审阅