สื่อการเรียนการสอน โดยใช้ Excel

iM nLg ii x L LL 52 L552 L5 xL L5 x55 2 L 5

Microsoft Excel xT x 5 Excel i 5 5 5 n 5i 2 (Speadsheet) 5xT i 5 5 L5L L öê x L L5L L L M L5 2 x inê2 2 L5 2 x L5L n㈠M L x L ㈠M öê x L5L x 2 êTx 5 Lg x ngL L x L5 x0 x L5 x iL x L5 gL L2 L5 Lg x 5 L L5Ğ iM x L ix L Li 52 L 0ê ㈠ö

2 M n0 ê2 gL M x Microsoft Excel 1. LL L L5ĞiL L5 gL L2 Excel L L5Ğ 0x 5 L5 gL L2nL 20 ‵L 5 L 2 L5 5L nM㈠ 5 Lg L2iL xTê i i x L5 gL L2 xT M , x L5 gL L2 2ê L êxT x0 n2ê gL L ê2 L ngL 5L x 2 L L ê2 L L5 Lg L2 2. LL L L5ĞiL L5 ,5 Mê x L L5 x0 5 2nL 20 ‵L 5 L Excel M L L5Ğ 0x ,5 êM xTê ix2 ,5 Mê ê2 L M MLxM 5 LM LM nê2 ,5 êM ê2 L M L5 0 5xT L5 Mi 0

2 M n0 2ê gL M x Microsoft Excel ( x) 3. LL L L5Ğ L5 5L 5L, Excel L L5Ğ Lg x n2ê 0x L5L L 5L 5L, inM n2 25 5L, xT L L 5 L LL L 5L, n i xi L iTxi 5L,L i L L5 Li 4. LL L L5Ğ L5 L5L x Excel L L5Ğ L5L x 5xT 5L, x iL L 2 5 MLxM 5 L êxT i0 LL L L x i L ㈠ö 5. LL L L5Ğ L5 Mi 52 Lg iM Excel L L5Ğ Mi Tx 6 L x nê2 x L5 LL0 5L i

2 M n0 ê2 Lg M x Microsoft Excel ( x) 6. LL L L5Ğ L5 0 L xx nL 5êTx 0 Excel L L5Ğ 0 L nM㈠ x 5 L 5xT 5L,xx nL 5xTê 0 inM n2 êö ngL L x L5 5L 5L L 7. LL L L5Ğ L5 x L5L L êTx Lg L i i-

5 i x Microsoft Excel 1. 5L L5L ngL L Mi L5L L L 5 L 2. 5L x L5nê2 x 2 L5 gL L2 êxT i 5 ( L L5Ğ êxT i , i2 L M L , 5xT L 5êxT i) 3. L iM x T㈠x n2ê Lg L x 0 1 L ĞL ( nL 0 M 0 gLLL 0 M ngL L i x ML) 4. 5L 5L L 5 x L L5L 5 xi L L5L 5 x 0 L 5 i 5 L5 0 5 x Li L L L x M L 5. 5L 5L, gL x x 5 L LL 5L, n 5L, L i n㈠M 2 0 0 3 0 0 52 L L L

L,0 2 L5 L i 5 5 Microsoft Excel

52 ML x Microsoft Excel 1 0i ㈠M Microsoft Office ĞL M 2. Microsoft Excel i 5 5 iê2 L standalone öê ii 5 5 x Microsoft Office gL 5M n2ê x㈠T 5xT subscribe

2 i , Excel ĞL i , Excel nê2 2x iM 0 0 , ㈠M L , i L L L Excel - ĞL i , Excel L ㈠M x ㈠2 i

3 xT n nê2 x L5 ĞL n x Excel ( n 5 L2) êxT x n n2êLL L 0 1 5㈠M xêT i n ö㈠ L L L - ĞL x L i x L5 LL Excel 0 ML xT Blank n2ê iL L x L i x nLg M㈠ x ĞMi

4 0 Create nL LL x êxT n

x0 x 5 M ribbon tab x Excel 2 2 LnL iL x L L Excel tab L tab i tool L x Excel öê M n2ê L55 Tx - Home 2 LM xT L Lg 5M 5M ,x5 x LL ê2 2 ㈠T M x xêT - Insert 2 ML Tx L gL 5M 5M L5L M 5L, L5 - Page Layout 2 ML Tx L Lg 5M 5M margins x L L5LL L ,2 - Formulas 2 ML xT 5 (formula) L 5L Ğö ,5 êM

