多项选择题
A.SUBSTITUTE(A2,销售,营销) B.SUBSTITUTE("销售",A2,"营销") C.SUBSTITUTE("销售","营销",A2) D.SUBSTITUTE(A2,"销售","营销")
下面关于DATEDIF是()A.DATEDIF("2019/9/23","2020/5/23",d)B.DAT...
多项选择题下面关于DATEDIF是()
A.DATEDIF("2019/9/23","2020/5/23",d) B.DATEDIF("2019/9/23","2020/5/23","m") C.DATEDIF("2020/5/23","2019/9/23","y") D.DATEDIF("2019/9/23","2020/5/23","y")
在Excel中,A2单元格为“2019/12/2”,要在A3单元格运用函数计算在1个月中的第几天,要用到以下哪...
单项选择题在Excel中,A2单元格为“2019/12/2”,要在A3单元格运用函数计算在1个月中的第几天,要用到以下哪个函数()
A.WEEK B.DAY C.TODAY D.WEEKDAY
在Excel中,A2单元格为“2019/12/2”,要在A3单元格运用函数直接输出是星期几/周几,下列公式正确...
多项选择题在Excel中,A2单元格为“2019/12/2”,要在A3单元格运用函数直接输出是星期几/周几,下列公式正确的是()
A.TEXT(WEEKDAY(A2),"aaaa") B.TEXT(WEEK(A2),"aaaa") C.TEXT(WEEKDAY(A2,1),"aaaa") D.TEXT(WEEKDAY(A2,1),"aaa")