2013新手班练习题

雪舞子

三键下拉

1. =IF(COUNT(SEARCH(ROW($1:$10)-1,A2)),"有数字","无数字")

复制代码

1. =IF(COUNT(-MID(A2,ROW($1:$100),1)),"有数字","无数字")

复制代码

13641096715

一题=IF(100<=B2,"A",IF(90<=B2,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","E")))))

轻松

基础：=IF(AND(B2>59,C2>59,D2>59),"是","否")
1、=IF(B2>89,"A",IF(B2>79,"B",IF(B2>69,"C",IF(B2>59,"D","E"))))
2、不会
3、=LARGE(B2:B11,1)
4、不会
5、=VLOOKUP($G$1,$A$1:$D$9,ROW(B2),0)

VBA新手1

{:041:}

josonxu

基础骗：=IF(AND(B2>=60,C2>=60,D2>=60),"是","否")
第一题：｛=LOOKUP(B2:B15,{0,60,70,80,90},{"E","D","C","B","A"})｝
第二题：=IF(MAX(COUNTIF(B2:B12,$B2))=MAX(COUNTIF($B$2:$B$12,$B2)),SUMIF($B$2:$B$12,$B2,$C$2:$C$12),"")
第三题：｛=MAX((MONTH(A2:A11)<=3)*(B2:B11))｝
第四题：=TEXT(SUMPRODUCT(--ISNUMBER(--MID(A2,ROW($1:$31),1))),"有数字;;无数字")
第五题：=VLOOKUP(G1,$A$1:$D$9,2,0)
             =RIGHT(VLOOKUP(G1,$A$1:$D$9,4,0),3)

baoerr

基础篇：=IF((B2>=60)*(C2>=60)*(D2>=60),"是","否")三键结束。
1.=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","E"))))
其余的题，不会啦，继续学习。

zhyoucheng

基础篇

1. =IF(AND(B2>=60,C2>=60,D2>=60),"是","否")

复制代码

一题

1. =LOOKUP(B2,{0;60;70;80;90},{"E";"D";"C";"B";"A"})

复制代码

二题

1. =IF(COUNTIF($B$2:B2,B2)=1,SUMIF(B2:$C$12,B2,C2:$C$12),"")

复制代码

三题

1. {=MAX((MONTH(A2:A11)<=3)*(B2:B11))}

复制代码

四题

1. =IF(COUNT(FIND({0;1;2;3;4;5;6;7;8;9},A2)),"有数字","无数字")

复制代码

1. {=IF(COUNT(FIND(ROW(1:10)-1,A2)),"有数字","无数字")}

复制代码

五题

1. =IF(ROW()=4,RIGHT(VLOOKUP($G$1,$A$2:$D$9,ROW(),TRUE),3),VLOOKUP($G$1,$A$2:$D$9,ROW(),TRUE))

复制代码

tianyiyi

把会的先做了，以后再慢慢改
修改了一下，第四题出来了，哈哈

艾琳

基础题：=IF(COUNTIF(B2:D2,">=60")=3,"是","否")
第一题：=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","E"))))
第二题：不会
第三题：=MAX(B2:B11)
第四题：不会
第五题：不会

深受打击啊，新手班能不能不要这么难啊{:14:}

珺珺妈

基础题：=IF(AND(B2>=60,C2>=60,D2>=60),"是","否")
1.=IF(B2<60,"E",IF(B2>=90,"A",IF(AND(B2>=60,B2<70),"D",IF(AND(B2>=70,B2<80),"C","B"))))
2.=IF(ROW()=MATCH(B2,B:B,0),SUMIF(B:B,B2,C:C),"")
3.=MAX(IF(MONTH(A2:A11)<4,1)*B2:B11)三键
4.=IF(COUNT(FIND({0;1;2;3;4;5;6;7;8;9},A2)),"有数字","无数字")
5.姓名：用数据有效性
  性别=VLOOKUP(G1,A2:B9,2,)
  部门=VLOOKUP(G1,A2:C9,3,0)
工作证号数字编码=RIGHT(VLOOKUP(G1,A2:D9,4,0),3)
第5题不知道理解题意是否有错？