Astro's Blog

哪吒之魔童鬧海

<div style="text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGGnrPgx42VmB1WMyOdQjMoUnaL0JSLJTzUHo_S2SvzBDiwwHzH6EHKeWS3iUmTy-KDSlG5m-1loAJDPDKY8_ZHUvybn47xeaC6SULlVwty5whJgVzQgdFEGSqLt-jzUYBEd912todgVJ3jtWEbh6H1LJvacjIUHkdTyBJ71CqcwSqu85MtMcsfMRDfmqD/s992/%E5%93%AA%E5%90%922.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-size: medium;"><img border="0" data-original-height="526" data-original-width="992" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGGnrPgx42VmB1WMyOdQjMoUnaL0JSLJTzUHo_S2SvzBDiwwHzH6EHKeWS3iUmTy-KDSlG5m-1loAJDPDKY8_ZHUvybn47xeaC6SULlVwty5whJgVzQgdFEGSqLt-jzUYBEd912todgVJ3jtWEbh6H1LJvacjIUHkdTyBJ71CqcwSqu85MtMcsfMRDfmqD/w640-h340/%E5%93%AA%E5%90%922.png" width="640" /></span></a></div><div style="text-align: left;"><span style="font-size: medium;"><br /></span></div><div style="text-align: left;"><span style="font-size: medium;">今天，終於迎來了國產3D動畫「哪吒之魔童鬧海」在香港上映！這部動畫在全球票房已突破130億人民幣，作為耗時五年精心製作的第二部作品，無疑成為中國動畫史上一個重要的里程碑。在前往影院之前，我特意重溫了它的第一集「哪吒之魔童降世」。這部2019年的作品已經讓我印象深刻，無論是劇情的深度還是動畫的流暢度，都展現了極高的水準。在此建議各位有意觀看第二部前，先回顧第一集，因為劇情及某些細節是相互連接，這樣會更容易理解故事的發展。</span></div><div style="text-align: left;"><span style="font-size: medium;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBMplNkWVr2bminwhua2nJYXcvgA3V0n6dB2rFzmJaBc4PVuSQhiy3JAXkzF9kkOqLcnWZqle2gnx6UPtYUwqoZUZi57UjhYzRr0mUg07gKaU_blOf1TQZwoKWycLC9DrG1LTDk7v6wbFixs39t3XMJmm9czp6-kf2rjacCuPHdxVfjCau97LNcuL85VzW/s1024/%E5%93%AA%E5%90%922b.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-size: medium;"><img border="0" data-original-height="427" data-original-width="1024" height="266" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBMplNkWVr2bminwhua2nJYXcvgA3V0n6dB2rFzmJaBc4PVuSQhiy3JAXkzF9kkOqLcnWZqle2gnx6UPtYUwqoZUZi57UjhYzRr0mUg07gKaU_blOf1TQZwoKWycLC9DrG1LTDk7v6wbFixs39t3XMJmm9czp6-kf2rjacCuPHdxVfjCau97LNcuL85VzW/w640-h266/%E5%93%AA%E5%90%922b.jpg" width="640" /></span></a></div><div style="text-align: center;"><span style="font-size: medium;"><br /></span></div><div style="text-align: left;"><span style="font-size: medium;"><span style="text-align: center;">在觀賞第二部時，我被它的動畫效果深深吸引，仿佛沉浸在一場令人讚嘆的視覺盛宴中。</span><span>故事劇情緊湊有序，較第一集更顯成熟。動作設計和場面設定讓人驚艷，令人目不暇給。此外，影片巧妙地穿插了許多幽默元素，恰到好處地為故事增添趣味。故事後半段更是感人至深，深刻展現了父母對兒子無條件以及無怨無悔的愛。</span></span></div><div style="text-align: center;"><span style="font-size: medium;"><br /></span></div><div style="text-align: left;"><span style="font-size: medium;">這部動畫的對象不僅限於小朋友，成年人也能從中獲得共嗚。它不僅是娛樂，更引發了對人性和道德的深思。故事表面上看似簡單，但深入挖掘後會發現，所謂的好人和壞人並不那麼明確。為了追求一己之欲而做出錯誤選擇，甚至傷害或犧牲身邊的人，讓人反思：在追求自身利益的同時，是否也能保持對他人的理解與包容？</span></div><div style="text-align: left;"><span style="font-size: medium;"><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5n-aChHpAvfu5-v37H-M-LV6GjeHSZwP9sMWpbnNMtdxv4YOsGaeNZbCny51elL5SmRsl3nXVUX4mUZQ6ZeF9HpiZHv7ajWsFS-sdKVJzi7bi5inkkldFdf18p87LyGh8TFUIwW6MlRXv1WSZTUQxaufdEFXOX-n6AnzJHJ-YRhSjJmugdeg1dlm2EEpN/s884/%E5%93%AA%E5%90%922c.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-size: medium;"><img border="0" data-original-height="495" data-original-width="884" height="358" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5n-aChHpAvfu5-v37H-M-LV6GjeHSZwP9sMWpbnNMtdxv4YOsGaeNZbCny51elL5SmRsl3nXVUX4mUZQ6ZeF9HpiZHv7ajWsFS-sdKVJzi7bi5inkkldFdf18p87LyGh8TFUIwW6MlRXv1WSZTUQxaufdEFXOX-n6AnzJHJ-YRhSjJmugdeg1dlm2EEpN/w640-h358/%E5%93%AA%E5%90%922c.png" width="640" /></span></a></div></div><div style="text-align: left;"><span style="font-size: medium;"><br /></span></div><div style="text-align: left;"><span style="font-size: medium;">總括而言，「哪吒之魔童鬧海」無疑是中國動畫史上的一個新起點，象徵著技術與創意的突破。這部作品不僅提升了國產動畫的製作水準，也引領了更多故事題材的探索，展現出中國文化的深厚底蘊。與早前的國產遊戲「黑神話悟空」一樣，為世界展示了中國神話故事的魅力及其文化的深度輸出。事實上，真正優秀的作品不應受限於地域，只要具備真材實料，就應該受到讚揚和認可。</span></div><div style="text-align: left;"><span style="font-size: medium;"><br /></span></div><div style="text-align: left;"><span style="font-size: medium;">劇終時，各位千萬不要急著離去，因為還有一小段精彩的彩蛋為第三集鋪路，讓我們拭目以待吧。</span></div><div style="text-align: left;"><span style="font-size: medium;"><br /></span></div><div style="text-align: left;"><span style="font-size: medium;"><span>以下是一些番外篇短片：</span><br /><iframe allowfullscreen="" class="BLOG_video_class" height="266" src="https://www.youtube.com/embed/9zLke9FklnM" width="320" youtube-src-id="9zLke9FklnM"></iframe></span></div><div style="text-align: left;"><span style="font-size: medium;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-size: medium;"><iframe allowfullscreen="" class="BLOG_video_class" height="266" src="https://www.youtube.com/embed/yfdHGl3zU8A" width="320" youtube-src-id="yfdHGl3zU8A"></iframe></span></div></div>

