在Excel中,将某学生各科成绩放在Al:A9单元格中,判断A1单元格中成绩等级的函数正确的是(47)。(判断的依据是:成绩大于等于85为优良,大于等于60为及格,否则不及格)A.=IF(AI>=85,”优良”,IF(Al>=60,“及格”,IF(A1=85,“优良”,85>AI>=60,”及格“.A1=85,“优良“),IF(AI>=60,”及格“),IF(Al=85,“优良“,IF(AJ>=60.“及格”,”不及格”))
点击查看答案
在Excel中,设单元格Al中的值为80,BI中的值为35,若在CI单元格中输入函 数“=IF(AND(AI>=60,Bl>=60),”不及格”,”补考”)”,按回车键后,CI单元格中的值为 (52)。A.80B.60C.不及格D.补考
某Excel成绩表如下所示,若在G13单元格中输入( ),则G13单元格为平均成绩不及格的学生数。假设学生平均成绩分为优秀(平均成绩≥85)、及格(60≤平均成绩<85)和不及格(平均成绩<60)三个等级,那么在H3单元格中输入(请作答此空),并垂直向下拖动填充柄至H12,则可以完成其他同学成绩等级的计算。A.IF(G3>=85,"优秀",IF(G3>=60,"及格","不及格")) B.=IF(G3>=85,"优秀",IF(G3>=60,"及格","不及格")) C.IF(平均成绩>=85,"优秀",IF(平均成绩>=60,"及格","不及格")) D.=IF(平均成绩>=85,"优秀",IF(平均成绩>=60,"及格","不及格"))
Excel操作中,成绩放在单元格A1,要将成绩分为优良(大于等于85)、及格(大于等于60)、不及格三个级别的公式为()。A、=if(A1>=85,“优良”,if(A1>=60,“及格”,if(A1<60,“不及格”))) B、=if(A1>=85,“优良”,85>A1>=60,“及格”,A1<60,“不及格”) C、=if(A1>=85,“优良”),if(A1>=60,“及格”),if(A1<60,“不及格”) D、=if(A1>=85,“优良”,if(A1>=60,“及格”,“不及格”))
在Excel工作表中,A5单元格的值小于60,则B5单元格为“不及格”,否则为“及格”,则B5单元格的公式可写为()。A=IF(A5<60,不及格,及格)B=IF(A5<60,"不及格","及格")C=IF(A5<60,及格,不及格)D=IF(A5<60,"及格","不及格")
设SC表中记录成绩的列为:Grade,类型为int。若在查询成绩时,希望将成绩按‘优’、‘良’、‘中’、‘及格’和‘不及格’形式显示,正确的Case函数是()。A Case Grade When 90~100 THEN ’优’ When 80~89 THEN ’良’ When 70~79 THEN ’中’ When 60~69 THEN ’及格’ Else ’不及格’ EndB Case When Grade between 90 and 100 THEN Grade = ’优’ When Grade between 80 and 89 THEN Grade = ’良’ When Grade between 70 and 79 THEN Grade = ’中’ When Grade between 60 and 69 THEN Grade = ’及格’ Else Grade = ’不及格’ EndC Case When Grade between 90 and 100 THEN ’优’ When Grade between 80 and 89 THEN ’良’ When Grade between 70 and 79 THEN ’中’ When Grade between 60 and 69 THEN ’及格’ Else ’不及格’ EndDCase Grade When 90~100 THEN Grade = ’优’ When 80~89 THEN Grade = ’良’ When 70~79 THEN Grade = ’中’ When 60~69 THEN Grade = ’及格’ Else Grade = ’不及格’ End
单元格A2输入了数值60,单元格B2存放了公式:=IF(A2>90,“优”,IF(A2>75,“良”,IF(A2>59,“及格”,“不及格”)))。那么B2显示的是()A、及格B、良C、优D、不及格