学习EXCEL心得体会.doc

excelexcelexcelexcelexceiexcelexcel2010101excelexcelexcel excelexcel excel excelexcelexcel11(1)sumsum(number1,number2,number3?)(2)average3if4count5max6sin7sumif:8concatenate excel excel excel excel excelexcel excelexcelexcel excel123123excelexcel excelexcelexcelexcel excel excelexcel excelexcelexcelexcelexcelexcelexcelexcelexcelexcelexcel excel excel excelexcelexcel excelexcelexcel351201040118:2014.04.15excelexcelexcelexcelmicrosoft windowsexcelexcelexcelexcelexcelexcelexcelexcelexcel99%excelexcelexcelexcelexcelexcelexcel111rankrankexcel:rank numberrefordernumberref orderorder2countifcountifcountifrangecriteria rangecriteria3average max mid min mod sum excel11ctrlctrl+21232excel123excel1 0150280excel0942200911311209excelexcelexcelexcelexcel1excelmicrosoft windowsexcelexcelexcelexcelexcelexcel2excelexcelexcelexcel3excel9793499%excelexcelexcelexcel 160 60countif()=countif(c3:c12,<=60),60 70countif()sum()=sum(if(c3:c12>=60,if(c3:c12<70,1,0), #value!ctrl+shift7080809090countif()sum()average():average(c3:c12)ok2enteraltenter3excel/1. b1b1 2.b1 2. b1 b1round=round(if(a1$#62;5,6234*.05),2) 23excel8910