計算機二級office函數(shù)公式

計算機二級office函數(shù)公式計算機二級Msofficeexcel表格公式都是自己做的，順序可能不大一樣，15年三月的備考，祝大家好運了~1.=VLOOKUP(D3,編號對照!$A$3:$C$19,3,FALSE)=VLOOKUP(D4,編號對照!$A$3:$C$19,3,FALSE)=[@單價]*[@銷量（本）]=SUM(訂單明細表!H3:H636)=SUMPRODUCT(1*(訂單明細表!E3:E262="《MSOffice高級應(yīng)用》"),訂單明細表!H3:H262)將訂單明細表中滿足E3:E262單元格區(qū)域中為《MSOffice高級應(yīng)用》的對應(yīng)H列求和=SUMPRODUCT(1*(訂單明細表!C350:C461="隆華書店"),訂單明細表!H350:H461)=SUMPRODUCT(1*(訂單明細表!C263:C636="隆華書店"),訂單明細表!H263:H636)/122.=LOOKUP(MID(A2,3,2),{"01","02","03"},{"1班","2班","3班"})3.=產(chǎn)品基本信息表!C2*C2=一季度銷售情況表!C2+'二季度銷售情況表'!C2=一季度銷售情況表!D2+'二季度銷售情況表'!D2=RANK(D2,$D$2:$D$21,0)排序4.=SUM(D2:D34)5.=IF(WEEKDAY(A3,2)>5,"是","否")WEEKDAY(日期,系數(shù))中的系數(shù)有很多種，系數(shù)為2時，表示每周第一天以星期一為1計。="第"&RANK(F2,$F$2:$F$45)&"名"=IF(F2>=102,"優(yōu)秀",IF(F2>=84,"良好",IF(F2>=72,"及格",IF(F2>72,"及格","不及格"))))=IF(F2>=90,"優(yōu)秀",IF(F2>=75,"良好",IF(F2>=60,"及格",IF(F2>60,"及格","不及格"))))=VLOOKUP(A3，語文!$A$2:$F$45,6,0)新題1.=RANK(M3,$M$3:$M$102,0)="法律"&TEXT(MID(B3,3,2),"[DBNum1]")&"班"2.=VLOOKUP(D4,圖書編目表!$A$2:$B$9,2,FALSE)=MONTH($B$3:$B$678)=SUMIFS(銷售訂單!$H$3:$H$678,銷售訂單!$E$3:$E$678,A4,銷售訂單!$C$3:$C$678,2)3.=IF(MOD(MID(C2,17,1),2)=1,"男","女")性別=TEXT(MID(C2,7,8),"0-00-00")生日=DATEDIF(TEXT(MID(C2,7,8),"0-00-00"),TODAY(),"Y")年齡=VLOOKUP(A2,學(xué)生檔案!$A$1:$B$56,2,FALSE)="第"&RANK(F2,$F$2:$F$45)&"名"=IF(F2>=102,"優(yōu)秀",IF(F2>=84,"良好",IF(F2>=72,"及格",IF(F2>72,"及格","不及格"))))=IF(F2>=90,"優(yōu)秀",IF(F2>=75,"良好",