哪吒之魔童鬧海

今天，終於迎來了國產3D動畫「哪吒之魔童鬧海」在香港上映！這部動畫在全球票房已突破130億人民幣，作為耗時五年精心製作的第二部作品，無疑成為中國動畫史上一個重要的里程碑。在前往影院之前，我特意重溫了它的第一集「哪吒之魔童降世」。這部2019年的作品已經讓我印象深刻，無論是劇情的深...

數字配對挑戰 (v1.0)

<p style="text-align: center;"> </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4iUcGx93sMZpUu2KoGzPq1ewO6mHCnxLhW83_ZSju-nRfSQ9hW5IzFpvivNeS5sevgBKqb2vl1M9WHIfajQ0-FB1VDU1_9c5JtGz6elqiozP3gDVjfJ3VUhJF6NBLzfEd3Yg-dxiaLXNOul9FQ07sRbX1S1rwVGSSDW-wGo1fTCpXnpOWnQsv6xRJWX2x/s792/%E6%95%B8%E5%AD%97%E9%85%8D%E5%B0%8D%E6%8C%91%E6%88%B0.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="542" data-original-width="792" height="438" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4iUcGx93sMZpUu2KoGzPq1ewO6mHCnxLhW83_ZSju-nRfSQ9hW5IzFpvivNeS5sevgBKqb2vl1M9WHIfajQ0-FB1VDU1_9c5JtGz6elqiozP3gDVjfJ3VUhJF6NBLzfEd3Yg-dxiaLXNOul9FQ07sRbX1S1rwVGSSDW-wGo1fTCpXnpOWnQsv6xRJWX2x/w640-h438/%E6%95%B8%E5%AD%97%E9%85%8D%E5%B0%8D%E6%8C%91%E6%88%B0.png" width="640" /></a></div><p></p><div class="separator" style="background-color: white; clear: both;"><span style="font-size: medium;"><span face="Verdana, Geneva, sans-serif" style="color: #333333;">■ </span><span face="Verdana, Geneva, sans-serif" style="color: #333333;">前 言</span></span></div><div><div class="separator" style="background-color: white; clear: both;"><span style="font-size: medium;">無聊之作，旨在閒時練習寫程式。</span></div><div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: medium;">   </span></div><div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: medium;">■ 程 式 說 明 </span></div><div class="separator" style="background-color: white; clear: both;"><span style="font-size: medium;">挑戰你的記憶力！在最短的時間內完成36格的配對遊戲，找出1至18的數字配對。</span></div><div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif;"><br /></div><div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: medium;">■ 程 式 編 寫 及 設 計 : Astro Chan</span></div><div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: medium;"><br /></span></div><div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: medium;"><span face="Verdana, Geneva, sans-serif">■ 下 載 位 置：</span><span face="Verdana, Geneva, sans-serif"><a href="https://docs.google.com/uc?id=1R7MTa1r-LzLmqq-Jk_Q-qklR4naPxns-&amp;amp;export=download&amp;amp;hl=zh_TW" style="color: #cc2a43; line-height: 22px; text-decoration-line: none;" target="_blank">數字配對挑戰</a> [ver1.0]<span style="line-height: 22px;"> (260Kb) </span></span></span></div><div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: medium;"><br /></span></div><div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: medium;">■ 如果對這個程式有任何問題或建議，歡迎留言告訴我，謝謝！</span></div></div>

