=SUM(A1:A10)
=SUM(A1:A5,B1:B5)
=AVERAGE(C1:C10)
=MAX(D1:D10)
=MIN(D1:D10)
=VLOOKUP(A1,Sheet1!A1:B10,2,FALSE)
=IF(A1>10,"大于10","小于等于10")
=COUNT(E1:E10)
=COUNTA(E1:E10)
=LEFT(A1,3)
=RIGHT(A1,4)
=MID(A1,3,5)
=CONCATENATE(A1,B1)
=A1&B1