公式:
	=VLOOKUP(Key,範圍,2,FALSE)
	=VLOOKUP(Key,範圍,2,TRUE)
	=SUM(範圍)
	=AVERAGE(範圍)
	=MAX(範圍)
	=MIN(範圍)
	=SUMPRODUCT(範圍一,範圍二)
	=IF(條件,x,y)
	=COUNTIF(範圍,條件)


wk12

課外活動

H2
	=VLOOKUP(A2,students,3,FALSE)
I2
	=VLOOKUP(B2,society,2,FALSE)
J2
	=VLOOKUP(C2,rank,2,FALSE)
K2
	=VLOOKUP(E2,award,2,FALSE)
L2
	=VLOOKUP(F2,award,2,FALSE)


學生資料
H2
	=COUNTIF(E:E,G2)
	=COUNTIF(E:E,"C")
H6
	=SUM(H2:H5)
K2
	=COUNTIF(A:A,"2A*")
N2
	=COUNTIF(C:C,"陳*")


wk13-14	發票

H8
	=IF(H8="",
		"",
		VLOOKUP(H8,products,3,FALSE))
J8
	=IF(H8="",
		"",
		VLOOKUP(H8,products,5,FALSE))
J18
	=SUMPRODUCT(J8:J17,K8:K17)
J20
	=K18-K19
J3
	=today()


wk15	BMI體重指標

C13
	=C10/C11/C11
C15
	=VLOOKUP(C13,B4:G7,5,TRUE)
C16
	=VLOOKUP(C13,D4:G7,3,TRUE)
L2
	=VLOOKUP(J2,Greeting!C2:D3,2,FALSE)
L4
	=VLOOKUP(J4,Greeting!B5:D7,3,TRUE)
L6
	=L2&L4


wk16	Exam