"日期"
"练习"
"四:在表中用"YEAR"和"NOW"函数求出学生的年龄."
"数学系学生会干部名单"
"学号","姓名","出生年月","身高(cm)","年龄"
2003033141,"杨吉华","1984-2-11","166 "
2002023232,"王辉","1983-5-19","167 "
2001013113,"张小茜","1983-8-22","157 "
2003033104,"刘文魁","1982-1-12","170 "
2002023205,"俞春波","1984-7-1","169 "
2003033116,"许文华","1983-8-10","174 "
2002023307,"陈东来","1982-9-16","176 "
2003033328,"孙小燕","1984-3-11","160 "
2001013109,"李雷","1983-4-18",171
2003033219,"王辉","1982-9-17",169
2002023311,"张颖","1981-8-16",172
"IF"
"作业要求:"
"用公式求各位同学的等级,各个等级的说明如下:"
"等级1:平均分60分以上为"合格",60分以下为"不合格""
"等级2:平均分80分以上为"中等",60分至80分(不含80分)之间为"合格",60分以下为"不合格""
"等级3:平均分90分以上为"优秀",平均分80分到90分(不含90分)之间为"中等",60分至80分(不含80分)之间为"合格",60分以下为"不合格""
"班级","姓名","数学","英语","语文","平均分","等级1","等级2","等级3"
1,"包星",73,70,50
1,"陈刚",93,61,59
1,"陈敏过",68,56,78
1,"代新学",80,68,78
1,"过与过",87,79,90
1,"红难南",61,75,76
2,"董华",53,74,78
2,"刚毅",81,87,90
2,"郭星",80,70,85
2,"国新落",75,40,58
2,"虹红",78,69,85
2,"李肇东",84,76,88
"逻辑"
"作业要求:"
"用公式求各位同学的等级,各个等级的说明如下:"
"等级1:语文在80分以上而且数学成绩也在80分以上为"良好",否则为"合格""
"等级2:语文在80分以上或者数学成绩也在80分以上为"良好",否则为"合格""
"等级3: 语文,数学和英语成绩都在80分以上为"良好",否则为"合格""

下一页