1 ĞL x header L L x0 x spreadsheet LL i x x M ( A1, B1, C1 2㈠ 5xTê ) ML x x x M L gL 5M L5 5L 5L, 5xT L5L n2ê x label

2 ꀀ䓟 ꀀꀀꀀ ꀀ ꀀꀀ@ꀀ ী @ ী ী ী ীꀀ @ ꀀ ꀀ䓟 ꀀꀀ@ꀀ ɀ @ী ? \\?ী ী ਀\\ী @ী ꀀ @ ী ী ɀ@ী

3 ী ꀀ ী ী ী ꀀ ী ীꀀ@ী ী ɀ਀ী ꀀꀀꀀ

3 i Enter Txê ê0 x L M xT ĞiM nLê2 L

4 x 2 M x i L M ii 0 n2ê L ê2 x x 0 nL iL x ĞL i

5 ,x5 x LL L x L5 ĞL ê2 ,x5 x LL ( ĞL ê2 ,x5 L L5 0 LM n)ê2 0 tab Home 0 x nê2 L L nL iL x LM x \"Number\" L 0 5 n,x5 nê2 x L5 - 5xT conditional format Txê 5M L Têx spreadsheet ( ĞL L x êgL LL Lg L n2ê gL i M㈠ L 2 i )

5 (Formula) 1 xT n2ê 5 0 nê2 5L 5

2 Lg êM L L 2 L5 L iiL 5 x 2㈠ - L 0 =SUM(cell+cell) ( =SUM(A3+B3)) ĞL L L x 2 LiL M 5Tx 0 {{kbd|=SUM(cell,cell,cell) ( =SUM(A2,B2,C2)) ĞL L L x L LiL M - 0 =SUM(cell-cell) ( =SUM(A3-B3)) ĞL L x öê iL L L x2 - L5 0 =SUM(cell/cell) ( =SUM(A6/C5)) ĞL L5 L x öê iL L L x2 - 2 0 =SUM(cell*cell) ( =SUM(A2*A7)) ĞL xL L L 2 L2M

3 L Lg L L nM㈠ x M ĞLx L xL Lg L L L n㈠M x M ( 5xT LM x x x M ) L L M 0 =SUM(cell:cell) ( =SUM(A1:A12)) nê2 i M ,n2ê i

4 xT n2ê 5 ㈠M ĞLx L 5n2ê M x ö㈠ Insert Function tool ii 5ê0 L 0 nê2 i 5

5 0 Formulas nê2 tab iL x L L Excel

6 0 Insert Function n2ê LM Tx nL L i x toolbar Formulas êTx i L L ö㈠ L

7 xT ,5 êM 0 ,5 Mê n2ê L L L 0 OK ĞL Tx 5 gL 5M L L tan (tangent) x êxT 0 ML Tx TAN

8 5x ,x5 ,5 êM x n2ê ㈠ö 0 Lg L ( 5Tx xT ) n2ê 5 - ĞL xT ,5 êM TAN 0 gL L nê2 L L tan - L ,5 êM nê2 xT L n2 x 0 L L L x

5L M 1 x0 x nê2 5L M ĞL 5L 5L, 5Tx 5L, n L ㈠M L x x2 1 x M 1 xM L x L x M i0 M nL LL - x M nL L L M㈠

2 xT x 0 L L L L x L nê2 x LL L

3 0 Insert nê2 tab nL iL x L L Excel

4 0 Recommended Charts 0 LM xT ㈠2 x ML x \"Charts\" x toolbar Insert 0 L L L n ML i L

5 xT n x M 0 n M nê2 x L5 L i OK

6 xêT M iM 0 0 xTê nL iL x M L L ㈠M ê2 Têx i0 x M êxT

7 ê2 Txê x M ĞL M㈠ xTê M ê2 \"Chart Elements\" ii 0 ＋ 2 2 L nL LL x M n2ê xT

, , L Excel 1 0 File nL iL L x L L Excel (Windows) 5xT L x (Mac) L iL

2 0 Save As nL L x L ĞL Windows ĞL Mac 0 ML Tx ㈠2 File nê2 L L

3 iM 0 0 This PC L L ĞL Mac 0 On my Mac n

4 0 êxT , L 0 x 5 inx2ê L M㈠ Têx spreadsheet x \"File name\" (Windows) 5xT \"Name\" (Mac) L L Save As

5 xT i, ix5n2ê , , 0 i, ix5nê2 , spreadsheet L ĞL Mac xL x 0 x \"Where\" L L x Ğö xT ,i

5 0 Save nL iL L x L L Têx , spreadsheet i, ix5 n2ê xT L xTê n2ê ㈠M L