单项选择题
A.IF(G2=博士,300,IF(G2=研究生,300,IF(G2=本科生,200))) B.IF(G2="博士",300,IF(G2="研究生",300,IF(G2="本科生",200))) C.IFERROR(IF(G2=博士,300,IF(G2=研究生,300,IF(G2=本科生,200))),100) D.IFERROR(IF(G2="博士",300,IF(G2="研究生",300,IF(G2="本科生",200))),100,50)
下面关于if函数使用正确的是?()A.IF(G2<60,"不及格",IF(G2<80,"及格","优良"))B...
单项选择题下面关于if函数使用正确的是?()
A.IF(G2<60,"不及格",IF(G2<80,"及格","优良")) B.IF(G2="",IF(G2<60,"不及格",IF(G2<80,"及格","优良"))) C.IF(G2<60,"不及格",IF(G2<80,"及格")) D.IF(G2<60,不及格,IF(G2<80,及格,优良))
在Excel中MOD(4,3)=?()A.2B.3C.1D.0
单项选择题在Excel中MOD(4,3)=?()
A.2 B.3 C.1 D.0
在Excel中A列从A1-A5单元格,依次有数据80、98、65、79、65,对5个数进行排名,正确的表达式?...
单项选择题在Excel中A列从A1-A5单元格,依次有数据80、98、65、79、65,对5个数进行排名,正确的表达式?()
A.RANK(A1,$A$1:$A$5,0) B.RANK($A$1:$A$5,0) C.RANK(A1:A5)