2023年计算机二级考试MSOffice考试题库excle有答案

《2023年计算机二级考试MSOffice考试题库excle有答案》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

ᙠூ⚪௃ᓫ⌱ூᐭὃᦻᜳ௃ᢥ᯿⚪☢Ḅ஺"#$%Ḅᦻ&'()ᙠὃᦻᜳ*+,-./0ᦟ2ᙠᦟ3ᜐ567-890Ḅᡂ;<ᳮ஺ᵫ?0᪥ᙢᜐBCᙢDEF&⌕Ḅᦟ0HIJᨵ-LMNOPQḄPCR%Sᵨ஺UᙠVLᵯᾯ/YZ[MicrosoftOffice,\]^Excelᩭ<ᳮ0ᡂ;%`⊡0᪥EFᦪcd<ᳮefḄg▲ឋ஺jᙠk-0llmὃnoopq*+r7-89stuḄᡂ;ᙳwᐭ[ᦻxy“0ᡂ;ᓫ.xlsx”ḄExcel{|ᦻ᫏/஺~᪷cᑡ*+ὁ2ᡂ;ᓫ᦮ᳮᑖ᪆$1.{⊤"k-0llmᡂ;”/Ḅᦪcᑡ⊤ᓄ$rk-ᑡ"0”ᑡHyᦻrᡠᨵᡂ;ᑡHy().*ᦪḄᦪ〉ᜧQᑡᦋஹH¡¢£¤¥〉Ḅ¦᪾¨©%S{⊤ª«¬஺2.ᵨ"ᩩ¯”°±ᑡH¡$r²ᦻஹᦪ0ஹ³²s´/Oµ?110ᑖḄᡂ;ᡠᙠḄᓫᐗ%-·¸⁐`ᐙᐸU¼´/Q?95ᑖḄᡂ;%½•·¸⁐᪗Àᡠᵨ¸⁐ÁÂ%OÃᢱᦪcyÅ஺3.ᵨsumaverageÆᦪÇÈÉ-t0ḄÊᑖËÌᙳᡂ;஺4.0k3ஹ4.Í⊤0ᡠᙠḄu9Î᝞$"120235஻Í⊤1291u5஺]^ÆᦪÑÒÉt0ᡠᙠḄu9ᢥᑡÓÔᐵe`ᑏᙠ"u9”ᑡ/$0஻Ḅ3ஹ4.ÓÔu9011u022u033u5.×ᑴ{⊤”k-0llmᡂ;”rÙÚNᑮÜ⊤ÝÞ$ᦋÙ⊤᪗ßḄ¸⁐àáx,á⊤x◤ᒹå"ᑖæçÊ”᪵஺

16.]^êæçÊ°±ëÀÉtuᔜ´ḄÌᙳᡂ;rÉípîᑖ⚓ðñ஺7.%ᑖæçÊpîyòẠôõ-tö÷øùúûÉtuᔜ´Ìᙳᡂ;üýrú⊤ÚNᙠ-txy"ø÷ᑖ᪆ú”á{⊤/஺1.ூþ⚪ÿ⁚௃⁚1ᡭὃᦻᜳḄ”ᡂᓫ.xlsx”஺⁚2⌱஻஻ᡠᙠḄᑡᓫ᪗ᙠ!Ḅ"ᣩ$ᓫ⌱%”&'ᓫᐗ))*",-ᓽ/!“&'ᓫᐗ))*”12᪾஺ᑗᣚ6"ᦪ8”⌱⚗ᓱᙠ"ᑖ<"=⌱%஻ᦻ>஻,-?ᓫ"@A"ᢥCᓽ/DE&'஺⁚3⌱ᡠᨵᡂᑡᓫ᪗ᙠ!Ḅ"ᣩ$ᓫ⌱%"&'ᓫᐗ))*”,-!”&'ᓫᐗ))*”12᪾ᑗᣚ6ᦪ8⌱⚗ᓱᙠ"ᑖ<"=⌱%"ᦪG",-ᙠHᦪIᦪJK᪾&'HᦪIᦪL"2"?ᓫ"@A"ᢥCᓽ/஺⁚4⌱᝞N1.23ᡠOᑁQᓫூS௃⌱⚗ᓱூᓫᐗ)௃=Ḅ“)*"ᢥCᙠ!ḄTᑡ⊤⌱%"VW",-!"VW”12᪾&'VWL"15”஺⁚5ᓫூS௃⌱⚗ᓱூᓫᐗ)௃=Ḅ")*"ᢥCᙠ!ḄḄTᑡ⊤⌱%"ᑡX",-!"ᑡX”12᪾&'ᑡXL"10"஺⁚6᪗ᙠ!Ḅ"ᣩ$ᓫ⌱%”&'ᓫᐗ))*",-ᙠ!Ḅ“&'ᓫᐗ))*"12᪾ᑗᣚ6"8Y஻⌱⚗ᓱᙠ“8Y஻Tᑡ⊤᪾&'8YL“Zᙊ"ᙠ"8”Tᑡ⊤᪾&'8L"10"஺⁚7⌱\]Vᓫᐗ)ᙠூS௃⌱⚗ᓱḄூ8Y௃=ᓫ“^_"ᢥC`a&'8bL"^_”஺⁚8cd⌱ᦪefgᢥ᯿i᪵Ḅk*ᡭ஻&'ᓫᐗ))*஻12᪾ᑗᣚ6"1l”⌱⚗ᓱᙠ“ᦻ>1lk*”=&'஻mn1l"o"ᚖq1l"rL"s"஺

2⁚9ᑗᣚ6"u᪾"⌱⚗ᓱᙠ"⚜w''⌱⚗⌱%"᜜u᪾",-z"ᑁ{”,-஺⁚10|ᑗᣚ6"}ᐙ”⌱⚗ᓱᙠ஻⁐”=⌱%஻”஺⁚11ᓫ"@A”ᢥC஺2.ூ⚪⁚௃⁚ᐭ⌱D2F19ᓫᐗ)fgᓫூS௃⌱⚗ᓱூ᪵*௃=Ḅ"ᩩ)*”ᢥC⌱%”!Oᓫᐗ)ᑣ”Ḅ"ᐸᑣ”,-!"d)*ᑣ”12᪾஺ᙠ஻ᑣ”⌱⚗&'ᓫᐗ)Gᜧᡈ110,ᯠ?ᓫ஻)*”ᢥC!஻&'ᓫᐗ))*”12᪾ᙠ"}ᐙ"⌱⚗ᓱ⌱%"⁐",-ᓫ"@A”ᢥC஺⁚2:⌱G2:J19ᓫᐗ)⌱fᢥ᯿i᪵Ḅkᓫᐗ)Gᜧ95Ḅ8Y⁐&'L⁐஺3.ூ⚪⁚௃⁚1ᙠK2ᓫᐗ)ᐭ”=SUM(D2:J2)",ᢥ"Enter”?¡ᓫᐗ)GL"629.50",¢£K2¤Ḅ}ᐙ¥q6ᨬ]VᦪeᜐDE¨ᑖḄ}ᐙ஺⁚2:ᙠL2ᓫᐗ)ᐭ”=AVERAGE(D2:J2)",ᢥ"Enter”?¡ᓫᐗ)GL"89.93",¢£L2¤Ḅ}ᐙ¥q6ᨬ]VᦪeᜐDEnᙳᑖḄ}ᐙ஺4.ூ⚪⁚௃⁚ᙠC2ᓫᐗ)ᐭ”=LOOKUP(MID(A2,3,2),{"OT,"02","03"},{"1ª","2ª","3ª"}ᢥ"Enter”?¡ᓫᐗ)GL"3ª"¢£C2¤Ḅ}ᐙ¥q6ᨬ]VᦪeᜐDEª®Ḅ}ᐙ஺5.ூ⚪⁚௃⁚1¯ᑴ±²⊤”\]³³´ᡂ”µ¶ᑮSheet2±²⊤஺ᯠ?ᙠ¸>Ḅ±²⊤¹᪗ᙠ!Ḅ"ᣩ$ᓫḄ"±²⊤᪗º⁐஻®ὶ$ᓫ⌱%"⁐",-஺

3⁚2¼¸>⊤¹ᕈ/¾᝱cd,¹L஻\]³³´ᡂᑖ<À¨஻஺6.ூ⚪⁚௃⁚1ᢥ᯿⚪Á]k☢1ª®ᢥᓣÄÅV᣸Ä⌱C2C19ᓫᐗ)fgᓫூᦪe௃⌱⚗ᓱூ᣸ÄzÇ⌱௃=Ḅ஻ᓣÄ஻ᢥC!஻᣸ÄÈ⏨஻12᪾ᓫ“᡽Ë⌱Afg஻ᓫ⌱ᢥC஺ᓫ஻᣸Ä஻ᢥC?ᓽ/DE&'஺⁚2⌱D20ᓫᐗ)ᓫூᦪe௃⌱⚗ᓱூᑖ®O௃=Ḅ஻ᑖ<À¨஻ᢥC!஻ᑖ<À¨஻12᪾஺ᓫ஻ᑖ<8Ì஻=ḄTᢥC⌱%஻ª®஻,-ᓫ஻À¨k*஻=ḄTᢥC⌱%஻nᙳG”ᙠ஻⌱AÀ¨⚗஻=Í⌱஻Îᦻ஻ஹ஻ᦪ஻ஹ஻ÐÎ஻ஹ஻ᱥ”ஹ஻ᙢᳮ஻ஹ஻ᔊÕ஻ஹ஻Ö×஻¯⌱᪾஺ᨬ?|Í⌱஻Ø=ᦪeᑖ⚓஻¯⌱᪾஺⁚3ᓫ஻@A“ᢥC஺7.ூ⚪⁚௃⁚1⌱ØÚªᔜÜnᙳᡂᡠᙠḄᓫᐗ)ᓫூÝᐭ௃⌱⚗ᓱூN⊤௃=஻ÞbN஻ᢥCᙠ!ḄTᑡ⊤⌱%஻ß¾ÞbN஻,-஺⁚2N⊤fᙠ!Ḅ"ᣩ$ᓫ⌱%஻⌱%ᦪe஻,-!“⌱%ᦪeà”12᪾⌱”Ná⚗஻⌱⚗Ḅ஻âᑡT,ᓫ஻஻ᢥC!஻ᦪeâᑡ஻12᪾ᙠ஻âᑡ¹ã஻ᦻ>᪾ᐭ“1ª஻஺ᯠ?ᓫ஻@A஻ᢥCDE&'஺ᢥ᯿i᪵Ḅk஻âᑡ2"ஹ”âᑡ3஻L஻2ª஻ஹ஻3ª”஺⁚3ᙠ஻⌱%ᦪeà஻12᪾⌱஻mnäᑖ<åæ᪗º஻Ḅ஻1஻ᓫ஻஻ᢥC!"æ᪗º஻12᪾ᙠ஻æ᪗ºfg஻ᦻ>᪾ᐭ஻ÎᦻᦪÐÎᱥᙢᳮᔊÕÖ×஻஺⁚4ᓫ஻@A஻ᢥC஺⁚5çᑗ¡ß¾ÞbNᑮSheet3,Sheet3c,¹L஻Þ¾ᑖ᪆N஻ᓽ/DE&'஺

