A.=ROUND(B1,2)
B.=ROUND(B1,-3)
C.=ROUND(B1,-2)
D.=ROUND(B1,3)
您可能感兴趣的试卷
你可能感兴趣的试题
A.503
B.1
C.4
D.2013
A.#DIV/0!
B.#NUM!
C.#VALUE!
D.######
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))
A.=32470+1000
B.=33470
C.33470
D.324701000
A.Sum
B.Max
C.Count
D.Average