{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Arial;}}{\colortbl\red0\green0\blue0;\red255\green255\blue255;\red0\green0\blue255;\red128\green128\blue128;}{\stylesheet {\style\s0 \ql\fi0\li0\ri0\f1\fs24\cf0 Normal;}{\style\s3 \ql\fi0\li0\ri0\f1\fs26\b\cf0 heading 3;}{\style\s2 \ql\fi0\li0\ri0\f1\fs28\b\i\cf0 heading 2;}{\style\s1 \ql\fi0\li0\ri0\f1\fs32\b\cf0 heading 1;}}{\*\listtable}{\*\listoverridetable}{\*\generator iText 2.1.5 (by lowagie.com)}{\info}\paperw11907\paperh16840\margl720\margr720\margt720\margb720{\footer \pard\plain\s0\qc\fi0\li0\ri0\sl320\plain\f0\fs18 \u31532?\f0{\field{\*\fldinst PAGE}{\fldrslt  }}\f0\fs18 \u-26507?\par}{\header \pard\plain\s0\qr\fi0\li0\ri0\sl320\plain\f0\fs18 \u21517?\u24072?\u-29774?\u25480?\u183?\u20248?\u-29400?\u-29698?\u31243?\u8212?\u8212?\u21517?\u-29698?\u22530?\par}\pgwsxn11907\pghsxn16840\marglsxn720\margrsxn720\margtsxn720\margbsxn720\pard\plain\s0\qc\fi0\li0\ri0\sa140\plain\f0\fs36\b \u20107?\u21322?\u21151?\u20493?\u-244?\u32463?\u20856?\u-29406?\u21153?\u31649?\u29702?\u22330?\u26223?\u20013?\u30340?Excel\u27169?\u26495?\u19982?\u24212?\u29992?\u25216?\u24039?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b MKT012774\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u21517?\u31216?\u12305?\u-230?\f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk/012774.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u20107?\u21322?\u21151?\u20493?\u-244?\u32463?\u20856?\u-29406?\u21153?\u31649?\u29702?\u22330?\u26223?\u20013?\u30340?Excel\u27169?\u26495?\u19982?\u24212?\u29992?\u25216?\u24039?\ul0 }}\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u25152?\u23646?\u31867?\u21035?\u12305?\u-230?\u-29406?\u21153?\u31649?\u29702?\u22521?\u-29779?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u24320?\u-29698?\u26102?\u-27148?\u12305?\u-230?2025\u24180?06\u26376?21\u26085? \u21040? 2025\u24180?06\u26376?21\u26085? \u26080?\u-27359? 2800\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?12\u26376?05\u26085? \u21040? 2024\u24180?12\u26376?05\u26085? \u19978?\u28023? 2800\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?07\u26376?06\u26085? \u21040? 2024\u24180?07\u26376?06\u26085? \u26080?\u-27359? 2800\u20803?/\u20301?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u-29708?\u26126?\u12305?\u-230?\u26412?\u22521?\u-29779?\u-29698?\u31243?\u20840?\u24180?\u24490?\u29615?\u24320?\u-29698?\u-244?\u22914?\u26377?\u-26880?\u27714?\u-244?\u27426?\u-28722?\u26469?\u30005?\u21672?\u-29726?\u-255?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u20854?\u20182?\u24320?\u-29698?\u22478?\u24066?\u12305?\u-230?\f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk7/048176.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u19978?\u28023?\ul0 }}\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk/012774.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u26080?\u-27359?\ul0 }}\f0\fs22  \par\pard\plain\s0\fi0\li0\ri0\sl300\plain\f0\fs22 \u12304?\u-29698?\u31243?\u20851?\u-27346?\u23383?\u12305?\u-230?Excel\u27169?\u26495?\u22521?\u-29779?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u25253?\u21517?\b0\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u20540?\u29677?\u25163?\u26426?\u-230?18971071887    \u-28498?\u31665?\u-230?Service@mingketang.com\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 Excel\u20316?\u20026?\u21151?\u-32515?\u24378?\u22823?\u30340?\u25968?\u25454?\u22788?\u29702?\u24037?\u20855?\u-244?\u-32515?\u22815?\u20026?\u24191?\u22823?\u-29406?\u21153?\u20154?\u21592?\u-30237?\u20915?\u26085?\u24120?\u25968?\u25454?\u22788?\u29702?\u25552?\u20379?\u26497?\u22823?\u30340?\u24110?\u21161?\u12290?\u29087?\u32451?\u25484?\u25569?\u-28720?\u29992?Excel\u20998?\u26512?\u21644?\u22788?\u29702?\u25968?\u25454?\u30340?\u26041?\u27861?\u-244?\u26377?\u21161?\u20110?\u-29406?\u21153?\u20154?\u21592?\u25552?\u-25896?\u26085?\u24120?\u24037?\u20316?\u25928?\u29575?\u12289?\u-27059?\u20302?\u25968?\u25454?\u22788?\u29702?\u-27367?\u-29713?\u29575?\u-244?\u20107?\u21322?\u21151?\u20493?\u22320?\u-30237?\u20915?\u21508?\u31181?\u23454?\u-27067?\u24037?\u20316?\u-27154?\u-26472?\u-244?\u20174?\u-32756?\u24110?\u21161?\u-29406?\u21153?\u20154?\u21592?\u20174?\u32321?\u-28211?\u30340?\u26085?\u24120?\u24037?\u20316?\u20013?\u-30237?\u-32463?\u20986?\u26469?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u28982?\u-32756?\u-244?\u20070?\u21040?\u29992?\u26102?\u26041?\u24680?\u23569?\u-244?\u-29406?\u21153?\u22312?\u30495?\u27491?\u24212?\u29992?Excel\u26102?\u25165?\u21457?\u29616?\u-230?\u-32278?\u24049?\u30340?\u25163?\u-28641?\u-29217?\u19981?\u19978?\u-32495?\u-28641?\u-244?\u-32495?\u-28641?\u21448?\u-29217?\u19981?\u19978?\u-26490?\u23548?\u32473?\u20320?\u21457?\u-29406?\u21153?\u-30616?\u30340?\u-28641?\u24230?\u-244?\u21508?\u31181?\u25968?\u25454?\u22788?\u29702?\u-29783?\u-32278?\u24049?\u-27017?\u20837?\u22256?\u22659?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26412?\u-29698?\u31243?\u23558?\u32467?\u21512?\u22823?\u-28209?\u30340?\u23454?\u20363?\u-244?\u31995?\u32479?\u-29722?\u23454?\u22320?\u20171?\u32461?\u20197?Excel\u20026?\u24037?\u20855?\u-25896?\u25928?\u22320?\u31649?\u29702?\u-29406?\u21153?\u25968?\u25454?\u20197?\u21450?\u-28720?\u29992?\u22270?\u-30616?\u24037?\u20855?\u23545?\u-29406?\u21153?\u25968?\u25454?\u-28709?\u-30644?\u20998?\u26512?\u30340?\u26041?\u27861?\u21644?\u25216?\u24039?\u12290?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u25910?\u30410?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - 10\u20010?+\u-29406?\u21153?\u25968?\u25454?\u20998?\u26512?\u27169?\u26495?\u-244?\u21270?\u32321?\u20026?\u31616?\u25552?\u-25896?\u24037?\u20316?\u25928?\u29575?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - 25\u24180?+\u26631?\u26438?\u20225?\u19994?\u23454?\u-29195?\u32463?\u-25972?\u20998?\u20139?\u-244?\u20102?\u-30237?\u31649?\u29702?\u23618?\u24819?\u-30335?\u30340?\u-29406?\u21153?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u22823?\u-28209?\u25311?\u30495?\u26696?\u20363?\u28436?\u32451?\u-244?\u24555?\u-28641?\u25351?\u23548?\u20225?\u19994?\u20855?\u20307?\u23454?\u-29195?\u26041?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u25484?\u25569?\u21160?\u24577?\u20998?\u26512?\u27169?\u22411?\u30340?\u24314?\u31435?\u-28613?\u-28783?\u-244?\u23398?\u20064?\u24314?\u27169?\u24605?\u-29201?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u22823?\u32434?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8:30 \u31614?\u21040?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9:00 \u-29698?\u31243?\u24320?\u22987?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u27169?\u22359?\u19968? \u22522?\u30784?\u30693?\u-29754?\u20063?\u31934?\u24425?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22522?\u30784?\u30693?\u-29754?\u21253?\u25324?\u-32278?\u23450?\u20041?\u26684?\u24335?\u-29762?\u32622?\u12289?\u25490?\u24207?\u12289?\u31579?\u-28663?\u12289?\u20998?\u21015?\u12289?\u23450?\u20301?\u12289?\u26465?\u20214?\u26684?\u24335?\u20197?\u21450?\u26597?\u25214?\u26367?\u25442?\u31561?\u25805?\u20316?\u12290?\u26412?\u27169?\u22359?\u23558?\u22312?\u21333?\u20010?\u25805?\u20316?\u30340?\u22522?\u30784?\u19978?\u-28211?\u28857?\u-29774?\u-30237?\u21508?\u31181?\u32452?\u21512?\u19979?\u30340?\u23454?\u25112?\u20316?\u29992?\u-244?\u-29783?\u23398?\u21592?\u-32717?\u30446?\u19968?\u26032?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u21333?\u20803?\u26684?\u26684?\u24335?\u-26993?\u24515?\u25152?\u27442?\u30340?\u-32278?\u23450?\u20041?\u-30616?\u22836?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u-32278?\u23450?\u20041?\u21333?\u20803?\u26684?\u26684?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u20248?\u21270?\u25253?\u-27392?\u26680?\u31639?\u26041?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u26465?\u20214?\u26684?\u24335?\u-244?\u20445?\u25252?\u24037?\u20316?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u25968?\u25454?\u26377?\u25928?\u24615?\u20043?\u24110?\u20320?\u21046?\u20316?\u19968?\u20010?\u-30268?\u-31997?\u30340?\u27169?\u26495?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u25968?\u25454?\u-25972?\u-29759?\u12289?\u25968?\u25454?\u26377?\u25928?\u24615?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u12289?\u22522?\u30784?\u24212?\u29992?\u20043?\u20998?\u21015?\u21151?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u20998?\u21015?\u21151?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u12289?\u26597?\u25214?\u26367?\u25442?\u30340?\u22937?\u29992?\u25209?\u-28209?\u26367?\u25442?\u25351?\u23450?\u20869?\u23481?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u26597?\u25214?\u26367?\u25442?\u12289?\u24555?\u25463?\u-27346?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6\u12289?\u23450?\u20301?\u21151?\u-32515?\u20043?\u-30268?\u-31997?\u23548?\u20986?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u23450?\u20301?\u21151?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7\u12289?\u25490?\u24207?\u21151?\u-32515?\u20043?\u25913?\u21464?\u25968?\u25454?\u30340?\u25490?\u21015?\u-26502?\u24207?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u25490?\u24207?\u21151?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u27169?\u22359?\u20108?\u-230?\u26696?\u20363?\u21078?\u26512?\u-244?\u19981?\u21516?\u24212?\u29992?\u22330?\u26223?\u20013?\u30340?\u25968?\u25454?\u22788?\u29702?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26412?\u27169?\u22359?\u20013?\u30340?\u26696?\u20363?\u22343?\u26469?\u28304?\u20110?\u23454?\u25112?\u-244?\u20854?\u20013?\u21253?\u25324?\u24120?\u-30271?\u30340?\u20998?\u31867?\u27719?\u24635?\u12289?\u22810?\u-30616?\u25968?\u25454?\u22788?\u29702?\u12289?\u25171?\u21360?\u23545?\u-29402?\u21333?\u12289?\u25215?\u20817?\u27719?\u31080?\u25552?\u31034?\u31561?\u32463?\u20856?\u26696?\u20363?\u12290?\u27599?\u20010?\u26696?\u20363?\u20026?\u19968?\u20010?\u20999?\u20837?\u28857?\u-244?\u22312?\u-29774?\u-30237?\u20013?\u25226?\u26696?\u20363?\u30340?\u-28670?\u29992?\u22330?\u26223?\u20570?\u22810?\u26041?\u20301?\u30340?\u25299?\u23637?\u-244?\u26368?\u32456?\u24418?\u25104?\u19968?\u20010?\u20010?\u23436?\u25972?\u30340?\u24212?\u29992?\u27169?\u26495?\u-244?\u20379?\u23398?\u21592?\u26085?\u24120?\u24037?\u20316?\u20013?\u30452?\u25509?\u24212?\u29992?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1. \u24039?\u29992?SUMPRODUCT\u20989?\u25968?\u-244?\u-28805?\u26494?\u21046?\u20316?\u20998?\u31867?\u27719?\u24635?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20142?\u28857?\u-230?\u29992?\u24214?\u19969?\u-30237?\u29275?\u24335?\u30340?\u26041?\u27861?\u-29774?\u-30237?\u20989?\u25968?\u30340?\u-28720?\u-30644?\u21407?\u29702?\u-244?\u-29783?\u20320?\u8220?\u30475?\u21040?\u8221?\u20989?\u25968?\u30340?\u-28720?\u-30644?\u-28729?\u31243?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?SUMPRODUCT\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2. \u-25986?\u-26003?\u22810?\u-30616?\u25968?\u25454?\u-244?\u20174?INDIRECT\u20989?\u25968?\u24320?\u22987?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20142?\u28857?\u-230?\u-28646?\u-28729?\u-29722?\u-30237?INDIRECT\u20989?\u25968?\u-244?\u20805?\u20998?\u29702?\u-30237?\u21644?\u25484?\u25569?\u-28711?\u20010?\u26126?\u26143?\u32423?\u20989?\u25968?\u30340?\u29992?\u27861?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?INDIRECT\u20989?\u25968?\u12289?LOOKUP\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3. \u20004?\u-30616?\u8220?\u30475?\u-28657?\u8221?\u-30268?\u21010?\u27714?\u-30237?\u22312?\u25104?\u26412?\u-29791?\u31639?\u20013?\u30340?\u24212?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u-30268?\u21010?\u27714?\u-30237?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4. \u-32278?\u21160?\u25171?\u21360?\u23545?\u-29402?\u21333?\u20043?\u31070?\u22855?\u30340?LOOKUP\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?LOOKUP\u20989?\u25968?\u12289?INDEX\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5. \u26412?\u-30616?\u26597?\u-29726?OR\u-29208?\u-30616?\u26597?\u-29726?\u-244?\u21453?\u21521?\u26631?\u-29776?\u24050?\u32463?\u26597?\u-29726?\u-28729?\u30340?\u-29776?\u24405?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?VLOOKUP\u12289?MATCH\u12289?COLUMN\u12289?IFERROR\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6. \u24039?\u29992?\u22270?\u29255?\u26041?\u24335?\u-244?\u-29783?IF\u23884?\u22871?\u24212?\u29992?\u20063?\u22914?\u27492?\u31616?\u21333?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20142?\u28857?\u-230?\u29992?\u22270?\u29255?\u26041?\u24335?\u24110?\u20320?\u29702?\u-30237?IF\u20989?\u25968?\u-32564?\u21518?\u30340?\u-28720?\u-30644?\u-28729?\u31243?\u-244?\u24443?\u24213?\u25484?\u25569?\u20989?\u25968?\u30340?\u31934?\u-25901?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?IF\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7. \u31070?\u22855?\u30340?\u-32278?\u21160?\u20998?\u31867?\u27714?\u21644?\u20043?\u-32278?\u21160?\u20462?\u-29790?\u21512?\u-29791?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?SUM\u20989?\u25968?\u12289?IF\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8. EXCEL\u24517?\u22791?\u25216?\u-32515?-\u22788?\u29702?\u19981?\u-30268?\u-31997?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u23450?\u20301?\u12289?\u25490?\u24207?\u31561?\u22522?\u30784?\u25805?\u20316?\u30340?\u32452?\u21512?\u24212?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9. \u25578?\u20986?\u-28817?\u20214?\u23548?\u20986?\u25968?\u25454?\u26080?\u27861?\u-29791?\u31639?\u30340?\u20803?\u20982?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u22522?\u30784?\u25805?\u20316?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 10. \u19968?\u20010?\u-25896?\u22823?\u19978?\u30340?\u25253?\u-30616?\u27719?\u24635?\u26696?\u20363?-\u26234?\u-32515?\u-26938?\u22242?\u21033?\u28070?\u-30616?\u24180?\u32456?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?INDIRECT\u20989?\u25968?\u12289?HLOOKUP\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 11. \u19968?\u27454?\u24039?\u22937?\u30340?\u-28709?\u-27392?\u23384?\u31616?\u26131?\u26680?\u31639?\u-30616?\u26684?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20142?\u28857?\u-230?\u31649?\u29702?\u25968?\u25454?\u30340?\u26041?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 12. \u-26946?\u20197?\u24179?\u-30623?\u30340?\u20379?\u-29401?\u21830?\u-29401?\u27454?\u20998?\u-28339?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?IF\u20989?\u25968?\u12289?AND\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 13. \u21033?\u29992?\u20989?\u25968?\u-29762?\u32622?\u25215?\u20817?\u27719?\u31080?\u21040?\u26399?\u25552?\u31034?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?IF\u20989?\u25968?\u12289?AND\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 14. \u26576?\u-26938?\u22242?\u27773?\u-28826?\u27833?\u-32745?\u24341?\u21457?\u30340?\u31649?\u29702?\u24605?\u-32765?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?SUMPRODUCT\u12289?COUNTIF\u20989?\u25968?\u12289?\u21160?\u24577?\u22270?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 15. \u-28805?\u26494?\u19978?\u25163?\u21160?\u24577?\u22270?\u-30616?\u-244?\u-30237?\u20915?\u22823?\u25209?\u-28209?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u21160?\u24577?\u22270?\u-30616?\u12289?\u26609?\u24418?\u22270?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 16. \u-26503?\u30446?\u-28709?\u24230?\u31649?\u29702?\u31034?\u24847?\u22270?\u-244?\u24039?\u22937?\u-30237?\u20915?\u24635?\u-30264?\u25928?\u26524?\u19981?\u20339?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 EXCEL\u30693?\u-29754?\u28857?\u-230?\u21333?\u20803?\u26684?\u26684?\u24335?\u12289?IF\u20989?\u25968?\u12289?FIND\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 16:30 \u-29774?\u-30237?\u32467?\u26463?\u-244?\u20114?\u21160?\u-27154?\u31572?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 17:00 \u-29698?\u31243?\u32467?\u26463?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-28435?\u-32767?\u24072?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 25\u24180?+\u20844?\u21496?\u-29406?\u21153?\u24635?\u30417?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 Excel\u19987?\u23478?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29774?\u24072?\u31616?\u20171?\u-230?\u-28435?\u-32767?\u24072?\u30446?\u21069?\u29616?\u20219?\u20844?\u21496?\u-29406?\u21153?\u24635?\u30417?\u-244?\u26377?\u-29307?\u-28729?25\u24180?\u-29406?\u21153?\u24037?\u20316?\u32463?\u-25972?\u-244?18\u24180?EXCEL\u23398?\u20064?\u22521?\u-29779?\u32463?\u21382?\u-244?\u21382?\u20219?\u25104?\u26412?\u20250?\u-29791?\u12289?\u20250?\u-29791?\u20027?\u31649?\u12289?\u-29406?\u21153?\u32463?\u29702?\u12289?\u-29406?\u21153?\u21103?\u24635?\u30417?\u12289?\u-29406?\u21153?\u24635?\u30417?\u-244?\u20855?\u26377?\u20016?\u23500?\u30340?\u-29406?\u21153?\u23454?\u25112?\u32463?\u-25972?\u12290?\u23545?\u20110?EXCEL\u12289?ACCESS\u12289?\u-28207?\u-30858?BOS\u24179?\u21488?\u31561?\u25968?\u25454?\u31649?\u29702?\u-28817?\u20214?\u-28419?\u-32515?\u29087?\u32451?\u24212?\u29992?\u12290?\u21892?\u20110?\u25968?\u23383?\u22788?\u29702?\u21644?\u25968?\u25454?\u20998?\u26512?\u-244?\u20174?\u25968?\u25454?\u-30254?\u24230?\u23545?\u-29406?\u21153?\u31649?\u29702?\u21644?\u20225?\u19994?\u31649?\u29702?\u26377?\u29420?\u29305?\u30340?\u-30271?\u-30237?\u12290?\u22312?\u22521?\u-29779?\u20013?\u21892?\u20110?\u25226?\u22797?\u26434?\u-27154?\u-26472?\u31616?\u21333?\u21270?\u-244?\u29992?\u24418?\u-29599?\u30340?\u22270?\u25991?\u26041?\u24335?\u-29783?\u23398?\u21592?\u29282?\u-29776?\u21508?\u31181?\u30693?\u-29754?\u-244?\u23545?\u25968?\u25454?\u31649?\u29702?\u26377?\u30528?\u25935?\u-27376?\u30340?\u27934?\u23519?\u21147?\u12290?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u25253?\u21517?\b0\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u20540?\u29677?\u25163?\u26426?\u-230?18971071887    \u-28498?\u31665?\u-230?Service@mingketang.com\par}