數字配對挑戰 (v1.0)

■ 前言無聊之作，旨在閒時練習寫程式。 ■ 程式說明挑戰你的記憶力！在最短的時間內完成36格的配對遊戲，找出1至18的數字配對。 ■ 程式編寫及設計 : Astro Chan ■ 下載位置：數字配對挑戰 [ver1.0] (26...

Excel 實用小技巧 (二)

<p style="text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwtiLSE8IVJ81IIK6QVpR19PSPwu4UEaxnvxACMYwJQa9_o_YVqE2xAusqMwcWzQ4Ll0dPDKiHkzhv6nQ3VLaWrGBQqYTZ0B0DtUF3Gow8nVwRRJoKrdZWTqJKiWO82hK3KaGGnEp4YeBrpC1cfMJoh0TUo2sU7bH4tzP0Hr6m4vAoElmO0e330z307W0s/s1011/Excel002.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="624" data-original-width="1011" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwtiLSE8IVJ81IIK6QVpR19PSPwu4UEaxnvxACMYwJQa9_o_YVqE2xAusqMwcWzQ4Ll0dPDKiHkzhv6nQ3VLaWrGBQqYTZ0B0DtUF3Gow8nVwRRJoKrdZWTqJKiWO82hK3KaGGnEp4YeBrpC1cfMJoh0TUo2sU7bH4tzP0Hr6m4vAoElmO0e330z307W0s/w400-h248/Excel002.png" width="400" /></a><br /></p><div><b style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;"><br /></span></b></div><div style="text-align: center;"><b style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;">[合併資料的分拆]</span></b></div><div><b style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;"><br /></span></b></div><div><span style="background-color: white;"><div class="separator" style="clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px; font-weight: bold; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaItoTcRo6QbeiQpSW8Ty5elF7MrW0UphCrHAzijBsp7ULqaQAC7MYPTVjWur1G-kFE1zmH_Dxw6feftCRh97ou1_bNLs0p-Unk-7NfsTDC6E0AMk10pXSIicB7s-jCsJbTuWQueFEyBZQ4f_l75aB-2ER87AEcPnVjwxB1AxjiCYapmTXWJ4NnclbTyOm/s1211/Sseparate.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="367" data-original-width="1211" height="194" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaItoTcRo6QbeiQpSW8Ty5elF7MrW0UphCrHAzijBsp7ULqaQAC7MYPTVjWur1G-kFE1zmH_Dxw6feftCRh97ou1_bNLs0p-Unk-7NfsTDC6E0AMk10pXSIicB7s-jCsJbTuWQueFEyBZQ4f_l75aB-2ER87AEcPnVjwxB1AxjiCYapmTXWJ4NnclbTyOm/w640-h194/Sseparate.png" width="640" /></a></div><br /><div style="text-align: left;">A欄中的每個儲存格包含了一些合併的資料，可以將這些合併的資料分割出來，並填入例如C欄的每一個空白儲存格中。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC_tECu8NfhSzj-6CkiNZkXOxIcsl2_lv6THdAdOKyvuEejnUFVCdAofxyg6F8I4L6Bz2s3_rcU35ZsHyjVE4rhFMiw7q20q2VvD2RLokrI9KVdKlV4knWlFkB4tOsLg6PlS_USHBf5CkV9X8mh_lm-1ZD2ugaGx68RzCPMslbsPUHrjfSz_V8WhmccyTB/s1124/Sseparate002.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="553" data-original-width="1124" height="314" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC_tECu8NfhSzj-6CkiNZkXOxIcsl2_lv6THdAdOKyvuEejnUFVCdAofxyg6F8I4L6Bz2s3_rcU35ZsHyjVE4rhFMiw7q20q2VvD2RLokrI9KVdKlV4knWlFkB4tOsLg6PlS_USHBf5CkV9X8mh_lm-1ZD2ugaGx68RzCPMslbsPUHrjfSz_V8WhmccyTB/w640-h314/Sseparate002.png" width="640" /></a></div><br /><div style="text-align: left;">首先，選擇要分析的資料位置，然後按「資料」>「資料分析」。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSOb6Bk6kNnoUtQDu7p5UJKhbDntMim_mI9EbQmQHGBcie9ha4kKslQl2XKfD9HjUbgLZNkSV5XedNw1gwqPG9DfmIWeGh9r-RB9ex93ui_OO5jFjD5d9XHxepC7sN-IDJp7A0wZbUOJkgrSXwe8EAOhj1R4nomErWl0E8i8z_3_kt4-8Rk1AFoGCvpLE1/s756/Sseparate003.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="573" data-original-width="756" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSOb6Bk6kNnoUtQDu7p5UJKhbDntMim_mI9EbQmQHGBcie9ha4kKslQl2XKfD9HjUbgLZNkSV5XedNw1gwqPG9DfmIWeGh9r-RB9ex93ui_OO5jFjD5d9XHxepC7sN-IDJp7A0wZbUOJkgrSXwe8EAOhj1R4nomErWl0E8i8z_3_kt4-8Rk1AFoGCvpLE1/w640-h486/Sseparate003.png" width="640" /></a></div><br /><div style="text-align: left;">原始資料類型選擇「分隔符號」，點擊「下一步」。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg60QLye7kWW87rAdNgNoDJaei1KcW3ssXFgGPZabI1y_LnyspZ_n5vHnaeRO1_65nfDdI_8WgXkBXfJYF2gLffobEG_-7VRBzOSySoS8cVsa3uGa1tNT0czVzyi7M7-dLZ4FQR8OsjQUQ-AhirURTtd6NQNjeOuSMbcwOe0BPLYqaVweLywo_SGMA5MX1a/s720/Sseparate004.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="579" data-original-width="720" height="514" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg60QLye7kWW87rAdNgNoDJaei1KcW3ssXFgGPZabI1y_LnyspZ_n5vHnaeRO1_65nfDdI_8WgXkBXfJYF2gLffobEG_-7VRBzOSySoS8cVsa3uGa1tNT0czVzyi7M7-dLZ4FQR8OsjQUQ-AhirURTtd6NQNjeOuSMbcwOe0BPLYqaVweLywo_SGMA5MX1a/w640-h514/Sseparate004.png" width="640" /></a></div><br /><div style="text-align: left;">分隔符號點選其他，然後在空白位置上按下「Ctrl + J」。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZsLgq_VrX38hrND_aTV7dzDzYoDPUw4QZQbcNm25jIXWNHBCzIbuO03dF4qTKR_qpQmdgASZSB_HBJ0GtvfOTEY2EWBXlrxfftXtIj6CubunBJaZHu5pi8BEg6EvPDMAaSMiNalsFvVN0tWQ10HcSqmPM1QkEwr73emZpaOPITYacWsdouAvo9VaQ31N7/s722/Sseparate005.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="567" data-original-width="722" height="502" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZsLgq_VrX38hrND_aTV7dzDzYoDPUw4QZQbcNm25jIXWNHBCzIbuO03dF4qTKR_qpQmdgASZSB_HBJ0GtvfOTEY2EWBXlrxfftXtIj6CubunBJaZHu5pi8BEg6EvPDMAaSMiNalsFvVN0tWQ10HcSqmPM1QkEwr73emZpaOPITYacWsdouAvo9VaQ31N7/w640-h502/Sseparate005.png" width="640" /></a></div><br /><div style="text-align: left;">按下「Ctrl + J」後，下方的預覽會即時顯示你所需的結果，然後點擊「下一步」。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPsNgaa0XlfAvSnumDcX_EEe83jqB5AO3trnudHXvIQQSb270LTVsIQ-yHnOBd13ldtOgS62B60XIG0YXzkGGaF6ZEozt2f7wOVP1WPsjeLBPToaJOwkvMystyEhyuOhqiqqIEg8TDX_4k0caM9AJj6a2ILXBOyphQ-q7oi5VEd3ikIBfAos85PD220fdb/s878/Sseparate006.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="656" data-original-width="878" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPsNgaa0XlfAvSnumDcX_EEe83jqB5AO3trnudHXvIQQSb270LTVsIQ-yHnOBd13ldtOgS62B60XIG0YXzkGGaF6ZEozt2f7wOVP1WPsjeLBPToaJOwkvMystyEhyuOhqiqqIEg8TDX_4k0caM9AJj6a2ILXBOyphQ-q7oi5VEd3ikIBfAos85PD220fdb/w640-h478/Sseparate006.png" width="640" /></a></div><br /><div style="text-align: left;">在目標儲存格上點擊你想要貼上的其他儲存格的空白位置，例如 C2，然後按「完成」。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIE8SZKrSd-JItGlwDCAT7EtD8zlloxQLduW6LAT-MUyG5W4WpHoRFHBde0LxPcW0IXgKNNszcJiVRCgJEEYAz929wvknZtMFIrmHThNMZUm9ktWgeU-_8uffk8yAT0FIcAR20YxOxKrk6EbgqmccBqXvlr5g9ffzOyxachEd1H-szJ7l8vXflS0rrxE9r/s615/Sseparate007.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="373" data-original-width="615" height="388" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIE8SZKrSd-JItGlwDCAT7EtD8zlloxQLduW6LAT-MUyG5W4WpHoRFHBde0LxPcW0IXgKNNszcJiVRCgJEEYAz929wvknZtMFIrmHThNMZUm9ktWgeU-_8uffk8yAT0FIcAR20YxOxKrk6EbgqmccBqXvlr5g9ffzOyxachEd1H-szJ7l8vXflS0rrxE9r/w640-h388/Sseparate007.png" width="640" /></a></div><br /><div style="text-align: left;">資料會立即被分拆到指定的空白位置上。</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;">                                     Fin                                   </u></div><div style="text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><br /></u></div><div style="text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><br /></u></div><div style="text-align: center;"><b style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;">[資料數值批量增加]</span></b></div><div style="text-align: center;"><b style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;"><br /></span></b></div><div style="text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqDyDzd9u98tLzEwXzmJfEgDLhNFV6bQZRUysWpvvvKhijMTp6GSOk2MN1zwkoEQsKUqvxGrJvsf2IPyIlAx23nhNR_5fckq93deyN8hrXpD4o7uW6tMhfz3e1ihyFadzw9iUFAg05PQdr-izSQ0829gBohcy8p_xqb14-_lWjWhFdM6B8HWYPljXZnH2p/s470/a001.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="326" data-original-width="470" height="278" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqDyDzd9u98tLzEwXzmJfEgDLhNFV6bQZRUysWpvvvKhijMTp6GSOk2MN1zwkoEQsKUqvxGrJvsf2IPyIlAx23nhNR_5fckq93deyN8hrXpD4o7uW6tMhfz3e1ihyFadzw9iUFAg05PQdr-izSQ0829gBohcy8p_xqb14-_lWjWhFdM6B8HWYPljXZnH2p/w400-h278/a001.png" width="400" /></a></div><br /></div><div style="text-align: left;">B欄中有相應的中文測驗分數。如果你想要批量將B欄的每個數值加上相同的數值，例如將E3儲存格中的 5 的數值加到每個分數上。</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvYoeWNL4tRsfMYYfIs6jSU29cLLydH6S2rGhcWbjwFqIObbvo63kYqSMzbq30p5n_nVzJMklGj3Zd_LoP9UIdRWQZ7OQXe6Exx45qxmt4IQFPAJiAZhP76z51dN8cTg907-5DZ9vGjSPP2Dtw5FVWJY0DHHm_AnUaDeRwt0oQD1sn7RKevd2JJZrkdUtS/s482/a002.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="325" data-original-width="482" height="270" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvYoeWNL4tRsfMYYfIs6jSU29cLLydH6S2rGhcWbjwFqIObbvo63kYqSMzbq30p5n_nVzJMklGj3Zd_LoP9UIdRWQZ7OQXe6Exx45qxmt4IQFPAJiAZhP76z51dN8cTg907-5DZ9vGjSPP2Dtw5FVWJY0DHHm_AnUaDeRwt0oQD1sn7RKevd2JJZrkdUtS/w400-h270/a002.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">首先，選擇 E5 的數值並按複製 / (Ctrl + C)。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg04RS7VTR49PRbv4JrU8Igp0zOco-1LU_dDHkFo4JX0z704tjslClNy34FHkqASuODIeqAUKztyWuIM03Dxxh1uSHptOB43y5JgU47QfpLjnMor5Q-NYd5iOaC9aljJSB1iGlo4C9mw9HqobrjNb0r8L73VZAd0UaRaevkJkvtBeGtxY7q7tSYOMVvsbNk/s487/a003.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="352" data-original-width="487" height="289" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg04RS7VTR49PRbv4JrU8Igp0zOco-1LU_dDHkFo4JX0z704tjslClNy34FHkqASuODIeqAUKztyWuIM03Dxxh1uSHptOB43y5JgU47QfpLjnMor5Q-NYd5iOaC9aljJSB1iGlo4C9mw9HqobrjNb0r8L73VZAd0UaRaevkJkvtBeGtxY7q7tSYOMVvsbNk/w400-h289/a003.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">然後選擇需要批量更改數值的儲存格範圍。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTpENM5q0fe0pk0s3FoHFOzf_9iykULJUGmbeh41Fu1hVmZ-IlNsX6lpHCStLXDUuIj-BHh1248D8OYP73eC5LBoVWSYUDM503GUP_Sm55V_jdRbVhWR145paL_SYxukCg0H__slsbW2STRN3prK_GPGuOefxoFP2DkSmG9-3C_i2yozXP35eBTNkGGXj7/s482/a004.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="328" data-original-width="482" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTpENM5q0fe0pk0s3FoHFOzf_9iykULJUGmbeh41Fu1hVmZ-IlNsX6lpHCStLXDUuIj-BHh1248D8OYP73eC5LBoVWSYUDM503GUP_Sm55V_jdRbVhWR145paL_SYxukCg0H__slsbW2STRN3prK_GPGuOefxoFP2DkSmG9-3C_i2yozXP35eBTNkGGXj7/w400-h272/a004.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">按下滑鼠右鍵，然後選擇「選擇性貼上」。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-SvLEqcNI_iwBBvWOltjLjeOpZiUNxlbDyWWVm6hx2pUG_-HIUN-3TDCGiWol8DGbc4rfOesGTKgwLyUQ5UWVQVXDndgZQPjr1D_OmhEaOA0GlC0gRx0gK4ZzB_RHciW38Hm_dbf_lvtV_CA2zYG7lmo-W1HFSFhY9hB809stUpDIzQRUL-okXb1oQn9E/s834/a005.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="395" data-original-width="834" height="304" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-SvLEqcNI_iwBBvWOltjLjeOpZiUNxlbDyWWVm6hx2pUG_-HIUN-3TDCGiWol8DGbc4rfOesGTKgwLyUQ5UWVQVXDndgZQPjr1D_OmhEaOA0GlC0gRx0gK4ZzB_RHciW38Hm_dbf_lvtV_CA2zYG7lmo-W1HFSFhY9hB809stUpDIzQRUL-okXb1oQn9E/w640-h304/a005.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">在下方的運算選項中，選擇想要批量修改數值的運算方法，例如點擊「加」，然後再點擊「確定」。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi0BLsNLq2G5ZrncPIRo-IPye7E_I1VB-OzjzuOf5Q9n3ZAvW6u_6lLlt8hoHPcN4xH3xgWffWDOGzUw7pHOPCiuRMXMFeilW1QrV73ADEk8bRUoC7aqmB0ae-Vn7m1xTcw4JQ_jiPnMSHALIQb5ztXoIH37g0qSIIL_t8p2dgKAKZZ1VpfPHJcYw-W6NN/s481/a006.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="326" data-original-width="481" height="271" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi0BLsNLq2G5ZrncPIRo-IPye7E_I1VB-OzjzuOf5Q9n3ZAvW6u_6lLlt8hoHPcN4xH3xgWffWDOGzUw7pHOPCiuRMXMFeilW1QrV73ADEk8bRUoC7aqmB0ae-Vn7m1xTcw4JQ_jiPnMSHALIQb5ztXoIH37g0qSIIL_t8p2dgKAKZZ1VpfPHJcYw-W6NN/w400-h271/a006.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">範圍內的儲存格數值將全部加上5。</div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;">                                     Fin                                   </u></div><div class="separator" style="clear: both; text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><br /></u></div><div class="separator" style="clear: both; text-align: center;"><u style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><br /></u></div><div class="separator" style="clear: both; text-align: center;"><b style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px;"><span style="font-size: medium;">[刪除資料中空白儲存格]</span></b></div><div><span style="background-color: white;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTwHMGwE9Qh5ilNaKRJt7CvQ0A4Y40KoMxhiEjm9jw91BFfPsrLQ9CA3bUyWyRGrMrQmnDgWiqCqsKzLa0Oawb0EDdXyZRGllXJecS6JwswRFixiYYIcszTar3CEjSAy6px91N8n_mW2yjA88myeNuFMRt3Ncx85G9LcwQ5DphI1PeaqiW4XU1xpa1oMm9/s603/D001.png" style="background-color: transparent; margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="387" data-original-width="603" height="410" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTwHMGwE9Qh5ilNaKRJt7CvQ0A4Y40KoMxhiEjm9jw91BFfPsrLQ9CA3bUyWyRGrMrQmnDgWiqCqsKzLa0Oawb0EDdXyZRGllXJecS6JwswRFixiYYIcszTar3CEjSAy6px91N8n_mW2yjA88myeNuFMRt3Ncx85G9LcwQ5DphI1PeaqiW4XU1xpa1oMm9/w640-h410/D001.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">以上兩組數據中，各自都包含相應的空白儲存格。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_3j3fZ03DbzXUBcCQYCxGzrDjjSLrO0pv2cTdMdAj9Y0rUPG6gXUGC_QvCiswlM9TzayYUxlrXpVod0cZW1c2tPKvaingJB7qXXWfoN1hzxoBVJ0Ra5lW1xPKZ_NIalUNhQAOp0QV-wCRXuNeg0gp0MpBpcFksHGfIAZThCyhVUAtoNZnisLXz5tLLs9P/s608/D002.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="387" data-original-width="608" height="408" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_3j3fZ03DbzXUBcCQYCxGzrDjjSLrO0pv2cTdMdAj9Y0rUPG6gXUGC_QvCiswlM9TzayYUxlrXpVod0cZW1c2tPKvaingJB7qXXWfoN1hzxoBVJ0Ra5lW1xPKZ_NIalUNhQAOp0QV-wCRXuNeg0gp0MpBpcFksHGfIAZThCyhVUAtoNZnisLXz5tLLs9P/w640-h408/D002.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">按住「Ctrl」鍵，然後選擇兩組數據的儲存格範圍。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFYD1vFqRiCjG037KYP-QV4Gxbv0bMZBxOwvzEJeyPVWI2hf8wU0042hS8idBON55VVoeQRQxBOh3Y0EzegoIJA1sNBOY5bXgYnArK6x1X8pFPJXWwIh3di3JfiS5UejutAA5F9CEmHEC3nSqP_8F68rYEpSPhcC07VUcgmYNJGrmbBhiCnomTkPOojxtt/s930/D003.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="395" data-original-width="930" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFYD1vFqRiCjG037KYP-QV4Gxbv0bMZBxOwvzEJeyPVWI2hf8wU0042hS8idBON55VVoeQRQxBOh3Y0EzegoIJA1sNBOY5bXgYnArK6x1X8pFPJXWwIh3di3JfiS5UejutAA5F9CEmHEC3nSqP_8F68rYEpSPhcC07VUcgmYNJGrmbBhiCnomTkPOojxtt/w640-h272/D003.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">按「Ctrl + G」會進入參照位址的選單，然後再點擊「特殊」。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYn2Fqu6ORIiS51z3ug0PC9Q4mi0ClrnloPAhUMQTVXjH-te7Uqlxqno3UyQ5HTN7VG9X8-JqZPDrYsxbSUH9EKluIfLlwrmVQdL1C74ysexrLsIah43_xn7WcFAGZP2iD7-GB65MaIIi7M-dZ2vuvPYk9593CJgCRj48pB7WDGb-SzrMYVd9ppH3hthiV/s899/D004.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="443" data-original-width="899" height="316" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYn2Fqu6ORIiS51z3ug0PC9Q4mi0ClrnloPAhUMQTVXjH-te7Uqlxqno3UyQ5HTN7VG9X8-JqZPDrYsxbSUH9EKluIfLlwrmVQdL1C74ysexrLsIah43_xn7WcFAGZP2iD7-GB65MaIIi7M-dZ2vuvPYk9593CJgCRj48pB7WDGb-SzrMYVd9ppH3hthiV/w640-h316/D004.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">特殊目標點選「空格」，再點選「確定」。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdUeg1ZDnRkEJQ7NVnFYwfugIRFmIZ8vlMMUMgptvemQ0JTRdp6jhvLlkXloM0n7zgZcvBPnd3diOU39NX51_CunjYQ07b_9g_hciavBUsMRvNtYZV83-0AFUlLAsd3EQTga7Nhgerw9hz0RCKUvPqDn8Mf9X7bNNJTs_3nxVOaf0OhbRY4FfUxKX0U1DC/s611/D005.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="391" data-original-width="611" height="410" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdUeg1ZDnRkEJQ7NVnFYwfugIRFmIZ8vlMMUMgptvemQ0JTRdp6jhvLlkXloM0n7zgZcvBPnd3diOU39NX51_CunjYQ07b_9g_hciavBUsMRvNtYZV83-0AFUlLAsd3EQTga7Nhgerw9hz0RCKUvPqDn8Mf9X7bNNJTs_3nxVOaf0OhbRY4FfUxKX0U1DC/w640-h410/D005.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">相應數據範圍中的空白儲存格將全部被選擇。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibgUpOAWmZzvhbtb1LCpzPyy8htQj0bhXzqlBu9Fkj40ZKOiG0S82-BdrZUOKi06LTSFG_0gOBzzGmO_z2gLB5TGyM3pU0q4UY6mHYlhMbJZ5xl9HCT3J6o0vv7Boc1sBY4SEdfGFawsrxdFTN3f7bKHs_2CWU0zERIPeIdkaA-QbKttGwUvlBTyP3qyta/s838/D006.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="545" data-original-width="838" height="416" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibgUpOAWmZzvhbtb1LCpzPyy8htQj0bhXzqlBu9Fkj40ZKOiG0S82-BdrZUOKi06LTSFG_0gOBzzGmO_z2gLB5TGyM3pU0q4UY6mHYlhMbJZ5xl9HCT3J6o0vv7Boc1sBY4SEdfGFawsrxdFTN3f7bKHs_2CWU0zERIPeIdkaA-QbKttGwUvlBTyP3qyta/w640-h416/D006.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">點選上方的「常用」，然後點選「刪除」即可。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnh6E6cskVPhNPOC1cU8yuT94vO3qHFYHQiU5cJ6PO5lFZTKm8LlQgiGiAAHBYyjm0isMpPTFiTgFKnq_37pI-gv53vtfk27UEx1uOyw5tVWLMDap9TviaN5XMgA-mScbZ92DevrsfpORJF_XkI7AQ9P_ywcvwNp5fLXdB8WAJAP_gmISqpmq9H_M_7yQp/s605/D007.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="386" data-original-width="605" height="408" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnh6E6cskVPhNPOC1cU8yuT94vO3qHFYHQiU5cJ6PO5lFZTKm8LlQgiGiAAHBYyjm0isMpPTFiTgFKnq_37pI-gv53vtfk27UEx1uOyw5tVWLMDap9TviaN5XMgA-mScbZ92DevrsfpORJF_XkI7AQ9P_ywcvwNp5fLXdB8WAJAP_gmISqpmq9H_M_7yQp/w640-h408/D007.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">刪除後，空白的儲存格預設會被下一行的資料填補並移上來。</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div></span><span face="Verdana, Geneva, sans-serif" style="background-color: white; color: #333333; font-size: 14px;"><div style="text-align: center;">(待續....)</div></span></div><p></p>