4éᙠூê⚪௃$ᓫ⌱%ூÅᐭὃᦻᜳ௃,-ëᢥ᯿⚪ìADE☢Ḅí²஺îÁïḄᦻðñòóᙠὃᦻᜳHôõöE÷?ᙠ]øùúûNü├þÿ
ᳮ⌕Ḅᳮ├Ḅᑖ᪆஺!᪷#├ᦪ#%⊤'"Excel,xlsx”ᦻ34ᢥ᯿᝞89:;<=>ᑖ᪆?1.B"CᓫEF”⊤GHIJK᦮MNᝅᵨ⊤IIJQRSᡠᨵḄ├=>K᦮VWḄ᜜YIJZS"ᓫ["ᑡ"]^”ᑡᡠᒹ`ḄᓫᐗIK᦮"b^cᵨ"'def4ᦪgIJ஺2.᪷#ijklᙠ஻CᓫEF”⊤Ḅ"ijop”ᑡqrᵨVLOOKUPyᦪ;ᡠᨵCᓫḄ├ZSᐸ|ᑏᙠ“=>%"⊤ḄB3ᓫᐗIq஺6.᪷#஻CᓫEF”⊤qḄ├ᦪ#=>MSOfficeᵨijᙠ2023Ḅ├ZSᐸ|ᑏᙠ“=>%"⊤ḄB4ᓫᐗIq஺7.᪷#"CᓫEF”⊤qḄ├ᦪ#=>◖jᙠ20233Ḅ├ZSᐸ|ᑏᙠ"=>%"⊤ḄB5ᓫᐗIq஺

5&᪷#"CᓫEF¢⊤qḄ├ᦪ#=>◖jᙠ2023Ḅᨴ¤ᙳ├'¦§2¨]ᦪ4ZSᐸ|ᑏᙠ“=>%”⊤ḄB6ᓫᐗIq஺9.¦§"Excel,xlsx”ᦻ3஺1.ூª⚪¬⁚௃¬⁚1?¯{ὃ±ᦻ38Ḅ"Excel,xlsx",ᡭ³”CᓫEF⊤”⊤஺¬⁚2?⌱q⊤qḄA2?H636ᓫᐗI⌱µᓫ¶ூ³·௃⌱⚗ᓱ8ூ᪵J௃»qḄ”ᝅᵨ⊤IIJ"ᢥ¼ᙠ½¾Ḅ8¿ᑡ⊤q⌱ÀVÁ⊤᪵JÂᜐᡃÅ⌱À"⊤᪵JÆ⁐10”ÈÉ஺½¾”ᝅᵨ⊤IJ஻BÊ᪾஺¦§ÌÍÎÏÐᓫ¶"Ñ:”ᢥ¼ᓽÓ஺¬⁚3?⌱q"ᓫ["ᑡ"]^”ᑡÔ¶Õ᪗ᙠ½¾Ḅ×ᣩÙᓫq⌱À”ÎÏᓫᐗIIJ”ÈÉÚÛ½¾”ÎÏᓫᐗIIJ”BÊ᪾஺ᙠ"ᦪg"⌱⚗ᓱ8Ḅ஻ᑖÜ"»q⌱À"b^cᵨ”ÈÉᯠÐᓫ¶”Þfßl'àá/ᙢµ4”8¿ᑡ⊤⌱À"CNY"஺2.ூª⚪¬⁚௃¬⁚1?ᙠ"CᓫEF⊤”⊤ḄE3ᓫᐗIqäᐭ”=VLOOKUPD3,klB᯿!$A$3:$C$19,2,FALSE
",ᢥ"Enter”ç;

