EXCEL常用函数应用实例

EXCEL常用函数实例1ABS实例19MAX实例2AND实例20MID实例3AVERAGE实例21MIN实例4COLUMN实例22MOD实例5CONCATENATE实例23MONTH实例6COUNTIF实例24NOW实例7DATE实例25OR实例8DATEDIF实例26RANK实例9DAY实例27RIGHT实例10DCOUNT实例28SUBTOTAL实例11FREQUENCY实例29SUM实例12IF实例30SUMIF实例13INDEX实例31TEXT实例14INT实例32TODAY实例15ISERROR实例33VALUE实例1816LEFT实例34VLOOKUP实例18t/h17LEN实例35WEEKDAY实例5518MATCH实例990t/h1、ABS85-100100回目录782、AND897080true回目录#VALUE!#NAME?653、AVERAGE123a4503.75回目录2.5654、COLUMN6022回目录535、CONCATENATE56mascxfmascitymascxf@mascity.com回目录mascxf@mascity.com6、COUNTIF返回数字4回目录7、DATE2/4/04回目录8、DATEDIF3/4/6345回目录9、DAY9/8/0818回目录812、IF符合要求回目录14、INT-19回目录15、ISERROR123false回目录416、LEFT我喜欢天极网我喜欢回目录17、LEN我今年28岁6回目录1019、MAX10回目录1atrue45620、MID我喜欢天极网天极网回目录21、MIN1回目录22、MOD1回目录123、MONTH9/8/0812回目录9200324、NOW39699.9535125回目录10:53下午25、OR7059true回目录#VALUE!#NAME?26、我喜欢天极网天极网回目录我喜欢天极网31、TEXT1280.45$1280.45回目录32、TODAY39699.0回目录33、VALUE12345123123回目录35、WEEKDAY1回目录240学号姓名性别MATCH_ word word文档格式规范word作业纸小票打印word模板word简历模板免费word简历 _1714326858551_0语文语文10401丁1男85.0>=70<8010402丁2男71.010403丁3女71.0510404丁4女70.010405丁5男75.010、DCOUNT回目录10406丁6男72.010407丁7男92.0女10408丁8男68.010409丁9女67.013、INDEX回目录10410丁10女62.0姓名语文体育丁185A丁290A丁398B丁497B丁586C丁682C丁776D丁884A丁989A丁1092B丁1198B丁1297B丁1387C丁1483C丁1584C丁1685D丁1785D丁1884D丁1982E丁2086E丁2190B丁2298B丁2393C丁2478C丁2576C丁2674D丁2772E丁2880B丁2980B丁3087C分数区间0-5905960-6906970-7957980-89168990-100910011、FREQUENCY回目录学号姓名性别语文10401丁1男85.0丁8910402丁2男71.010403丁3女71.018、MATCH10404丁4女70.010405丁5男75.0回目录10406丁6男72.010407丁7男92.010408丁8男68.010409丁9女67.010410丁10女62.0姓名语文名次名次1丁185151426、RANK丁290822回目录丁398128丁497426丁5861317丁682228丁776273丁8841811丁9891021丁1092724丁1198128丁1297426丁13871119丁14832110丁15841811丁16851514丁17851514丁18841811丁1982228丁20861317丁2190822丁2298128丁2393625丁2478265丁2576273丁2674292丁2772301丁2880246丁2980246丁30871119学号姓名性别语文10401丁1男67.010402丁2男71.010403丁3女71.010404丁4女70.010405丁5男75.010406丁6男72.010407丁7男64.010408丁8男68.010409丁9女79.010410丁10女77.010411丁11男75.010412丁12男69.010413丁13男74.010414丁14女88.010415丁15男68.010416丁16女81.010417丁17女80.010418丁18女75.010419丁19男71.010420丁20女66.010421丁21女79.010422丁22男73.010423丁23女69.010424丁24男85.010425丁25女82.010426丁26男81.010427丁27男70.010428丁28男77.010429丁29男78.010430丁30男83.010431丁31男77.010432丁32男77.010433丁33女78.010434丁34男77.010435丁35男81.010436丁36女82.010437丁37男75.010438丁38男69.010439丁39女79.010440丁40女75.010441丁41男77.010442丁42女56.010443丁43女62.010444丁44男83.010445丁45男71.010446丁46男74.010447丁47女83.010448丁48男52.010449丁49男73.010450丁50男64.010451丁51女76.010452丁52女79.010453丁53男74.010454丁54女85.010455丁55男67.010456丁56女72.010457丁57女73.010458丁58女70.010459丁59男72.010460丁60女82.010461丁61女75.010462丁62女76.0626128、SUBTOTAL回目录学号姓名性别语文10401丁1男67.010402丁2男71.010403丁3女71.010404丁4女70.010405丁5男75.010406丁6男72.010407丁7男64.010408丁8男68.010409丁9女79.010410丁10女77.010411丁11男75.010412丁12男69.010413丁13男74.010414丁14女88.010415丁15男68.010416丁16女81.010417丁17女80.010418丁18女75.010419丁19男71.010420丁20女66.010421丁21女79.010422丁22男73.010423丁23女69.010424丁24男85.010425丁25女82.010426丁26男81.010427丁27男70.010428丁28男77.010429丁29男78.010430丁30男83.010431丁31男77.010432丁32男77.010433丁33女78.010434丁34男77.010435丁35男81.010436丁36女82.010437丁37男75.010438丁38男69.010439丁39女79.010440丁40女75.010441丁41男77.010442丁42女56.010443丁43女62.010444丁44男83.010445丁45男71.010446丁46男74.010447丁47女83.010448丁48男52.010449丁49男73.010450丁50男64.010451丁51女76.010452丁52女79.010453丁53男74.010454丁54女85.010455丁55男67.010456丁56女72.010457丁57女73.010458丁58女70.010459丁59男72.010460丁60女82.010461丁61女72.010462丁62女76.0总分4601.029、SUM回目录总分1424学号姓名性别语文10401丁1男67.010402丁2男71.010403丁3女71.010404丁4女70.010405丁5男75.010406丁6男72.010407丁7男64.010408丁8男68.010409丁9女79.010410丁10女77.010411丁11男75.010412丁12男69.010413丁13男74.010414丁14女88.010415丁15男68.010416丁16女81.010417丁17女80.010418丁18女75.010419丁19男71.010420丁20女66.010421丁21女79.010422丁22男73.010423丁23女69.010424丁24男85.010425丁25女82.010426丁26男81.010427丁27男70.010428丁28男77.010429丁29男78.010430丁30男83.010431丁31男77.010432丁32男77.010433丁33女78.010434丁34男77.010435丁35男81.010436丁36女82.010437丁37男75.010438丁38男69.010439丁39女79.010440丁40女75.010441丁41男77.010442丁42女56.010443丁43女62.010444丁44男83.010445丁45男71.010446丁46男74.010447丁47女83.010448丁48男52.010449丁49男73.010450丁50男64.010451丁51女76.010452丁52女79.010453丁53男74.010454丁54女85.010455丁55男67.010456丁56女72.010457丁57女73.010458丁58女70.010459丁59男72.010460丁60女82.010461丁61女72.010462丁62女76.0男生总分2484.030、SUMIF回目录女生总分2117学号姓名性别语文10401丁1男67.010402丁2男71.010403丁3女71.010404丁4女70.010405丁5男75.010406丁6男72.010407丁7男64.010408丁8男68.010409丁9女79.010410丁10女77.010411丁11男75.010412丁12男69.010413丁13男74.010414丁14女88.010415丁15男68.010416丁16女81.010417丁17女80.010418丁18女75.010419丁19男71.010420丁20女66.010421丁21女79.010422丁22男73.010423丁23女69.010424丁24男85.010425丁25女82.010426丁26男81.010427丁27男70.010428丁28男77.010429丁29男78.010430丁30男83.010431丁31男77.010432丁32男77.010433丁33女78.010434丁34男77.010435丁35男81.010436丁36女82.010437丁37男75.010438丁38男69.010439丁39女79.010440丁40女75.010441丁41男77.010442丁42女56.010443丁43女62.010444丁44男83.010445丁45男71.010446丁46男74.010447丁47女83.010448丁48男52.010449丁49男73.010450丁50男64.010451丁51女76.010452丁52女79.010453丁53男74.010454丁54女85.010455丁55男67.010456丁56女72.010457丁57女73.010458丁58女70.010459丁59男72.010460丁60女82.010461丁61女72.010462丁62女76.034、VLOOKUP回目录查询丁4852H5：汽车50H2：VCRH3：桌子H4：杯子H5：汽车H6：洗衣机H7：火箭发射器H8：自行车H9：电话H10：蜡烛6H11：糖果H12：扬声器H13：衣服H14：毯子5H15：干衣机H16：吉他H17：干衣机H18：工具箱H19：VCRH6：洗衣机H20：硬盘0206781221