SUM()
=SUM(A1:A10)
AVERAGE()
=AVERAGE(B1:B20)
MAX()
=MAX(C1:C50)
COUNT()
=COUNT(D1:D100)
COUNTIF()
=COUNTIF(E1:E50,">30")
LEFT()
=LEFT(A1,3)
RIGHT()
=RIGHT(B1,5)
MID()
=MID(C1,2,4)
VLOOKUP()
=VLOOKUP(D1,A1:B10,2,FALSE)
INDEX()
MATCH()
=INDEX(B1:B10,MATCH(D1,A1:A10,0))
NOW()
YEAR()
=YEAR(A1)