1、excelexcelexcelexcelexceiexcelexcel2010101excelexcelexcel excelexcel excel excelexcelexcel11(1)sumsum(number1,number2,number3?)(2)average3if4count5max6sin7sumif:8concatenate excel excel excel excel excelexcel excelexcelexcel excel123123excelexcel excelexcelexcelexcel excel excelexcel excelexcelexcel
2、excelexcelexcelexcelexcelexcelexcelexcel excel excel excelexcelexcel excelexcelexcel351201040118:2014.04.15excelexcelexcelexcelmicrosoft windowsexcelexcelexcelexcelexcelexcelexcelexcelexcel99%excelexcelexcelexcelexcelexcelexcel111rankrankexcel:rank numberrefordernumberref orderorder2countifcountifco
3、untifrangecriteria rangecriteria3average max mid min mod sum excel11ctrlctrl+21232excel123excel1 0150280excel0942200911311209excelexcelexcelexcelexcel1excelmicrosoft windowsexcelexcelexcelexcelexcelexcel2excelexcelexcelexcel3excel9793499%excelexcelexcelexcel 160 60countif()=countif(c3:c12,=60),60 70