你可能喜欢
单项选择题
A.=ROUND(B1,2)
B.=ROUND(B1,-3)
C.=ROUND(B1,-2)
D.=ROUND(B1,3)
单项选择题
A.=IF(MID(OR(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100)<>0),MOD(YEAR(TODAY()),400)=0),""闰年"",""平年"")
B.=IF(OR(AND(MOD(YEAR(TODAY()),4)<>0,MOD(YEAR(TODAY()),100)=0),MOD(YEAR(TODAY()),400)=0),""闰年"",""平年"")
C.=IF(AND(OR(MOD(YEAR(TODAY()),4)<>0,MOD(YEAR(TODAY()),100)=0),MOD(YEAR(TODAY()),400)=0),""闰年"",""平年"")
D.=IF(OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100)<>0),MOD(YEAR(TODAY()),400)=0),""闰年"",""平年"")
单项选择题
A.=OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100)<>0),MOD(YEAR(TODAY()),400)=0)
B.=MID(OR(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100)<>0),MOD(YEAR(TODAY()),400)=0)
C.=OR(AND(MOD(YEAR(TODAY()),4)<>0,MOD(YEAR(TODAY()),100)=0),MOD(YEAR(TODAY()),400)=0)
D.=AND(OR(MOD(YEAR(TODAY()),4)<>0,MOD(YEAR(TODAY()),100)=0),MOD(YEAR(TODAY()),400)=0)
单项选择题
A.=REPLACE(A1,1,1,2013)
B.=REPLACE(A1,1,0,2013)
C.=REPLACE(A1,1,2,2013)
D.=REPLACE(A1,2,0,2013)
单项选择题
A.=MID(A1,7,4)
B.=YEAR()-MID(A1,7,4)
C.=YEAR(NOW())-MID(A1,7,4)
D.=NOW()-MID(A1,7,4)
单项选择题
A.=COUNTIF(A :A ,A1)=1
B.=COUNTIF(A :A ,A1)
C.COUNTIF(A :A ,A1)=1
D.=COUNT(A :A ,A1)=1
单项选择题
A.SUM(MOD(A1:A10,2))
B.{SUM(MOD(A1:A10,2))}
C.{=SUM(MOD(A1:A10,2))}
D.=SUM(MOD(A1:A10,2))