电子表格包含如下信息:员工号、部门、姓名、性别、应发工资、扣除款、实发工资,要计算出“生产部”实发工资总额应该使用()函数。
A.IF
B.COUNTIF
C.SUMIF
D.AVERAGEIF
A.IF
B.COUNTIF
C.SUMIF
D.AVERAGEIF
第1题
A.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 应发工资-扣除工资
B.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 实发工资
C.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 实发工资 From 职工基本情况表
D.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 应发工资-扣除工资 From 职工基本情况表
E.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From "职工基本情况表" Order By 应发工资-扣除工资
第2题
A.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 应发工资-扣除工资
B.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 实发工资
C.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 实发工资 From 职工基本情况表
D.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 应发工资-扣除工资 From 职工基本情况表
E.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From "职工基本情况表" Order By 应发工资-扣除工资
第3题
A.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 应发工资-扣除工资
B.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 实发工资
C.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 实发工资 From 职工基本情况表
D.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 应发工资-扣除工资 From 职工基本情况表
E.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From "职工基本情况表" Order By 应发工资-扣除工资
第4题
A.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 应发工资-扣除工资
B.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 实发工资
C.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 实发工资 From 职工基本情况表
D.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 应发工资-扣除工资 From 职工基本情况表
E.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From "职工基本情况表" Order By 应发工资-扣除工资
第5题
A.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 应发工资-扣除工资
B.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 实发工资
C.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 实发工资 From 职工基本情况表
D.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 应发工资-扣除工资 From 职工基本情况表
E.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From "职工基本情况表" Order By 应发工资-扣除工资
第6题
A.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 应发工资-扣除工资
B.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From 职工基本情况表 Order By 实发工资
C.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 实发工资 From 职工基本情况表
D.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 Order By 应发工资-扣除工资 From 职工基本情况表
E.Select 工号, 姓名, 应发工资-扣除工资 as 实发工资 From "职工基本情况表" Order By 应发工资-扣除工资
第7题
第9题
A.部门编号
B.姓名
C.职工号
D.职工号和姓名
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!