【单选题】在excel工作表A1单元格里存放了18位二代身份证号,在A2单元格中利用公式计算该人的年龄,最优的操作方法是
A.
=year(today())-mid(a1,6,8)
B.
=year(today())-mid(a1,7,8)
C.
=year(today())-mid(a1,6,4)
D.
=year(today())-mid(a1,7,4)
【单选题】在Excel工作表A1单元格里存放了18位二代身份证号码,在A2单元格中利用公式计算该人的年龄,最优的操作方法是
A.
=YEAR(TODYAY()-MID(A1,6,8))
B.
=YEAR(TODYAY()-MID(A1,6,4))
C.
=YEAR(TODYAY()-MID(A1,7,8))
D.
=YEAR(TODYAY()-MID(A1,7,4))
【简答题】在Excel工作表A1单元格里存放了18位二代身份证号码,在A2单元格中利用公式计算该人的年龄,最优的操作方法是: A)=YEAR(TODAY())-MID(A1,6,8) B)=YEAR(TODAY())-MID(A1,6,4) C)=YEAR(TODAY())-MID(A1,7,8) D)=YEAR(TODAY())-MID(A1,7,4)
【单选题】在Excel工作表A1单元格里存放了18位二代身份证号码,在A2单元格中利用公式计算该人的年龄,最优的操作方法是
A.
=YEAR(TODAY())-MID(A1,6,8)
B.
=YEAR(TODAY())-MID(A1,6,4)
C.
=YEAR(TODAY())-MID(A1,7,8)
E.
AR(TODAY())-MID(A1,7,4)