EXCEL常用函数实例.xls

EXCELEXCEL常常用用函函数数实实例例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实例16LEFT实例34VLOOKUP实例17LEN实例35WEEKDAY实例18MATCH实例1、ABS85-100100回目录782、AND897080TRUE回目录#VALUE!653、AVERAGE123a3.75回目录2.5654、COLUMN6022回目录535、CONCATENATE回目录6、COUNTIF4回目录7、DATE2004/2/4回目录8、DATEDIF1963/3/441回目录9、DAY2004/4/1218回目录1212、IF符合要求回目录14、INT-19回目录15、ISERROR123FALSE回目录416、LEFT我喜欢天极网我喜欢回目录17、LEN我今年28岁6回目录1019、MAX10回目录120、MID我喜欢天极网天极网回目录21、MIN1回目录22、1回目录123、MONTH2004/4/1212回目录424、NOW4月12日回目录4:06 PM25、OR7059TRUE回目录#VALUE!26、我喜欢天极网天极网回目录我喜欢天极网31、TEXT1280.45$1280.45回目录32、TODAY星期一回目录33、VALUE12345 123123回目录35、WEEKDAY1回目录240#NAME?45 0aTRUE4 5 62003#NAME?学号姓名 性别 语文语文 语文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.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.010461丁61女72.010462丁62女76.0总分4601.0 29、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.010461丁61女72.010462丁62女76.0男生总分2484.0 30、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.010461丁61女72.010462丁62女76.034、VLOOKUP回目录查询丁4852学号姓名性别语文