6¬⁚1?ᙠ”=>%஻⊤qḄB3ᓫᐗIäᐭ'SUM'CᓫEF⊤!H3:H636
”,ᢥ"Enter”çÐ;<├Ḅz{|ᐙ஺¬⁚2?ᓫ¶B4ᓫᐗIÔïḄ”z{ðñ⌱⚗”ᢥ¼⌱À”òó^ᑡ“஺6.ூª⚪¬⁚௃¬⁚1?ᙠ"CᓫEF⊤”⊤qᓫ¶஻ôõ"ᓫᐗIḄ8¿ᢥ¼⌱À"ö÷"ÈÉ஺¬⁚2?ᑗᣚú“=>%”⊤ᙠB4ᓫᐗIqäᐭ”=SUMPRODUCT1*CᓫEF⊤!E3:E262="MSOfficeᵨ"
CᓫEF⊤!H3:H262
”,ᢥ"Enter”çûÍ஺7.ூª⚪¬⁚௃¬⁚?ᙠ"=>%”⊤ḄB5ᓫᐗIqäᐭ”=SUMPRODUCT1*CᓫEF⊤!C350:C461="◖j"4CᓫEF⊤!H350:H461
",ᢥ"Enter”çûÍ஺8.ூª⚪¬⁚௃¬⁚?ᙠ"=>%”⊤ḄB6ᓫᐗIqäᐭ”=SUMPRODUCT1*CᓫEF⊤!C350:C636="◖j”4CᓫEF⊤!H350:H636
/12",ᢥ"Enter”çûÍᯠÐÎÏüᓫᐗIIJ¦§2¨]ᦪ஺9.ூª⚪¬⁚௃¬⁚?ᓫ¶"¦§"ᢥ¼ᓽÓ;<"Excel.xlsx”ᦻ3Ḅ¦§஺ᙠூý⚪௃Ùᓫ8⌱ÀூGᐭὃ±ᦻ3ᜳ௃ÈÉZᢥ᯿⚪ÿ
☢Ḅ஺ḄᦻᙠὃᦻᜳᑢᡠḄᜐ!"#$!"%▾Ḅᡂ()ᳮ஺+,-Excelᩭ)ᳮᡂ($/ᙠ0112ὃ34456$ᑢ789:;<9=ᑖᡂ(?ᐭAᦻBC“0112ᡂ(.xlsx”ḄExcelFGᦻ᫏஺

7IJ᪷Lᑡ
NOᑢPQRᡂ(ᓫTU᦮ᳮWᑖ᪆:1.IQ"0112ᡂ(”F⊤TU_`a᦮$,-ᝅᵨ⊤__`de7ᡠᨵḄᡂ(g?a᦮ChḄ᜜j_`$kQRF⊤”0112ᡂ(஻ḄᦪLᑡ⊤TU_`ᓄ70ᑡ"o”ᑡpCᦻ%$7ᡠᨵᡂ(ᑡpCqrᦪḄᦪs$ptQud`$vw〉yḄz᪾W|}~F⊤j஺2.ᵨ"ᩩ_`”TUᑡpt7ᦻஹᦪஹ᜜:110ᑖḄᡂ(ᡠᙠḄᓫᐗ_⁐ᐙ$ᡠᵨ⁐ᢱᦪLC஺3.ᵨsumWaverage£ᦪ¤¥¦;Ḅ§ᑖ¨©ᙳᡂ(஺4.o04ஹ5r⊤ᡠᙠḄ<9$®᝞”C120231”⊤1291<஺I,-£ᦪ±²¦;ᡠᙠḄ³´kᢥᑡ¶·ᐵ¹ᑏᙠ"<9”ᑡo”Ḅ4ஹ5r¶·<9011<022<033<5.᪷Lo$Iᙠ"0112ᡂ(”F⊤Ḅ"»B”ᑡ$~ᵨVLOOKUP£ᦪ»BḄÂÃᐙ஺"»B"W"o"Ḅ¶·ᐵ¹ᙠ“oQ᯿"F⊤஺6.ᙠ஻ᡂ(ᑖÆǧ஻,-ÈÆǧÉʦ;<ᔜḄᨬᜧs$k7ǧ5ÎÏÐᙠᦪLd஺7.ᑖÆǧ5ÎCÒẠ$ÔÕ;Ö×ᩩØÙ$Q¦;<ᔜᨬᜧsTUÚÛ஺1.ூÝ⚪ß⁚௃ß⁚1âÃὃᦻḄ”0112ᡂ(.xlsx"஺

8ß⁚2⌱ᓫᐗ_A2L20æç$ᓫèூéê௃⌱⚗ᓱூ᪵`௃îḄ”ᝅᵨ⊤__`”ïᢥð$ᙠñÊḄïᑡ⊤⌱ò"⊤᪵`⁐16஻óô஺ß⁚3:⌱"o"ᑡ$õèö᪗ᙠñÊḄøᣩúᓫ⌱ò"ptᓫᐗ__`”óô$ñÊ”ptᓫᐗ__`”Qû᪾$ᙠ“ᦪü"⌱⚗ᓱḄ"ᑖÆ"î⌱ò஻ᦻ%”óô$ᓫè"ý
”ᢥðᓽÿ
஺⁚4⌱ᡠᨵᡂᑡ᪗ᙠḄᣩᓫ⌱”ᓫᐗ”!""ᓫᐗ”$%᪾ᙠ"ᦪ("⌱⚗ᓱḄ"ᑖ,"⌱"ᦪ-"!"ᙠ.ᦪ/ᦪ01᪾.ᦪ/ᦪ2"2"஺⁚5:⌱ᡠᨵᦻ(ᑁ5ᓫᐗᓫூ78௃⌱⚗ᓱ:ூ$;<௃=Ḅ“?"ᢥA஺⁚6ᙠ”ᓫᐗ”$%᪾"B᪾"⌱⚗ᓱ:"⚜D"=⌱"᜜B᪾"F"ᑁG”!"஺ᓫ"HI”ᢥA
஺2.ூL⚪⁚௃⁚1⌱D2:F20ᓫᐗNOᓫூ78௃⌱⚗ᓱ:ூ᪵௃=Ḅ"ᩩR”:SᢥA⌱"TUVᓫᐗWᑣ”Ḅ"ᐸZWᑣ”!"஻\]Wᑣ஻$%᪾஺ᙠ”^_Wᑣ`a஻⌱⚗:ᓫᐗ-ᜧcᡈec110,ᓫ""ᢥA”ᓫᐗ”$%᪾ᙠ"fᐙ"⌱⚗ᓱ:⌱"h⁐"!"ᯠkᓫ"HI"ᢥA஺⁚2lmᓫ"HI”ᢥA஺3.ூL⚪⁚௃⁚1ᙠK3ᓫᐗnᐭ"=SUM(D3:J3)”,ᢥEnterpk
qᑖḄrsfᐙ஺⁚2ᙠL3ᓫᐗnᐭ”=AVERAGE(D3:J3)/ᢥEnterpk
tᙳᑖḄrsfᐙ஺

94.ூL⚪⁚௃⁚1ᙠC3ᓫᐗnᐭ”=IF(MID(A3,4,2)="0T,"lv",x1\/1x(z3,4,2)="02","2v",”3v"))"ᢥEnterpk
v|Ḅrsfᐙ஺5.ூL⚪⁚௃⁚1ᙠB3ᓫᐗnᐭ”=VL00KUP(A3,}~$᯿!$A$3:$B$20,2,FALSE)”,ᢥEnterpk
Ḅrsfᐙ஺6.ூL⚪⁚௃⁚zᙠ”ᡂᑖ,q”⊤⌱C3C20ᓫᐗNOᓫூᦪ௃⌱⚗ᓱ:ூ᣸F⌱௃=Ḅ"ᓣ"ᢥA"᣸⏨”$%᪾⌱”⌱INO”ᓫ⌱ᢥA஺ᓫ"᣸”ᢥA
"v|"ᑡḄᓣ᣸஺⁚2⌱C21ᓫᐗᓫூᦪ௃⌱⚗ᓱ:ூᑖ|UV௃=Ḅ“ᑖ,q஻ᢥA"ᑖ,q”$%᪾ᓫ"ᑖ,(":SᢥA⌱"v|”⌱᪾ᓫ஻q<”:SᢥA⌱"ᨬᜧ-"!"ᙠ"⌱Iq⚗"=⌱"ᦻ"ஹ"ᦪ}"ஹ""ஹ"ᱥ"ஹ"ᙢᳮ"ஹ"ᔊ"ஹ""⌱᪾⌱”qUVᙠᦪ:<“⌱᪾஺⁚3:ᓫ"HI"ᢥA஺7.ூL⚪⁚௃⁚1⌱¡¢vᔜ¤ᨬᜧᡂᡠᙠḄᓫᐗᓫூ¥ᐭ௃⌱⚗ᓱ:ூ¦⊤௃="ᩩ§¦":SᢥA⌱"¨©ᩩ§¦”!"஺⁚2¦⊤NᙠḄᣩᓫ⌱“⌱ᦪ"!"”⌱ᦪª"$%᪾⌱"¦«⚗":Ḅ"¬ᑡ1",ᓫ”^_஻ᢥA”^_ᦪ¬ᑡ”$%᪾ᙠ"¬ᑡ"nᐭ"1v”஺

10⁚3
ᓫ஻HI”ᢥAkᢥ᯿®᪵<¯^_"¬ᑡ2"ஹ"¬ᑡ3"2"2v"ஹ"3v⁚:4
ᙠ஻⌱ᦪª஻$%᪾⌱“°t±ᑖ,²³᪗´":Ḅ"1",ᓫ”^_஻ᢥA"³᪗´"$%᪾ᙠ"³᪗´NO”ᦻµ᪾nᐭ"ᦻᦪ}ᱥᙢᳮᔊ”஺⁚5
ᓫ"HI"ᢥAᓽ·
஺8.ூL⚪⁚௃⁚ᓫ"¸¹"ᢥA
”º»}¼¼½ᡂ.xlsx”Ḅ¸¹஺¾ᙠூ¿⚪௃ᓫ:⌱ூÀᐭὃᦻÂᜳ௃!"Äᢥ᯿⚪ÅWI
:☢ḄÇ஺ÈÉÊ:ḄᦻÂË̸¹ᙠὃᦻÂᜳ:.ÍᙠÎ<ÏÐÑÒÓÔᳮÕÖ.Í×ØÙÏÐᕒ᫏ᫀÝÞḄᑖ᪆Fq஺¾à᪷Î<ÏÐᕒ᫏ᫀ⊤"Excel,xlsx”ᦻ²ᢥ᯿᝞:WI
×ØFᑖ᪆1.¾$"ᕒ᫏ᫀ⊤”⊤ÀÓ1᦮äᡠᨵåᑡ2¸¹æ/.ᦪḄᦪ-〉èéᜧÓêᑡë஺2.᪷ìíî~¾ᙠ”ᕒ᫏ᫀ⊤”⊤Ḅ"ï¼”ᑡðᵨMIDòᦪóᕒïᓫᐗ,ô2"yyyy'ÕHᨴ÷ïJ3.᪷ᐭùúû¾ᙠ”ᕒ᫏ᫀ⊤"⊤Ḅ"ü”ᑡðᵨTODAYòᦪFINTòᦪýþᕒḄü,ÿ
ᐭ஺4.ᵨ"஻⊤Ḅᦪᩭ”ᕒ᫏ᫀ⊤”⊤ᕒḄᙠ"Ạ”ᑡḄẠ஺!Ạ=#+%

115.᪷"ᕒ᫏ᫀ⊤஻⊤Ḅᦪ)*ᡠᨵḄẠJL-./0ᐸ2ᑏᙠ“)*56”⊤ḄB2ᓫᐗ9஺6.᪷"ᕒ᫏ᫀ⊤”⊤Ḅᦪ)*:;<⚗>?ᳮḄ#-./0ᐸ2ᑏᙠ")*56஻⊤ḄB3ᓫᐗ9஺7.᪷”ᕒ᫏ᫀ⊤”⊤Ḅᦪ)*ABCD#EFGᙳ#/0ᐸ2ᑏᙠ")*56"⊤ḄB4ᓫᐗ9஺8.IJKLM-NOPQ:;ḄGᙳ#஺9.RSTUVᕒḄ#WXYZ/0[U⊤\]ᙠ")*56"஺10.^_"Excel,xlsx”ᦻa஺1.ூc⚪e⁚௃e⁚1hijὃFᦻalḄ"Excel,xlsx",ᡭn"ᕒ᫏ᫀ"⊤஺e⁚2h⌱ᡠᨵᑡᓫᐗ9ᓫpூnq௃⌱⚗ᓱlூᓫᐗ9௃sḄ"9t"ᢥvᙠwQḄlxᑡ⊤⌱y”z{ᓫᐗ99t”|}wQ"z{ᓫᐗ99t”V~᪾஺ᙠ"ᦪ"⌱⚗ᓱ"ᑖL"s⌱y"ᦪ"|}ᙠᦪᦪ᪾z{ᦪᦪ<"2"஺z{ᓫp""ᢥvᓽ஺e⁚3h⌱ᡠᨵᓫᐗ9ᑁᓫpூnq௃⌱⚗ᓱlூᓫᐗ9௃sḄ“9t"ᢥvᙠwQḄlxᑡ⊤⌱y"X"|}wQ"X"V~᪾z{X<"15”஺z{ᓫp""ᢥvᓽ஺.e⁚4hᓫpூnq௃⌱⚗ᓱlூᓫᐗ9௃sḄ஻9t"ᢥvᢥ᯿z{X᪵ᙢBtz{"ᑡ"<"10"஺ᨬᓫp"”ᢥvz{஺2.ூc⚪e⁚௃e⁚hᙠ“ᕒ᫏ᫀ⊤”⊤ḄG3ᓫᐗ9ᐭ”=MID(F3,7,4)&"
"&1\/123,11,2)&”ᨴ"&MID(F3,13,2)&"

12”,ᢥ஻Enter஻ᯠᔣl2ᐙCtᑮᨬᕒ஺3.ூc⚪e⁚௃e⁚hᙠ”ᕒ᫏ᫀ⊤஻ḄJ3ᓫᐗ9ᐭ஻=INT((TODAY()-I3)a65)஻⊤¤¥¦§¨©ᐭ:ª«Ḅ¬.◀®365ᜩ°ᔣl±᦮ᢥEnterᯠᔣl2ᐙCtᑮᨬᕒ஺4.ூc⚪e⁚௃e⁚1hᙠ”ᕒ᫏ᫀ⊤஻ḄL3ᓫᐗ9ᐭ஻=J3*!$B$3஻ᢥ஻Enter஻ᯠᔣl2ᐙCtᑮᨬᕒ஺e⁚2hᙠM3ᓫᐗ9ᐭ஻=K3+L3஻ᢥ஻Enter஻ᯠᔣl2ᐙCtᑮᨬᕒ஺5.ூc⚪e⁚௃e⁚hᙠ஻)*56஻⊤ḄB2ᓫᐗ9ᐭ஻´SUM(ᕒ᫏ᫀ!M3:M37)஻ᢥ஻Enter஻஺6.ூc⚪e⁚௃e⁚hᙠ஻)*56”⊤ḄB3ᓫᐗ9ᐭ஻=SUMIF(ᕒ᫏ᫀ!E3:E37,”⚗>?ᳮ“ᕒ᫏ᫀ!K3:K37)஻ᢥEnter஺7.ூc⚪e⁚௃e⁚hz{஻)*56஻⊤ḄB4ᓫᐗ99t<2ᦪᯠᙠB4ᓫᐗ9ᐭ஻;AVERAG·F(ᕒ᫏ᫀ!H3:H37,“#E“ᕒ᫏ᫀIK3:K37)஻,ᢥEnter஺8.ூc⚪e⁚௃e⁚1hᙠ஻ᕒ᫏ᫀ⊤஻⌱E38ᓫᐗ9ᓫpூᦪ௃⌱⚗ᓱlூᑖ¸¹º௃sḄ஻ᑖLM-”ᢥvwQ஻ᑖLM-஻V~᪾஺ᓫp஻ᑖL»஻sḄlxᢥv⌱y஻:;”ᓫp஻M-Bt஻sḄlxᢥv⌱y“Gᙳ"|}ᙠ஻⌱M-⚗”s¼⌱஻#஻½⌱᪾஺e⁚2hᓫp஻஻ᢥvᓽ¾ᑮ¿▭ᦔÂ஺

139.ூc⚪e⁚௃e⁚1hª⌱:;Gᙳ#ᡠᙠḄᓫᐗ9ᓫpூÅᐭ௃⌱⚗ᓱlூU⊤௃sḄ"TU"ᢥv⌱y”ᑖÆÇTU”஺e⁚2hÉpU⊤Ê⌱y"⌱yᦪ"|}wQ”⌱yᦪË”V~᪾⌱”ÌG!ᑖL%Í᪗Ï"lḄ"1",ᓫp"ÐÑ"ᢥvwQ"Í᪗Ï”V~᪾ᙠ“Í᪗ÏÊÒ"ᐭ”ÓÔ?ᳮ,ÕXÖ?ᳮᦻ×⚗>?ᳮ,├Ù?ᳮẆÛ?ᳮᕒ-?ᳮ”஺e⁚3hᓫp""ᢥve⁚4hÞᑗ[U½ᑴᑮ")*56"⊤஺8.ூc⚪e⁚௃e⁚hᓫp“^_"ᢥv^_"Excel,xlsx”ᦻa஺èᙠூé⚪௃êᓫl⌱yூWᐭὃFᦻaë௃|}/ᢥ᯿⚪>ìl☢Ḅî஺ïðh®lḄᦻañò^_ᙠὃFᦻaᜳlôõ
öᙠ÷øUù├ÙCDúûüýÓþᳮÿ⌕Ḅᳮ├Ḅᑖ᪆஺᪷├⊤"ExceLxlsx”ᦻ*+,ᢥ᯿᝞0,23456ᑖ᪆71.;"sheet/⊤?@“├BC",;"sheet2”?@"EF3G”஺2.ᙠ"EF@I”ᑡKLMᐭ•PQᑡ,Rᐭᑡ᪗⚪஻ᓫG,3.;⊤᪗⚪XᑡᔠZ[\]Z〉_`᦮ᐸcdஹfᜧch,Zᦋjcdk⁐஺mnᦪ⊤pqrstᓫGuvḄᦪwxsyz2{uᦪ+஺᪷EF|h,ᙠ"├BC"⊤Ḅ"ᓫG”ᑡ],}ᵨ

14VLOOKUPᦪ45EFᓫGḄᐙ஺"ᓫG""EF|h”Ḅᐵᙠ“EF3G”⊤]஺4.ᵨsv⊤“├BC”]HᑡḄuv஺5.⊤"├BC”]Ḅ├ᦪPᦪ⊤,ᙠP@”ᦪᑖ᪆”Ḅ⊤],23┐pᔜFᔜFᜩᜩḄ├஺ᐸ]7F@Iᑡ᪗¡,¢£EF@I¤᪗¡,Zp├¥஺6.᪷§ᡂḄᦪ⊤,ᙠ⊤©rPª«¬E,E⊤]®p¯°Fᨴ²Ḅ├uv³¤-7.yz"Excel.xlsx”ᦻ*஺Lூ·⚪¸⁚௃¸⁚17»¼ὃ§ᦻ*ᜳ©Ḅ"Excel,xlsx"஺¸⁚27¿À"sheetl”⊤@,Á"sheell”ᕈ|ë᝱[Rᐭ"├BC"ᓽÆ,ᢥ᯿Ç᪵Ḅrs;"sheet2"?@"EF3G”஺2.ூ·⚪¸⁚௃¸⁚17ᙠ"├BC”⊤],⌱]“├ÊË+”ᡠᙠḄᑡ,ᓫÀÍ᪗KÎ,ᙠÏÐḄḄÑᣩÓᓫ]⌱Ô"Mᐭ"⌱⚗஺¸⁚27⊤]ÖᓽÐ×MᐭḄᑡ஺¸⁚37⌱]F3ᓫᐗx,Rᐭ"ᓫG"Úc஺3.ூ·⚪¸⁚௃¸⁚17ᙠ"├BC”⊤]⌱]Al7H1ᓫᐗx,ᓫÀÍ᪗KÎ,ᙠÏÐḄÑᣩÓᓫ]⌱Ô"mnᓫᐗx

15xs”?Ü,ÏÐ஻mnᓫᐗxxs”pÝ᪾஺ᙠ"pq”⌱⚗ᓱ©Ḅ“ᦻËàᑴ"â],ã⌱"ᔠZᓫᐗx"ä⌱᪾åᙠ஻ᦻËpqrs"âḄ"æçpq஻⌱⚗©⌱Ô"\]",è[ᓫÀ"é3"ᓽÆ஺¸⁚2åᢥ᯿Ç᪵Ḅrsᡭë஻mnᓫᐗxxs”pÝ᪾,ᑗᣚî஻cd”⌱⚗ᓱ,ᙠ"cd஻©ïᑡ⊤]⌱Ôðᔠ〉Ḅcd,ñᜐᡃô⌱Ô"õö÷ø"஺ᙠ"ch"©ïᑡ⊤]⌱Ôðᔠ〉Ḅch,ñᜐᡃô⌱Ô"16”஺ᙠ"k⁐”©ïᑡ⊤]⌱Ôᔠ〉Ḅk⁐,ñᜐᡃô⌱Ô஻᪗ù⁐"]Ḅ"ú⁐”஺¸⁚37;ᐝ᪗üᦪýþÿ
ᢥCtrl+A⌱᦮ᦪ⊤ᙠூ௃⌱⚗ᓱḄூ௃⌱ᔠ〉Ḅᜐᡃ!⌱"#"஺%⁚4'()⌱"ᓫ+","-.”ᑡ123᪗ᙠ56Ḅ7ᣩ9ᓫ⌱”:;ᓫᐗ==”>?56”:;ᓫᐗ==”@᪾஺ᑗᣚD"ᦪE”⌱⚗ᓱᙠ“ᑖH”Iᑡ⊤⌱"ᦪJ">?ᙠ1KḄ-ᦪ
ᦪLM᪾Nᐭ"2”,:;PQRᓫ2"ST"ᢥUᓽW஺4.ூZ⚪%⁚௃%⁚1'ᙠ"├]^_”`a⊤ḄF3ᓫᐗ=Nᐭ”=VL00KUPD3,bcT+!$A$3:$C$19,3,FALSE
",ᢥ"Enter”efᯠRᔣiᐙkᑮᨬRnᦪo஺%⁚2'ᙠ"├]^_”`a⊤ḄH3ᓫᐗ=Nᐭ"=F3*G3”,ᢥ"Enter"efᯠRᔣiᐙkᑮᨬRnᦪo஺5.ூZ⚪%⁚௃%⁚1'ᙠ"├]^_”`a⊤⌱ᦪpqᙠூrᐭ௃⌱⚗ᓱḄூ⊤=௃ᓫ2”ᦪst⊤”ᢥU,ᡭ"wxᦪst⊤”@᪾ᙠ”⌱yᦪst⊤Ḅ
”⌱஻{`a⊤%⁚2'ᓫ2"ST"ᢥURᓽW|ᑮ}▭ᦔ஺%⁚3'2"Sheetl",>"ᦪstᑖ᪆"஺%⁚4'3᪗y''c.3᪗ᜮᔣᓝEᜮR3᪗ᑮ"ᑡ᪗”ᢥ᯿(᪵Ḅ"","bc"ᑮ"o᪗""-."D"ᦪJ"஺

