计算机二级office函数公式

计算机二级office函数公式计算机二级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高级应用》"),订单明细表!H3:H262)将订单明细表中满足E3:E262单元格区域中为《MSOffice高级应用》的对应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.=产品基本信息表!C2*C2=一季度销售情况表!C2+'二季度销售情况表'!C2=一季度销售情况表!D2+'二季度销售情况表'!D2=RANK(D2,$D$2:$D$21,0)排序4.=SUM(D2:D34)5.=IF(WEEKDAY(A3,2)>5,"是","否")WEEKDAY(日期,系数)中的系数有很多种，系数为2时，表示每周第一天以星期一为1计。="第"&RANK(F2,$F$2:$F$45)&"名"=IF(F2>=102,"优秀",IF(F2>=84,"良好",IF(F2>=72,"及格",IF(F2>72,"及格","不及格"))))=IF(F2>=90,"优秀",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,学生档案!$A$1:$B$56,2,FALSE)="第"&RANK(F2,$F$2:$F$45)&"名"=IF(F2>=102,"优秀",IF(F2>=84,"良好",IF(F2>=72,"及格",IF(F2>72,"及格","不及格"))))=IF(F2>=90,"优秀",IF(F2>=75,"良好",