1、excelexcel 1excelexcelmaxminrankifcountif-2-1maxminrankifsumif2maxminrankifsumif -3maxminrankifsumiexcel - 1 301 sumaveragemaxminrankifsumifmaxmax1d182-=max(d3:d17)3-d3d17h3minminrankrank1/010ifif()sumifsumif()()(2)3 2excel 2007excelexcelexcelexcelexcel 12excelsumaveragemaxmin 1excel 2excel3excelexc
2、elexcelexcelsumaveragemaxminexcelaveragepptexcelexcel12excelsumaveragemaxmin 1excel 2excel3excelexcelexcelexcelexcelppt.pptexcel.xls .xls 122342641 2 ppt1+2+4+8+16+32+64+128+?1641 2 4 8?1.84467e+19 641261 3 - excel1=suma1a64p126suma1a64a1a64 2a bc d b22c1313a246246sumsuma1a64a1a6413averagesump131average20061p131f1.4.18average2 3 4 average 4maxmin sumc3e3g3h3pptexcelexcel1excel2excelexcel1212excel3 1excel23 124 ()excel() 1excel+ - */%2 1 =30%+70% 3 1 2- 3 1=/270%4-excel 12$3a$2a$223()excel()4=-/-4-6-excelexcel-