166.ூZ⚪%⁚௃%⁚1'⌱c├]-.ᓫ2ூrᐭ௃⌱⚗ᓱூb⊤௃Ḅ"b”ᢥUᙠ56ḄIᑡ⊤⌱”b”஺%⁚2'ᙠ"ᦪstb”ᓫ2஻c”1K¢£ᢥUᙠIᑡ⊤¤⌱“c%⁚3'ᓫ2"ST"ᢥU7.ூZ⚪%⁚௃%⁚'ᓫ2"§¨"ᢥU§¨"Excel,xlsx”ᦻ°஺±ᙠூ²⚪௃9ᓫ⌱ூ³ᐭὃµᦻ°ᜳ௃>?·ᢥ᯿⚪¸¹TPQ☢Ḅ»a஺¼'½Ḅᦻ°¾¿§¨ᙠὃµᦻ°ᜳᦻÀÁᜧᙢkÄḄ├]ÅÆᳮÈÉᐰkÄḄ├]^_³oËÌᑖ᪆·ÍÎÏÐ├]ÅÑᳮ஺ÒÓ᝛᪷ᔜ×ÎÏḄ├]Ø⊤³oËÌᑖ᪆஺ᡭ".ÙÚ:ᜓᐰÒ├ÜÝË⊤.xlsx”,ÞÆᦻÀPQ½»a'1."sheet/`a⊤>“├]^_""sheet2">"âᙳᓫ+"஺2.ᙠ"ä”ᑡåKrᐭnæᑡNᐭᑡ᪗⚪"çè"·½001ஹ002ஹ003……ḄᔣiᐙìᑡᑮᨬRnᦪo஺3.`a⊤᪗⚪íᑡᔠ·R#·〉îM᦮ᐸEðஹñᜧEè·ᦋEðó⁐஺〉îñᜧᦪ⊤oõ,ᑡö:;÷├]ᦪᑡḄᦪJ=ø§¨2
-ᦪù·ᦪpqúûü᪾ý஺4.`a⊤"âᙳᓫ+”ḄpqB3:C7“ᖪᙳ”஺ᵨ⊤“├"FᑡḄ├"#$ᙠ&'VL00KUP.ᦪ01ᙠ⊤"2ᙳᓫ”456ᐵᖪḄᓫ#8ᙠ9ᵨᡠḄ"ᖪᙳ”஺

175.⊤"├”Ḅ├ᦪ<=>?@ᦪ?@pqrst#t⊤uIᔜNOv@QRwxyḄ├"c[LM஺7.{|”}eᜓᐰ├x⊤.xlsx"ᦻ஺1.ூ⚪⁚௃⁚1T"sheetl"⊤#"sheet/ᕈ⌱q᝱bᐭ"├”ᓽ#ᢥ᯿᪵Ḅo"sheet2""2ᙳᓫ"஺2.ூ⚪⁚௃⁚1T⌱஻OZ”ᡠᙠḄᑡ#ᓫ᪗#ᙠḄᣩ¢ᓫ⌱£"¤ᐭ"⌱⚗஺⁚2T⊤¦ᓽ§G¤ᐭḄ?ᑡ஺⁚3TA3ᓫᐗd#ᐭ"©ª"«X஺⁚4TᙠA4ᓫᐗdᐭ“'001",ᯠb᪗®A4n¯Ḅ°ᐙ²ᜐ஺⁚5Tᢥ´"Ctrl"Ḅµ¶1°ᐙ²஺⁚6T¶1°ᐙ²·¸ᔣn°ᐙºᑡ#»ᑮᨬb?@ᦪ<[஺3.ூ⚪⁚௃⁚1T⌱AlTF1ᓫᐗd½¾#᪗#ᙠḄᣩ¢ᓫ⌱£"e¿ᓫᐗdd”À஺஻e¿ᓫᐗdd”IÁ᪾஺ᙠ"IÔ⌱⚗ᓱnḄ"ᦻyÅᑴ”Ç#È⌱”ᔠ8ᓫᐗd"Tᙠ"ᦻyIÃo“ÇḄ"Ê2IÔ⌱⚗n⌱£஻Ë”஺Ìbᓫ஻Í”ᓽ஺⁚2Tᢥ᯿᪵ḄoᡭÏ”e¿ᓫᐗdd”IÁ᪾#ᑗᣚ®"XÒ"⌱⚗ᓱ#ᙠ‘'XÒ"nÕᑡ⊤⌱£?

18Öᔠ〉ḄXÒ#ØᜐᡃÚ⌱£"ÛÒ஻஺ᙠ஻Xª஻nÕᑡ⊤⌱£?Öᔠ〉ḄXª#ØᜐᡃÚ⌱£"14"஺ᙠ"Þ⁐”nÕᑡ⊤⌱£ᔠ〉ḄÞ⁐#ØᜐᡃÚ⌱£"àá#ᦻX2,à⁐50ä஺⁚3Tᓫ"Í"bᓽ஺⁚4T⌱AlTF83ᓫᐗd½¾#ᙠூÏè௃⌱⚗ᓱnḄூᓫᐗd௃Ç#ᓫ"d”nÕᑡ⊤#ᙠḄnÕᑡ⊤⌱£"[é"À#ᙠIÁ᪾ᐭᔠ〉Ḅᦪêᓽ#ØᜐᡃÚᐭ"20”,ᐭëìbᓫ”Í”ᓽ஺⁚5Tᢥ᯿᪵Ḅo⌱£"ᑡí"À#ØᜐᡃÚᐭT2”,ᐭëìbᓫ"Í”ᓽ஺⁚6Te¿ëì[éðñᑡí#òóᑮô▭ö÷Ḅᦔù஺⁚7T⌱ᦪ<⊤#ᙠூÏè௃⌱⚗ᓱnḄூIÃo௃Ç⌱£ᔠ〉ḄIÃo#ØᜐᡃÚ⌱£"Ë"஺⁚8T⌱ᦪ<½¾#ᓫ᪗#ᙠḄᣩ¢ᓫ⌱£”e¿ᓫᐗdd”À#”e¿ᓫᐗdd”IÁ᪾஺ᑗᣚ®"ú᪾"⌱⚗ᓱ#ᙠ"⚜D"Ç⌱"᜜ú᪾"#ᙠ"ýᩩ"ÇḄ"᪵”n⌱£?Öýᩩ᪵#Ìbᓫ"Í”ᓽ஺⁚9⌱"├"ᦪᑡᓫ᪗ᙠḄᣩᓫ⌱”ᓫᐗ””ᓫᐗ”!"᪾஺ᑗᣚ'"ᦪ(”⌱⚗ᓱᙠ"ᑖ,”-.ᑡ⊤⌱"ᦪ0"ᙠ1Ḅ“34"5ᐭ"2”,9:;ᓫ<=ᓽ?஺4.ூC⚪E⁚௃E⁚1ᙠ"IᙳᓫK”LM⊤⌱B3C7STᓫ᪗ᙠḄᣩᓫ⌱"=UVW",ᡭY“Z[VW“!"᪾஺ᙠ''VW"5ᐭ"ᖪ^ᙳK”;ᓫ<=ᓽ?஺E⁚2᪷⚪`ᙠ“├ab஻⊤⌱“├”ᑡᓫ᪗ᙠḄḄᣩᓫ⌱஻dᐭ”⌱⚗ᓽ?ᙠe1dᐭfᑡᙠF3ᓫᐗ5ᐭ᪗⚪"IᙳᓫK"஺E⁚3ᙠF4ᓫᐗ5ᐭ"=VL00KUPoD4,ᖪ^ᙳK2,FALSEt\ᯠ;ᢥEnter|}ᓽ?~”IᙳᓫK”LM⊤ḄIᙳᓫKᐭᑮ"├ab”LM⊤஺E⁚4F4-Ḅᐙ'ᨬ-fᦪᜐ9:IᙳᓫKḄᐙ஺E⁚5᪷├IᙳᓫK├஺ᙠG4ᓫᐗ5ᐭ"=E4*F4”,ᓽ?஺E⁚6G4-Ḅᐙ'ᨬ-fᦪᜐ9:├Ḅᐙ஺

195.ூC⚪E⁚௃E⁚1ᙠ[ᦪ⊤⌕ᦪST⌕ᨵᑡ᪗⚪¢£¤ST¥ᨵ¦஺E⁚2§⌱ᦪSTᙠூdᐭ௃⌱⚗ᓱ-Ḅூ⊤௃¨ᓫ"ᦪ⊤"ᢥ©ᡭ.Y”[ᦪ⊤”!"᪾஺E⁚:3ᙠ”⌱f«⊤ᡈST"⚗-Ḅ"⊤/ST”᪾®3¯°⌱Ḅᦪ±ST஺²ᜐ!³}⌱´Mµᦋ஺E⁚4ᢣ=ᦪ⊤¸¹Ḅº»⌱"ZLM⊤"ᓫ"<=”ᢥ©஺E⁚5Excel¿À¦Ḅᦪ⊤ÁÂᑮᢣ=º»¢ᙠ1®3"ᦪ⊤(Ãᑡ⊤"ÄÅ஺Æ"Sheetl”,ÈVÉ"ᦪᑖ᪆”஺E⁚6À᪗¹»Ë"ᖪ^VW"ÌÍ᪗ÎᜮÐÉÆᔣᓝ(Îᜮ;᪗ᑮ"Ó⊤Ô⌱"ᓽ?Àᖪ^VWMÉÓ⊤Ô⌱(Ã஺ᢥ᯿Ö᪵ḄØ"ÙÚ"ᑮ"᪗Û"ஹ"ÝÞ"ᑮ"ᑡ᪗Û"”├"'"ᦪ0"஺E⁚7!ᦪ⊤ß〉¯Ḅ஺ᓫூYá௃⌱⚗ᓱ-ூ᪵௃¨Ḅ”ᝅᵨ⊤"ᢥ©ᙠḄ-.ᑡ⊤⌱fäᔠ〉Ḅ᪵²ᜐᡃç⌱"᫏éê"-Ḅ"ᦪ⊤᪵᫏éê2”஺6.ூC⚪E⁚௃E⁚1ᓫᦪ⊤STḄë`ᓫᐗì;ᙠ“ᦪ⊤Lᐹ”Ḅூ⌱⚗௃⌱⚗ᓱ-ᓫ"Lᐹ"¨Ḅ"ᦪî"ᢥ©ᡭY"dᐭî⊤”!"᪾஺E⁚2²ᜐᡃç⌱"ïðñòî”ᓫ஻<=”ᢥ©;ïðñòî஺E⁚3ᙠ"ᦪî"ᓫ"ᖪ^VW”1-.ᑡ⊤ó⌱”ôõöE⁚4:ᓫ"<=”ᢥ©;ᓽ?ó®3ᔜøÙù«ÝÞôõöḄ├ab஺E⁚5ᨬ;ᓫ"¸"ᢥ©¸”úᜓᐰý├þõ⊤.xlsx”ᦻ஺ᙠூ⚪௃ᓫ⌱ூᐭὃᦻᜳ௃ᢥ᯿⚪☢Ḅ"#஺$᪍&ᓅ()*ᜧ-./ᜐḄ1223452346Ạ89:;<ᦟẆ82023BḄCDᣴCFGH

20J./ᜐKL᪶3NOPQ8ḄCRS஺᪷Uὃᦻᜳ”Vᩞ.xlsx”[Ḅᔜ]FG^_$᪍᪶3`2346Ạ82023BabcᦟᕒḄCRSFG஺ᐹf᝞h1.j”Vᩞ.xlsx”klm஻CRS.xlsx”ḄᦻᡠᨵḄ"#6qrstluḄᦻ஺2.j"CRSwx⊤"᪗{|⁐~ᦋm⁐j᪷U⊤FGᔠmcᓫᐗᔠ〉Ḅfஹᐸᡂm<#⊤Ḅ᪗⚪஺A2h122ᝅᵨᔠ〉Ḅ[᫏Ḅஹ᪗⚪Ḅ⊤஺6ᑡm¡[¢ᐸ£¤ᦪ¦§¨©ᨵᐵḄᑡ᪗⚪m¡[¦m«-Rᦪm᦮ᦪ¨©m®᪵tl2°$ᦪ஺3.”CRSwx⊤஻[ḄF²Lᑡ[Ḅ´µᑁ·¸¹ºᵨ»Ḅ23¼½஺᪷U"ᦟ*6¾¿À”#⊤§”CRS᪗Á”#⊤23"ÂÃ"§"CR᪗Á”ᑡᑁ·᪷U”ᣴC¿À⊤”§"CD6¾¿À”#⊤23஻-Rᦪ”ᑡᑁ·ᨬÅ"CRS”ᑡḄ23஺ூ9⏨hÇÈ"ᣴC¿À⊤”[ḄᦪUᢥÉÊ᣸ÌÅÍΔ-Rᦪ”ᑡÏÐVL00KUP᩵Ö”CD6¾¿À”⊤×ØÙÚḄ¦஺4.m“CRSwx⊤"ÝÇ•cᦪUßà⊤tlᙠsḄ#⊤[஺ᐸ[á⊤â⌱ᩩäm“Ba”ᑡ᪗{m"ᦟẆ8"᪗{m"ÂÔå§⚗m"CRS"஺ᙠ<ßà⊤ḄAI2hF24ᑁèᐭcéêëì2346Ạ8CRSÂÃḄᑖîFG஺j<#⊤Êm”ᦪUßàê”⊤᪗{|⁐mï⁐.5.tl"CRS.xlsx”ᦻ஺1.ூñ⚪ò⁚௃ò⁚1hᡭõVᩞᦻ”Vᩞ.xlsx”,ᓫ÷ூᦻ௃⌱⚗ᓱḄ"klm"ᢥùjrᦻklm“CRS.xlsx”Ḅᦻ஺2.ூñ⚪ò⁚௃:ò⁚1h«÷”CRSwx⊤”ᙠû`ḄLᣩᓫ[Ḅ“#⊤᪗{|⁐”[Ḅ஻ýf|⁐”[⌱஻⁐”஺

21ò⁚2
ᙠ“CRSwx⊤”⊤[⌱[Al
II«÷þ᪗ᙠû`ḄLᣩᓫ[⌱஻ᓫᐗ”û`”ᓫᐗ”ÿ᪾஺ᙠ"”⌱⚗ᓱḄ“ᦻᑴ”⌱”ᔠᓫᐗ"⌱᪾ᑗᣚ""⌱⚗ᓱᙠ"”!ᑡ⊤⌱$%&ᔠ〉Ḅ(ᜐᡃ+⌱$","-.஺ᙠ"/"!ᑡ⊤⌱$%&ᔠ〉Ḅ/(ᜐᡃ+⌱$"14”-.஺0⁚3
⌱A2
12223ᙠூ56௃⌱⚗ᓱḄூ᪵9௃ᓫ:”ᝅᵨ⊤9"ᢥ>ᙠ?@Ḅ!ᑡ⊤⌱$%&ាBḄ᪵9஺ᢥ᯿⚪E(ᜐᡃ+⌱$"⊤᪵9᫏GH5”-.஺0⁚4
(I?@"ᝅᵨ⊤9”J᪾⌱”⊤ᒹL᪗⚪”⌱᪾஺0⁚5
ᨬOᓫ:"PQ"ᢥ>ᓽS஺0⁚6
⌱T6ᑡU:V᪗ᙠ?@ḄWᣩYᓫ⌱$"Z[ᓫᐗ9”-.?@”Z[ᓫᐗ9”J᪾஺ᙠ"”⌱⚗ᓱḄ”ᦻ\9"Ḅ"]^”!ᑡ⊤᪾⌱$"_"-.`Oᓫ:”PQ”ᓽS஺0⁚7
᪷b⚪E⌱cᦪefghᨵᐵḄᑡ᪗⚪U:V᪗ᙠ?@ḄWᣩYᓫ⌱$"Z[ᓫᐗ9”-.?@"Z[ᓫᐗ9”J᪾஺ᙠ"”⌱⚗ᓱḄ”ᦻ\9"Ḅ"]^”!ᑡ⊤᪾⌱$"_"-.஺Z[klOᓫ:"PQ"ᢥ>ᓽS஺0⁚8
ᯠOn⌱cᦪefghᨵᐵḄᑡᢥ᯿o᪵Ḅ\9ᡭ5”Z[ᓫᐗ9”J᪾ᙠ"”⌱⚗ᓱḄ஻ᦻ\9“Ḅ"]^”!ᑡ⊤᪾⌱$"☠Ustuv\Z[klOᓫ:"PQ”ᢥ>ᓽS஺0⁚9
⌱஻xIᦪ஻ᡠᙠḄᑡU:V᪗ᙠ?@ḄḄWᣩYᓫ⌱$”Z[ᓫᐗ9”-.஺ᙠ?@Ḅ“Z[ᓫᐗ9”J᪾ᑗᣚ"ᦪ”⌱⚗ᓱ஺ᙠ"ᑖ{"⌱$"ᦪe"-.ᙠU|Ḅ“}ᦪ~ᦪ"᪾⌱$"0"஺Z[klOᓫ:஻PQ”ᢥ>ᓽS஺0⁚10
⌱”I஻f஻I᪗”ᡠᙠḄᑡᢥ᯿o᪵Ḅ\9ᡭ5”Z[ᓫᐗ9”J᪾஺ᑗᣚ"ᦪ”⌱⚗ᓱᙠ"ᑖ{"⌱$""ᙠU|Ḅ“}ᦪ~ᦪ”᪾⌱$"2"஺Z[klOᓫ:"PQ"

22ᢥ>ᓽS஺3.ூ⚪0⁚௃0⁚1ᙠᵨ9Ḅ\9“I⊤”ḄFLᑡḄᑁT\Ḅᡃ+ᐜ"ᦟஹ”¡¢⊤f”I᪗”¡¢⊤Ḅᦪb23Q£¤¥஺%\☢ᑗᣚ"ᦟ”⊤⌱ᦪb23U:V᪗ᙠ?@ḄWᣩYᓫ⌱$"Q£¤¥"-.ᡭ5"§¨¤¥”J᪾஺ᙠ"¤¥"©ᐭ"ᦟ"Oᓫ:PQᓽS஺0⁚2ᢥ᯿o᪵Ḅ\9“I᪗”Q£¤¥“ᵨ᪗”஺0⁚3ᐜ᪷b"ᦟ”⊤”I⊤""«¥"ᑡḄᑁ஺⌱"I⊤”ḄF3ᓫᐗ©ᐭ9”=VL00KUPE3,ᦟ,5,FALSE
"Oᢥ"Enter”¬ᓽS®¯Ḅ«¥ᦪb°ᵨ"I⊤”஺0⁚4ᢥ᯿᪷b“ᦟ"”I⊤""«¥"ᑡḄᑁo᪵Ḅ\9ᩭ''I᪗”ᑡḄᑁ(ᜐ³n´µ஺°ᵨ“I᪗”ḄI᪗®¯Ḅᦪb“I⊤:0⁚5·ᙠᡃ+ᩭ᪷b”ᣴ⊤”f“¹”¡¢⊤"xIᦪ”ᑡᑁ஺ᢥ᯿o᪵Ḅ\9ᐜ”¹”Ḅᦪb23Q£¤¥(ᜐᡃ+Q£"¹:0⁚6n஻ᣴ⊤”Ḅᦪbᢥº¤᣸¼஺⌱"º¤”ᑡᓫ:ூᦪb௃⌱⚗ᓱூ᣸¼f½⌱௃Ḅ"ᓣ¼”ᢥ>ᡭ5"᣸¼¿⏨”J᪾ÁÂ⌱⚗ᯠOᓫ:"᣸¼"ᢥ>ᓽS஺0⁚7ᯠOᙠ”ᣴ⊤”ḄF2ᓫᐗÃÄ"xIᦪ”ᑡᓽ©ᐭ"xIᦪ஻᪵஺0⁚8n᪷b"ᦟ""I⊤""«¥"ᑡḄᑁo᪵Ḅ\9°ᵨ”¹”ḄxIᦪᦪb®¯Ḅ”ᣴ⊤"஺0⁚9ᨬOᡃ+ᩭ“I⊤"Ḅ"xIᦪ”ᑡ஺⌱H3ᓫᐗ©ᐭ9"=SUMIFsᣴ

23⊤!$D$3:$D$72,E3,ᣴ⊤!$F$3:$F$72)”,ᯠOᢥ"Enter”¬ᓽS஺0⁚10ᙠ13ᓫᐗ©ᐭ9"=G3*H3”ᓽSklIḄ஺4.ூ⚪0⁚௃0⁚1:ᙠƨᦪbÇÈ⊤T⌕ÊËᦪb23ÌÍ⌕ᨵᑡ᪗⚪ÎÏ23ÐᨵÑ஺0⁚2⌱”I⊤”¡¢⊤Ḅᦪb23ᙠூÒᐭ௃⌱⚗ᓱḄூ⊤௃ᓫ:”ᦪbÇÈ⊤஻ᢥ>ᡭ5”ƨᦪbÇÈ⊤"J᪾஺0⁚3ᙠ”⌱$%Ó⊤ᡈ23"⚗Ḅ"⊤/23”᪾Ö×BTØ⌱$ḄᦪbÙ23஺(ᜐÁÂ⌱$³¢Úᦋ஺0⁚4ᢣQᦪbÇÈ⊤ÝÞḄ~ß⌱"§¡¢⊤"ᓫ:"PQ”ᢥ>஺0⁚5ExcelàḄᦪbÇÈ⊤áâᑮᢣQ~ßᙠU|Ö×"ᦪbÇÈ⊤äᑡ⊤”åæ஺0⁚6᪷b⚪E⌱$⌕áâᑮç⊤Ḅä஺"èé"êë"ç⊤½⌱"ᩩí"ᦟẆï"êë"ᑡ᪗ð"ᑡ⊤᪾"«¥"êë"Ñ᪗ð"ᑡ⊤᪾"I"êë"ᦪe”ᑡ⊤᪾ñf஺0⁚7ᓫ:ᦪbÇÈ⊤23ḄòEᓫᐗ`OᙠூᦪbÇÈ⊤¡ᐹ௃Ḅூ⌱⚗௃⌱⚗ᓱᓫ:”¡ᐹ”Ḅ"ᦪbÇÈô“ᢥ>ᡭ5"Òᐭô⊤”J᪾஺᪷b⚪E(ᜐᡃ+⌱$"õô"஺0⁚8ᓫ:"PQ"ᢥ>Oö÷ᦪbÇÈ¡¢⊤᪷b⚪EêøõôA12F24ᓫᐗᑁ23ᑁᓽS஺0⁚9Ï¡¢⊤-¤஺ù:ᦪbÇÈ⊤Ḅ¡¢⊤¤ú§©ᐭ”ᦪbÇÈô”᪵஺0⁚10V᪗U:⊤¤"ᦪbÇÈô”ᙠ?@ḄWᣩYᓫḄ”¡¢⊤᪗ðû⁐"ýὶYᓫ"ÿ
⁐"⌱"⁐"஺5.ூ⚪⁚௃⁚ᓫ""ᢥ”.xlsx”ᦻ஺1.ூ⚪⁚௃⁚1☢ᡃ"ᢥ᯿$ᩞ"&'()*⊤,.docx"ᡠ./01ᐭ34ᦪ6஺

24⁚2ᯠ9ᡃ"ᙠ"ᨴ"ᑡ=>ᐙḄA1ᐭ"B"஺CD᪗ᐝ᪗GHA2ᓫᐗ,JKLḄ>ᐙMᜐOPD᪗QᡂS⁐ᓝUVW9XYZGOᔣK>ᐙ\]A6ᓫᐗ,ᜐ஺⁚3:,C⊤ᦪ^,A_`ᦪ^2abᦪ஺cᜐᡃ"⌱E3ᓫᐗ,OJD᪗OᙠdeḄḄfᣩhᓫ⌱"_iᓫᐗ,,A”஺⁚4ᙠdeḄ“_iᓫᐗ,,A”kl᪾ᑗᣚ]"ᦪU”⌱⚗ᓱ஺ᙠ"ᑖs"ᑡ⊤᪾⌱"ᦪ^"OᙠJtḄ"bᦪaᦪ”uv᪾⌱"2"஺⁚5:ᓫ"wx"ᢥ9ᓽz{|_i஺⁚6ᢥ᯿}᪵ḄAᑖ`ᐸᦪ^Ḅ,A_`ᦪ^2abᦪ஺2.ூ⚪⁚௃⁚1᪷6⚪OᙠH3ᓫᐗ,1ᐭḄA"=H2+E3-F3",ᢥ"Enter"ᓽzeḄ஺⁚2ᐸḄᵨ>ᐙAḄA஺⌱H3ᓫᐗ,OCD᪗ᐝ᪗GHH3ᓫᐗ,JKLḄ>ᐙMᜐOPD᪗QᡂS⁐ᓝUVW9XYZGOᔣK>ᐙ\]H6ᓫᐗ,ᜐ஺3.ூ⚪⁚௃⁚1⌱x"ᔣ”ᑡḄG2:G6Oᙠூᦪ6௃⌱⚗ᓱKḄூᦪ6ᐹ௃Oᓫ"ᦪ6ᨵᦔឋ”ᢥOᡭ”ᦪ6ᨵᦔឋ”kl᪾஺⁚2ᑗᣚ]"_i”⌱⚗ᓱOᙠ"ᐕ¡”K¢ᑡ⊤᪾⌱"£ᑡ"¤ᙠ"ᩭ¦”ᦻ᪾1ᐭ"§O¨O©”ª«⌕ᵨᦻ1ᐭW᝱KḄ⌹°ᑖ◞²O⌱"³ᶍµ^"¶"·¸K¢hᓫ”¹º»⌱᪾஺⁚3¼ᑗᣚ]"1ᐭ½¾”⌱⚗ᓱO¿⌱”⌱xᓫᐗ,À.1ᐭ½¾”»⌱᪾Oᙠ“1ᐭ½¾”ᦻ᪾1ᐭ”ÁᙠÂÃ⌱”஺

25⁚4ᓫ஻wx”ᢥ9ᓽzᙠ"ᔣ”ᑡÅᑮÇ▭ᦔ஺⁚5᪷6⚪OÉÊIFËᦪ1ᐭ"ᔣ”ᑡᑁÍ஺ᙠ"G2"ᓫᐗ,1ᐭ”=IF(H2=0,"©",IF(H2>0,"§"O"¨ᯠ9ᢥ"Enter”஺⁚6ᢥ᯿}᪵ḄAÉÊIFËᦪᔣᔣᑡḄᐸᓫᐗ,ᑁ1ᐭᑁÍ஺4.ூ⚪⁚௃⁚1⌱AlH1ᓫᐗ,Oᙠூ4௃hᓫKḄூkÎA௃ᓫ"Ï"ᢥOᓽzCÐ'Ḅᔜº᪗⚪ÏÀ.஺⁚2⌱ᦪ6Oᙠூ4௃hᓫKḄூ᪵A௃ᓫ”ᝅᵨ⊤,,A"ᢥOᙠdeḄK¢ᑡ⊤⌱ÓᝅᵨḄ,A஺cᜐOᡃ"⌱"᫏ÕÖ”Ḅ஻⊤᪵A᫏ÕÖ2஻஺⁚3ᓫD᪗⌱9de"ᝅᵨ⊤,A”kl᪾Oᙠckl᪾¿⌱”⊤ᒹØ᪗⚪”»⌱᪾஺⁚4ᓫ"wx"ᢥ9ᓽz`ᦪ6ᑡ⊤ᝅᵨ⊤,᪵A஺⁚5⌱⊤,Oᙠூ⊤,ᐹ௃Ḅூ_௃⌱⚗ᓱKOᓫூᐹ௃Ḅ"Ùᣚ`”ᢥ஺⁚6ᓫ”Ú஻ᢥᓽzC⊤,Ùᣚ`ÛÉ஺5.ூ⚪⁚௃⁚1⌱ᦪ6Oᙠூᦪ6௃⌱⚗ᓱKḄூᑖÜÀ.௃Oᓫ"ᑖsÝÞ"ᢥ஺⁚2de"ᑖsÝÞ”kl᪾Oᙠ"ᑖsUß”K¢ᑡ⊤⌱"à"Oᙠ"ÝÞA"⌱"ᶔ,ᙠ”⌱xÝÞ⚗"¿⌱"§"¶"¨»⌱᪾”஺⁚3:ᓫ"wx"ᢥ9ᓽzÅᑮÇ▭ÝÞᦔ஺6.ூ⚪⁚௃

26⁚ᓫãäḄூᦻ௃ᢥOᙠᡭḄ9åæçᓫ"è`”ᢥOᙠé9deḄ"è`"kl᪾=ᦻê"&'ëàì*.xlsx”í'஺bîÚïðñḄ├óôᕒOö÷øsçðḄ├óùúOûᢥᨴüýþᑖ᪆
஺20231ᨴ᝛◤⌕202312ᨴḄ├:᪷Ḅ“Excel,xlsx”ᦻ᝛!ᑡ#$%1.&"Excel,xlsx”᝞!()%"├+,”⊤/Ḅ0ᓫ2”ᑡᦪ4Ḅ56(789:ᵨஹ=>2?@ᦪ஺2.&ᦪ⊤"├+,”〉BḄ56ᓄD$᝞!%ᔠFALE1ᓫᐗ57᪗⚪J"12ᨴ9KLMN├O+⊤”()〉BḄ&PQ6ஹRSஹRTUVW⁐Y7ᦪZ[()\᪾^_U`#$⊤abcde஺3.#$⊤"├f”/ḄZ[B3:D16ghJi7“├fklஹᙠ"├+,"⊤/Ḅ"├f”ᑡnopqrᑡ஻├t"᪷”├t=├fXᓫ2”᪀wx69Kyᔜ{MNḄ├t஺|gᙠx6/}~VL00KUPᦪᙠ#$⊤"├f”/ᐵᖪḄᐹS├f஺Fᙠx6/ᵨᡠghḄJi"├fkl”஺4.7“├+,”#$⊤wrᦪ⊤ᙠrJ7“ᦪᑖ᪆”ḄḄ#$⊤/஺5.7ᦪ⊤ᦪwr{7MḄᦪM()ᦪ᪗ᙠ᜜oM⊤Ḅ᪗⚪ᦋ7"12ᨴ9KLMN├f”஺6.#$⊤>7”9KL{MN12ᨴ├+,.xlsx”ᦻ஺1.ூ⚪⁚௃⁚1%⊤/ᦪ456(789:ᵨF=>2?@ᦪ஺¡ᜐᡃ¤⌱¦C4ᓫᐗ5n§¨᪗ᙠ©yḄḄªᣩ¬ᓫ/⌱¦"()ᓫᐗ556”®஺⁚2%ᙠ©yḄ”()ᓫᐗ556”&¯᪾/ᑗᣚ²"ᦪR”⌱⚗ᓱ஺ᙠ”ᑖ{஻/⌱¦"89:ᵨ”®ᙠn

27oḄ“@ᦪ?ᦪ”¶·᪾/⌱¦"2"஺⁚3%ᓫ§஻¸g”ᢥº»ᓽ½()஺⁚4%ᢥ᯿¿᪵ḄQ6ᑖÁ7ᐸÃᦪ4Ḅ56(789:ᵨF=>2?@ᦪ஺2.ூ⚪⁚௃⁚1%ᙠ"├+,"⊤/⌱/Al%E1ᓫᐗ5n§¨᪗ᙠ©yḄªᣩ¬ᓫ/⌱¦”()ᓫᐗ556”®©y”()ᓫᐗ556”&¯᪾஺ᙠ"&P”⌱⚗ᓱ!Ḅ“ᦻÄÅᑴI”Ç/È⌱”ᔠFᓫᐗ5”É⌱᪾%ᙠ“ᦻÄ&PQ6"ÇḄ"ÊË&P”!Ìᑡ⊤/⌱¦"Í/”®஺λᓫ§"¸g”ᓽ½஺⁚2%ᢥ᯿¿᪵ḄQ6ᡭД()ᓫᐗ556”&¯᪾ᑗᣚ²"RS"⌱⚗ᓱᙠ"RS”!Ìᑡ⊤/⌱¦rÑᔠ〉ḄRS¡ᜐᡃ¤⌱¦"ÒS"®஺ᙠ"RT”!Ìᑡ⊤/⌱¦rÑᔠ〉ḄRT¡ᜐᡃ¤⌱¦"14”®஺ᙠ"W⁐”!Ìᑡ⊤/⌱¦ᔠ〉ḄW⁐¡ᜐᡃ¤⌱¦"Ó⁐”®ᓫ§"¸g"ᢥº»ᓽ½ÔᑮÖ▭ᦔ
஺⁚3%⌱/ᦪZ[n§¨᪗ᙠ©yḄªᣩ¬ᓫ/⌱¦''()ᓫᐗ556”®஺⁚4%ᙠᡭÐḄ஻()ᓫᐗ556”&¯᪾/ᑗᣚ²"\᪾”⌱⚗ᓱᙠ"⚜Û"Ç/ᓫ§"᜜\᪾"ᢥº»ᓽ½ᙠ"\᪾”Ç/⚜Üᦔ
஺⁚5%Ýᑗᣚ²"Þᐙ"⌱⚗ᓱ!ᙠ஻àá⁐”Ç/⌱¦rÑᔠ〉ḄÞᐙW⁐஺⁚6%ᓫ§஻¸g”ᢥº»ᓽ½ᙠ#$⊤/ÔᑮÖ▭ᦔ
஺3.ூ⚪⁚௃⁚1%ᙠ"├f஻#$⊤/⌱/B3:D16Z[n§¨᪗ᙠ©yḄªᣩ¬ᓫ/⌱¦"ghJi”®ᡭÐ஻wJi”&¯᪾஺ᙠ஻Ji“/âᐭ"├fkl”»ᓫ§¸gᓽ½஺⁚2%ᙠ"├+,"⊤/⌱/E3ᓫᐗ5âᐭ”├t"஺⁚3%ᙠD4ᓫᐗ5/âᐭ”=VLOOKUPA4,├fkl3,FALSE
”,ᯠ»ᢥ"Enter”åæçᓽ½è"├f”#$⊤/éḄ├fᦪᐭᑮ“├+,”#$⊤/஺⁚4%êD4n!ëḄÞᐙìí²ᨬ!rᦪᜐ├fᦪḄÞᐙ஺

28⁚5%᪷├fUVᓫ29K├t஺ᙠE4ᓫᐗ5/âᐭ஻=C4*D4”,ᓽ½öy
஺⁚6%êE4n!ëḄÞᐙìí²ᨬ!rᦪᜐ├tḄÞᐙ஺4.ூ⚪⁚௃⁚1%ᙠwᦪ⊤ùú⌕=ûᦪZ[üý⌕ᨵᑡ᪗⚪Fÿ
ᨵ஺⁚2⌱஻├”⊤Ḅᦪ
ᙠூᐭ௃⌱⚗ᓱ"Ḅூ⊤#௃$ᓫ&”ᦪ'(⊤”ᢥ*ᡭ,”-.ᦪ'(⊤"01᪾஺⁚3ᙠ”⌱456⊤ᡈ
"⚗"Ḅ"⊤/
”᪾9:;<=⌱4Ḅᦪ>
஺?ᜐ0AB⌱4CDᦋ஺⁚4ᢣHᦪ'(⊤IJḄKL⌱"M⊤"ᓫ&"NH"ᢥ*ᓽP஺⁚5ExcelXYḄᦪ'(⊤Z[ᑮᢣHKL]ᙠ^_9:"ᦪ'(⊤`aᑡ⊤”cd஺e&"Sheet1”,klmn”ᦪ'(ᑖ᪆”஺5.ூr⚪⁚௃⁚1᪷⚪uᙠ-.ᦪ'(vw<ᐜ⌱4⌕Z[ᑮz⊤Ḅ`a஺AB{|"}ᦪ~`aYXZ[ᑮ“᪗"
ᦪ~`aXZ[ᑮ“ᦪ~"
஺?ᜐᡃᙠ`aᑡ⊤ᓫ&⌱"m""├”6`a'(⊤
Y├ᔠ~஺⁚2ᓫ&ᦪ'(⊤
Ḅuᓫᐗ#ᙠ"ᦪ'(⊤ᐹ஻Ḅ”⌱⚗஻⌱⚗ᓱ"ᓫ&஻ᐹ”$Ḅ”ᦪ'(v"ᢥ*ᡭ,"ᐭv⊤”01᪾஺᪷⚪u?ᜐᡃ⌱4"v”l஺⁚3:ᓫ&"NH”ᢥ*ᓽPᑮ▭ᦔ஺⁚4⌱ᦪ'(vᙠூᦪ'(vᐹ௃Ḅூ௃⌱⚗ᓱ"ᓫ&ூ᪗௃$Ḅ"ᦪ᪗஻"ᢥ*ᙠ¡Ḅ"ᑡ⊤⌱4"ᦪ᪗᜜“l஺⁚5ᢥ᯿⚪u¤ᦋv⊤Ḅ᪗⚪஺5¥☢⌱v⊤Ḅ᪗⚪஺⁚6¨ᐭMḄ᪗⚪m.12ᨴª«¬v├”஺6.ூr⚪⁚௃⁚ᨬᓫ&ூᦻ°௃⌱⚗ᓱ"Ḅ"±In”ᢥ*Yᦻ°²I”«¬³v12ᨴª├{|.xlsx”ᦻ

29°஺µ¶ᙠ·ᙠ¸Ḅ¹▾»☢¼½¹¾¿;À▾ÁḄ½ᳮ5¿ÃÄk⌕ÅÆ0ᔜÈᦻᫀᡈὅᦪḄ᦮ᳮ஺ÌᙠÍÎϫйÑÒḄÓÔὃÖḄ×ØᡂÚ◤⌕ᐭᦻ°mn”ὃÜᡂÚᓫ.xlsx”ḄExcelↈᦻ᫏ß஺à᪷"ᑡáHâ½µ¶0ᡂÚᓫãᑖ᪆᦮ᳮ1.äᵨ"ᩩç#è”éêã"ᑡëìYᜧ¹ᱥᳮᜧ¹ïðÐñò80ᑖḄᡂÚᡠᙠḄᓫᐗ#ö5È÷⁐ùᐙᐸüýÐᜧòᡈþò95ᑖḄᡂ•⁐᪗ᡠᵨ⁐ᢱᦪ஺2.⊤"ὃ!ᡂᓫ.xlsx”'Ḅᦪᑡ⊤)*᝞,-.ᓄ01234ᑡ"56"78ᦻ:78ᡂᑡ;<=>?ᦪḄᦪ@஺ᦋBᦪᑡ⊤'Ḅ*CஹᑡEᦋBFGஹF678H᪾JKLஹ78MN.஺3.PᵨsumJaverageXᦪYZ[4\5!Ḅ]ᑖ^_ᙳᡂ஺4.bᑴ⊤”ὃ!ᡂᓫ.xlsx”,2e:fghi⊤jkl⊤mlno"ᡂᓫᑖpq]”஺5.rstpq]uvw[\xᔜzḄ_ᙳᡂ{2[|}~ᑖ⚓஺6.4\[\xᔜz_ᙳᡂ)*஺1.ூ⚪⁚௃⁚11⌱'F21G14ᓫᐗ-ᓫூ௃⌱⚗ᓱ,ூ᪵.௃|'Ḅ“ᩩ¡-."ᢥ£ᙠ¥Ḅ,¦ᑡ⊤'⌱§”¨ᓫᐗ-©ᑣ”'Ḅ"ᐸ¬©ᑣ”n¥"l-.©ᑣ”®᪾ᙠ”¯°©ᑣ±²”⌱⚗,78ᓫᐗ-@?h80஺ᯠkᓫ“-."ᢥ£¥஻78ᓫᐗ--.஻®᪾ᙠ“·ᐙ஻⌱⚗ᓱ,⌱§"¹⁐"ᓫ"º»”ᢥ£஺⁚2178¼½k¾¿⊤À☢஺⁚31ᐜ⌱'D21E14ᓫᐗ-ᯠkᢥÅ"Ctrl"ÈÉ⌱'H21J14ᓫᐗ-ᢥ᯿ÍÎÏ᪵NÐÑ

30ᓫᐗ-@ᜧhᡈÔh95ḄFG⁐78Õ⁐஺2.ூ⚪⁚௃⁚11⌱'"56"ᡠᙠḄᑡÖ×᪗ᙠ¥ḄØᣩÚᓫ'⌱§”78ᓫᐗ--.”nᙠ¥Ḅ"78ᓫᐗ--."®᪾ᑗᣚÝ"ᦪF”⌱⚗ᓱᙠ"ᑖp”ᑡ⊤᪾'⌱§"ᦻ:"n஺⁚21⌱'ᡠᨵᡂᑡÖ×᪗ᙠ¥ḄØᣩÚᓫ'⌱§”78ᓫᐗ--.”nᙠ¥ḄḄ”78ᓫᐗ--.”®᪾ᑗᣚÝ"ᦪF”⌱⚗ᓱᙠ"ᑖp”ᑡ⊤᪾'⌱§"ᦪ@”nᙠ?ᦪ>ᦪßà᪾'78?ᦪ>ᦪ"2"஺⁚31⌱'ᦪᓫூ௃⌱⚗ᓱ,ூᓫᐗ-௃|'Ḅ"-.”,¦ᢥ£ᙠ¥ḄØᣩÚᓫ'⌱§"*C”n¥"*C”®᪾78*C16஺⁚41ᓫூ௃⌱⚗ᓱ,ூᓫᐗ-௃|'Ḅ"-.",¦ᢥ£ᙠ¥Ḅ,¦ᑡ⊤'⌱§"ᑡE"n¥"ᑡE”®᪾78ᑡE"11"஺⁚51Ö×᪗ᙠ¥ḄØᣩÚᓫ'⌱§”78ᓫᐗ--.”nᙠ¥Ḅ"78ᓫᐗ--.”®᪾'Ḅ"FG”⌱⚗ᓱ,78FG"áG"F610஺É⌱'34*Ḅᓫᐗ-ᢥ᯿Ï᪵ḄN.78Fâã஺⁚61äå⌱'ᦪᢥ᯿ÍÎÏ᪵ḄN.ᡭ”78ᓫᐗ--."®᪾ᙠ”78ᓫᐗ--.”®᪾'Ḅ"M”⌱⚗ᓱ,78“ç_M"è"ᚖêM"Ḇ"ì'"஺⁚71ᑗᣚÝ"H᪾"⌱⚗ᓱᙠ"⚜g''|'⌱§஻᜜H᪾"J"ᑁñ”n஺⁚81ÉᑗᣚÝ"·ᐙ"⌱⚗ᓱ,ᙠ"òó⁐"|'⌱§"ôõ"n஺

31⁚91ᨬkᓫ"º»”ᢥ£஺3.ூ⚪⁚௃⁚11ᙠK2ᓫᐗ-'÷ᐭ”=SUM(D2:J2)",ᢥ"Enter”Èkùᓫᐗ-@"629.50",úûK2Ö,üḄ·ᐙýêÝᨬ,4*ᦪᜐ¼½]ᑖḄ·ᐙ஺⁚21ᙠL2ᓫᐗ-'÷ᐭ”=AVERAGE(D2:J2)",ᢥ"Enter”Èkùᓫᐗ-@"89.93",úûL2Ö,üḄ·ᐙýêÝᨬ,4*ᦪᜐ¼½_ᙳᑖḄ·ᐙ஺4.ூ⚪⁚௃⁚11bᑴ⊤”5!ᡂᓫ"ÿᑮ"Sheet2”⊤஺ᙠ"ᡂ"᪗ᙠḄḄᣩᓫ⌱"ᡈᑴ”"#஺ᯠ%ᙠḄ”ᡈᑴ⊤”&'᪾Ḅ”)ᑡ⌱+⊤,-"⌱"Sheet2”,./⌱"0123"⌱᪾஺4⁚2672⊤89":஺;”ᡂ(2)”ᕈ>?@A᝱ᯠ%Cᐭ”ᡂᓫᑖFGH”I᪵ᓽ>஺5.ூO⚪4⁚௃4⁚16&RSᢥᓣVWX᣸V⌱C26C14Z[ᑡ⊤ᓫூᦪ]௃⌱⚗ᓱ)ூ᣸V`a⌱௃bḄ"ᓣV”ᢥc“᣸Ve⏨”&'᪾g”᡽i⌱+Z[”ᓫ⌱ᢥc஺ᯠ%ᓫ஻᣸V”ᢥc஺4⁚26⌱C15,ᓫூᦪ]௃⌱⚗ᓱ)ூᑖSkl௃bḄ"ᑖFGH"ᢥc"ᑖFGH”&'᪾g"ᑖFIm”bḄ)nᢥc⌱"RS""#ᓫ"GHop”bḄ)nᢥc⌱"qᙳs"ᙠ"⌱+GH⚗"b/⌱"tuvᦪᦪwᑖ᪆"ஹ"ᜧw{|஻ஹ"ᜧwᱥᳮ"ஹ"VBV"ஹ"C|V”ஹ"Matlab”⌱᪾./⌱"bᦪ]ᑖ⚓஻⌱᪾஺4⁚36ᓫ஻+”ᢥc஺6.ூO⚪4⁚௃

324⁚1:⌱RᔜqᙳᡂᡠᙠḄᓫᐗᓫூᐭ௃⌱⚗ᓱ)ூ⊤௃b"'')nᢥcᙠḄ)nᑡ⊤⌱"A""#஺4⁚2⊤ZᙠḄᣩᓫ⌱"⌱ᦪ]""#”⌱ᦪ]”&'᪾஺o☢⌱”⚗ᑡ"⌱⚗Ḅ"ᑡ1”,%ᓫ“⚗ᑡ"⌱⚗Ḅ“?@"ᢥc”?@ᦪ]ᑡ஻&'᪾ᙠ"ᑡ:"Cᐭ“1"஺4⁚3ᓫ"+”ᢥc%ᓽ>|>஻⌱ᦪ]”&'᪾஺4⁚4ᢥ᯿᪵o?@“ᑡ2”ஹ஻ᑡ3"7"2"ஹ"3"஺4⁚5:ᢥ᯿᪵Ḅopᡭ¡"⌱ᦪ]”&'᪾⌱”¢qᑖF£᪗¤")Ḅ"1",ᓫ"?@”ᢥc,"£᪗¤”&'᪾ᙠ"£᪗¤Z[")Cᐭ"tuvᦪᦪwᑖ᪆ᜧw{|ᜧwᱥᳮVBV,C|VMatlab"4⁚6ᓫ"+”ᢥc%¦”⌱ᦪ]”&'᪾஺4⁚7ᓫ"+”ᢥc%¦⊤ḄA஺