ࡱ> )` 8bjbj z0:t!t!t!t! " " " "(=(=(=8`=4=< "L=:>(>>>>>>BBB^L`L`L`L`L`L`L$OhQL "B1B^BBBLt!t!>>>>LoEoEoEBt!l>> ">>^LoEB^LoEoEH!, "bK>>= 0?+(=CI LTL0LIRDR4bKbKLR "K\BBoEBBBBBLLE^BBBLBBBB " " "7d " " "7 " " "t!t!t!t!t!t! Creating a Simple Budget Spreadsheet Using Microsoft Excel Objectives Student will be able to: Enter and edit text and numbers in an Excel spreadsheet. Use Excel to create, enter, and calculate a formula on a spreadsheet. Resize and format columns and rows of an Excel spreadsheet. Save and print an Excel spreadsheet. Getting Started with Excel Estimated time: 5 minutes Open Microsoft Excel. Microsoft Excel is a spreadsheet program you can use to create budgets, schedules, and simple databases, such as an address book. The Excel screen is arranged in rows and columns. Cells hold the text and numbers you type. You can use the mouse, the arrow keys, and the Tab key to move from cell-to-cell. If you are creating a document that is largely text, such as a letter or a resume, a word processing program is used (e.g. Word or Word Perfect). Excel is used to create spreadsheets documents used to organize numbers and data. Features Unique to Excel Excel has several unique features. These features include the spreadsheet, cells, the name box, row and column headings, and the formula bar. The following section details these unique Excel features. The Spreadsheet A spreadsheet is an application commonly used for budgets, forecasting, and other finance-related tasks that organizes data values using cells, where the relationships between cells are defined by formulas. A change to one cell can produce changes to related cells. Each workbook (file) contains three spreadsheets when you begin. Workbooks can contain numerous spreadsheets, thus you can organize many types of information in one file. Spreadsheets store data, charts and macros. Spreadsheets are made of 256 lettered columns and 65,536 numbered rows. Cells A cell is an addressable (named and numbered) storage unit for information. Each row and column in an Excel spreadsheet is unique, so each cell is uniquely identifiedfor example, cell B17, at the intersection of column B and row 17. Each cell is displayed as a rectangular space that can hold text, a value, or a formula. You can type 255 characters in each cell. Active Cell The highlighted cell on the spreadsheet that displays the current focus of operation is the active cell. The active cell is surrounded by a heavy border and is identified by the cell address, which is where the column and row intersect.  The Name Box Located in the top left corner, the name box displays the address of the selected cell. If you type a cell address in the name box and press ENTER you will go to that cell.  Row Headings Row headings label the rows. Rows are a series of cells arranged horizontally. Numbers identify rows. Clicking a row heading selects an entire row. Column Headings Columns headings label the columns. Columns are a series of cells arranged vertically. Letters identify columns. Clicking a column heading selects an entire column. Formula Bar Located on the top of the spreadsheet, below the toolbars, the formula bar displays text from the selected cell. If there is a formula in the cell, the formula, not the answer to the formula, is displayed in the formula bar. Activity: Entering Text, Editing Text, and Moving Around 1. Click cell A1 to select it. 2. Type your first and last name in cell A1. Notice how the text appears in both the cell and the Formula Bar. 3. Use the arrow keys to move to cell D1 and type todays date. 4. Move row 1 down three rows to row 4. To move row 1: a. Select row 1 by clicking the number 1 on the row heading on the left edge (the row will change color). b. Move the mouse pointer to any part of the rows horizontal edge. The mouse pointer changes to a diagonally pointing arrow. c. Click and drag row 1 to row 4. Hint: The cell must be active to move it. 5. Click the cell with your name (cell A4). 6. Click and drag cell A4 back to cell A1. 7. Select the date and move it back to the original position in row 1. 8. Double-click cell A1. Notice the blinking vertical insertion point in the cell. You are now in edit mode. 9. While in edit mode, add your middle name to cell A1. Activity: Calculating a Sum 1. Click cell A2. 2. Type the number 1 in A2, 2 in A3, and 3 in A4. 3. In cell A5 type a formula that will instruct Excel to automatically sum the values of cells A2, A3, and A4. a. Type the formula =A2 + A3 + A4 in cell A5. b. Press Enter.  Hint: When entering formulas, after you type an equals sign, instead of typing the cell names (i.e. A3, A4) click the column you want to sum. Excel will put that cell reference in your formula. Another way to calculate a sum in Excel is to use the AutoSum button. Select cells A3, A4 and A5 by clicking on A3 and dragging the mouse pointer to A5 (the cells will be grayed). Now click the AutoSum button,.  Unless a range of cells is selected, AutoSum will by default, sum the cells above the active cell, if no data is there, it will sum the cells to the left of the active cell. If no range is selected, AutoSum only sums cells that continuously have data (i.e. if there is data in cells A1 and A3-A5, only the data in cells A3 through A5 will be summed). 4. Close the spreadsheet and start with a clean sheet no need to save your work yet. a. Click File and choose Close. b. When asked if you would like to save the spreadsheet click No. c. Click  on the Standard toolbar to open a new workbook. Review Questions 1. What are some of the similarities between Microsoft Word and Microsoft Excel? 2. What are two ways to calculate a sum? 3. How do you change the contents of a cell? Creating a Monthly Budget Using Excel Estimated Time: 35 Minutes Those were the basics. As you move through this lesson you will pick up more skills, as well as practice the ones you have gone over. In the next activity you will create a monthly budget. An electronic budget is a great tool for keeping yourself organized and current. With an electronic budget you can easily update information as well as communicate changes (e-mail, disk, etc.). Activity: Creating a Monthly Budget Follow the directions on the Creating a Monthly Budget handout to create your own personal budget. Setting Up Budget Categories Step 1: Start  HYPERLINK "http://www.ehow.com/how_9701_create-simple-budget.html" \t "_blank" Microsoft Excel and open a new spreadsheet. Step 2: Click on A1 cell and enter Categories. Press the Enter key. Step 3: Enter the word Income in cells A2 and A3. Step 4: Enter the word Living in cells A4 through A10. Step 5: Enter the word Other in cells A11 through A15. Step 6: Enter the word Description in cell B1. Press the Enter key. Step 7: Enter, in cells C1 through H1, the months January through June. Step 8: Drag over the first row. Step 9: Click B (boldface icon) on the toolbar. Step 10: Drag over the first column. Step 11: Click B (boldface icon) on the toolbar. Step 12: Drag over the cells B2 and B3. Step 13: Enter the name(s) of people earning income in your household. Step 14: Drag over the cells B4 and B10. This highlights the B cells for the Living categories. Step 15: Enter Rent, Food, Water, Trash, Gas, Electric, and Telephone in these cells. (Substitute other descriptions depending on your needs.) Press the Enter key after each entry. Step 16: Drag over the cells B11 and B15. This highlights the B cells for the Other categories. Step 17: Enter Books, Tuition, Transportation, Medical, and Housekeeping in these cells. (Substitute other descriptions depending on your needs.) Entering the Numbers Step 1: Drag over the cells C2 through C15. Step 2: Enter your budget amounts (the amount of money you anticipate spending). For example, under Rent, enter 1200. Step 3: Drag over the cells C2 through C15. Step 4: Open the Edit menu and select Copy. Step 5: Drag over the cells D2 through H2. Step 6: Open the Edit menu and select Paste. Step 7: Modify your new entries according to your actual monthly expense amounts, if available. For example, Tuition for the months of February through June could be 0. Totaling Your Budget Step 1: Drag over the cells that contain your budget and the labels. Step 2: Open the  HYPERLINK "http://www.ehow.com/how_9701_create-simple-budget.html" \t "_blank" Data menu and select Subtotals. Step 3: In the Subtotal dialog box, ensure Categories is selected in the "At each change in" option. Step 4: Select January, February, March, April, May and June in the "Add subtotal to" option. Step 5: Click OK. Step 6: Select the Grand Total row. Step 7: Open the Edit menu and select Delete. Step 8: In the box that appears, select Entire Row, then click OK. Step 9: Enter the label Monthly Savings in the cell where the title Grand Total was located. Step 10: Click in the cell in the Monthly Savings row and the January (C) column. Step 11: Enter + and the cell name of the Income total. For example, +C4. Step 12: Enter -. For example, +C4- Step 13: Enter ( and the cell name of the Living total. For example, +C4-(C12 Step 14: Enter + and the cell name of the Other total. For example, +C4-(C12+C17 Step 15: Enter ) and press the Enter key. For example, +C4-(C12+C17) Step 16: Repeat for each remaining month. Review Questions 4. How do you move the data from one cell to another? 5. What is the AutoSum button  used for? 6. How do you select an entire row? 7. What are you telling Excel when you type a equal sign (=) into a cell? If You Have Time The next activities examine further formatting functions of Microsoft Excel. For these activities you will need a new Excel worksheet. Activity: Using Autofill and Freeze Pane AutoFill Fill in a series of numbers, formulas, dates, or other items The AutoFill function of Excel is a quick and handy function for finishing what you started. For example, if you are typing in the months of the year, beginning with January, you can use the AutoFill to automatically finish the list. This function works for numbers and formulas as well. 1. In cell A6 type January. You will now automatically fill in the preceding months below January. 2. Select cell A6 (the first cell in the range you want to fill) drag the fill handles over the range you want to fill. Hint: To acquire the fill handle, select the beginning cell in the range (in this case A6) and move the mouse pointer to the black square in the lower right corner of the active cell. The mouse pointer changes to a +. Drag the mouse down (or to the right) to fill in increasing order. To fill in decreasing order, drag up or to the left. 3. In cell B6 type 2001. You will now autofill the dates Hint: When typing numbers as values (numbers that will not be in a formula; a label or year for example) proceed the number with an apostrophe (). 4. Autofill 2001 in the B row to cell BH. Cell BH should be 2007. Freeze Pane Keep row and column labels visible as you scroll There will be times when your spreadsheet expands beyond the view of your desktop. For spreadsheets like these, Excel enables you to freeze your column and/or row headings allowing you to always know what column or row you are in. This feature is essential when working with numerous headings. To freeze the top horizontal  HYPERLINK "javascript:HelpPopup('xltip9.hlp','xldefPane');" pane, select the row below where you want the split to appear. To freeze the left vertical pane, select the column to the right of where you want the split to appear. To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear. After you have selected the row and/or column you want to freeze, on the Window menu, click Freeze Panes. If You Remember Nothing Else Microsoft Excel is a spreadsheet program you can use to create budgets, schedules, and simple databases, such as address books. The Excel screen is a spreadsheet made of cells that hold text and numbers arranged in rows and columns. Review Answers 1. Toolbars, menus, print, save, spell check, help, etc. 2. You can type the cell locations separated by plus (+) signs. You can also use the AutoSum function. 3. Double-click the cell to be edited to enter the edit mode. You can edit in the cell directly or from the formula bar. 4. Click and drag, or cut and paste. 5. To quickly add a series of numbers. 6. Click a row heading (a number). 7. You are telling Excel to act on what you enter, rather than display what you type.     PAGE 8 PAGE 7 Microsoft Office GOH d >?K9:luCD!<=EFRSabhJhVh:M0J6]jh:MCJUmHnHuj$h:MUjh:MUh:M5\aJ h:MaJh:M5CJ\ h:MCJ h:M5 h:M: h:M5\h1h:MaJ$hdxh:M8<G`! H d ~ ?K89;H888NZ<uC|dO#U^^  z]amr|}  {u{ h Y0Jrh Y h:M6]jR>h:MUh:M0JCJ OJQJj&;h:M0JOJQJUh:M0J5OJQJ\h:M0JOJQJhJWP h:M0Jh:M0J6]jh:MCJUmHnHuh:M5:\ hJ5\ h:M5\h:MhJ.TtT}sl !S!!!"?"qgd Ygd Y^^ ! q r !!!!2!8!S!Z!k!p!!!!!!!" """"#"?"F"N"O"q"y""""""""">#F#######W$_$$$$$$%L%M%N%c%j%%% &&7&>&e&l&&&&&''hJh ho\h Y5h~|h Y5 h Y0Jr h Y0J"h Yjh YUR?"q"""">##W$$M%N%c%% &7&e&&&l'''L(()')M)})tgd Ysgd Ygd YqgdJqgd Y''''')(*(.(/(L(S(x(((((((())').);)F)M)T)}))))))!*)*u*}*****7+?++++++c,d,-- /'/t/////0ľܮܨh:M0J6OJQJ h:M0J h:M5\h:M5PJ\ h:MPJjh CJUmHnHujAh:MUh:Mh~|h Y5 h Y0J"jh YU h Y0Jrh Y;}))!*u***7++++,D,o,,,,v--- /q//=1x1 2P22  h^`tgd Y00=1P1W1w1x1}1 2 2P233444 4555566888888888888888888888888zzvhh}?0J mHnHu hJ0J jhJ0J Uhl.jhl.Uh1 h:M5\h:M0J">*B*phjh:MUh:Mh:M0J6]h:M0J5OJQJ\h:M0JOJQJh:M0J6OJQJh:M0J5CJ(OJQJ\].233\44@5A555I66666b778(8K8888888888 ^`88888888888888888 ^`!  hPh]hgdJh]h  h h]hgdJ &`#$gd8888h:Mhl.h1 0:p"#~/ =!"#$% n%OfÏ$-PNG  IHDRċ}sRGB pHYsji!IDATx^]y8-!-%ri'sS a)" %) x<>Tm%$Pr_~MڋTNjsq+j:w>Tҧ(Hw̻¾W%am8U y5s@;|ʓ y|`ߓ迪Lp`,pbk5QOP v.@!IJIB{io3mSkS=6Mⴆ1#JaZM< Y@ʗ0=ɫ3wP߃x؅7` &k??;hcak)~p |zz:wМAJ8=]2BSg=Y $mnBǏۋ-iRC[EZcve-Ӥ]/W'U5@+fS>N)NEq%05qT fBTa-V9.R)gM˻.k@&{Vup5ܮ5uJ?Pݐtqn+,/Gz4JmUљ2&Wq ,nr DIKּ5vIq$%p?ޣ^IT`?P{%tx2uRj>T@Y%{P@^Ig5>@U/hQ?j 5aSj P"oŵWՔ۪'WwG%fVY%+AZ\E|K _!>Fd*-Ew%tQ{|-o?Ѱ6qÏ@ٷt}z~Q'n+ 4Zz=t}Z.>^k$nIxxu6pV//c(6NZk H ,lĔ4Ք>)U?!Q[&B LdYg2uAQ5pɯ&YbJ*Q`ѻK%[?4[#HKlYhh=ZF^˒45C- t)ޮA!]Y/!)i(.xiZ?|q,Xrj4]:RtTUHk'uc򵵝VD1 L#~mj-kIE6n_mI;$Spn,XΡ:qc?]e?7[EvRp S)x <#um}V9v0%N#|8@_r94:k@,5w^Z[6U;|k{YdIv=Z(nO~ȟ5+h<ږ'3~d_Ek/Ѕ''dٗ4?ezbs|M*sCZbs'4>[)Z\[9i`c% _*[_ߪ\B2R~#Swh O\lU?`Zm (e@l46*DB_7t_(ʰ^,=^[άeMlO->ZXg"St֩킕~+1Xy1x_ z/RvuCߢ>dk>}1.ySz9)l}{XJ^3^-a,+Œ\9_'~½"-|.XE|,!- P`{ב"zC)xv#b5bK_5_<w$8]Ta~~!k[.\yFm_.Co/pTy[7.rtD,I\/\j; {sz4-[X`d^>=mΌz#o̗n+Z1IQ'OkoOX}]j|t[`ދ򵏯}V>"E2N;qh3QI/Y6̠DЉn Lu@ϲ W&*k`l"zOsv=VJ8 ]bL#4V+mmpI\qaej vVʔLq]#HiڜM(Z #+ո}ER7Vp'r Q4ҌYo.Py+ @۫_[׻Vxf=5,0Ws0ܬf :󗗺1{ ~~./O) Yդijb!sd-cKGʯ2Zrz|+:ʧgи]f@LYC̷tK12ύqQYp:R&?a.%`6_{bnVk;׹$6efwx{_pmqc-| ?-Ty E6_ƫLI_b|m؜ӧWUϰ$;fޏ?KW0W Sax_bO'@8&^ݬ^=iml+z5Xwy%a1e{@ځ,ݷ.Dve_kPPY̪"ـU7@p4Fv#i5t5zG#{{X$^ɐ:nƒ'eqaۍ 䁡8јQpHyq܎3SL4WJ? XbO(:&ucZξn⋚__~/H~3 ƾư }|ZrcZc_c4<s=vhW~jp<^^%I6[w^7:2Úb  ,{L! ^oq}92[( 1S]p:Aw.bik!8/C{9'CƋ`{uoY29`i~ީA"Prm_=_[l_~mHݙ_0?&օϷւuPow Ne3k%TjZE ,QmCZ9R^lQ eYMM|)Zr73\EE7461@RXN4kQ~ ]- y]|lI-Lcx+vV MC ;'Ol?;"ĘmYN~mQFVɬ˜)Ya 1ܾJ3-wk7hEh.BU: w ɯ-s~pAdhe?:Z!yVsIENDB`nW@ ) 4Vkִ Յe,Q$mc=lcjQ+dY"YREA4 f}O$0@R?bwX;)NNl l(uR* ַghtgAwTKh3b(4KV* F[2#o #)PKԞK[7! ^#׏X+^ 0N0 -AK Al\ V>>>JYo rQ.nʺh? 0(P~/m$|̍ ! ԪFZ 1_DTEs=]b )cI" ^(}X*3'/6Y۾feQ>ӭX5+\60_݈eyji.}swcRYKY0w8o:qh /W?+_,6肈|TXlF(bˮ?hKG!`MTbw (HcbkOmRD&Ȏ݅\EEaE^ˇpaW:8mjp&D䋂nq`E$ ^> '0!8EA 0&NsY@$#61.ϱ4FcѷxG=Цq\7 QxgDp@`F( \DBF 0B# 8q"ڀJ:Gcad#!:0Bm@`18}"(ଆ1)◗0P8 T$ b %YDX BgH!}xzIENDB`n Kr@PNG  IHDRaygosRGB pHYs+ qIDATx^;r6%ǁCgF6`iٙ]el> Ƨ`6?@;x{{+v 6wo</];?/WuON 4],@& (ӈUc(9z4i?~kIŰx~E໏:<b)88Mi҈fP("T*fo<>шt>f0h)E\cj/>w\R}2SWH` hH i΁2 Јnf4/L. t`s 4"ZTw0J <\hofDQhoZF4&R;kN&ܧptb)EF@#2(G~ -#xz 4"%-!ЈH1>7ϏQR\@Q///E )tP sF:A#<&/?R:6cG$$6v&# HՈ+>>>:m`/݅;klX즑˛)`_*eIqE BG'R~vEdEq{9nNY$0hT-F(Wzܵ<\ۯl˲F=tWPݽ*7RhuG9(t)tlӷyix:=7zWxIYD>\ L)HGTO\\n= bV6/˃ֽ#`d?'Xeh1-kSGT$TnQ Eʦ^D7ǵ;=0r:ʍO}z4EF:%-^ /p6sio67) arsDc9 Е^w"'4tt>:y֩|f1/Yc^6D<<$i_04d[–4*#jf y5(80eݧi%>=T6,݆QOشG@~Pوf5QWlBZZ2C3}+ 5f#Pc͎1# 75NdF5[&]65fdF"kF 3a&R@Fa3UHAFScR66$gk@F ӊ+9<Y#N"G9^! k h'T?½j ! ׏/Yц/@@;5f}acᰆ{ڀ(%J#m@ 4 =΅}Ԙc"%ԘLߺ&yėϟ.Lpoo[)kP=GȟIwN@ֈ7x쳤! k⪱q?;] B@F ex72B X& ei{LzDXK}W(! kDai͒%C7; `Y A L@^L6EC@ Y#\5f dBF@~0ʑLakd1@9ЈZ|13_ΉY1Ck~ی`j|PTjd`7qY7ŐV. S}&:Ŋ 0#yRr<3ӈp @F% Q7 p@% 35f<LG@  f&F̜}bL`32Z@&k0 DF$ `a2b1S % `5f13N5Z+z_JY wIENDB`$Dd 0  # Ab#@:?HAFׯm#Dne#@:?HAFׯPNG  IHDR}HsRGB pHYsji!"IDATx^]yζUԂRB[osJwm*$ 93gyD<Hb>Shmީ6ç?}G)?{z Ō}x.ͭs_ZFV.O/O/ϔJmDZվ<>>U[s`!~[X\!]4 4},Gw!t i~{{#AO6MAejqeU{΁-9p}.~nR-^U #! ی>\y5bM@ICts* B~i-&ky6.m\[W"oJxG Lf9Pp0 "Jp {KH0d@$ʑ֡93C~I 5HFyE.1ƖCP3 Y-A-q)BSa)Rx4 "fΓ}BXXUZoXR(V!81Aܯ-h=)p 3If{&=)/{1 FJAA+`jn NrZLUL@oORtGnH 9hVt,#¿̦Vc(yu^$Ii:)4S@~ΰH+8pA٩olU!h Ĝ';ԥkKq; jP@@oK=([֛ȁ0!f{!c${{ԯ6m#mN^ڙ6)9|P@tRo=vRHrސ1<o߾!vw}ȂQ|E (o&mt.*cw%ݣ4ʢp8j3FHoA?(m,2Ɣ2I[P__x`O&NJehl B;.c#m t(.tJOL*B;c~p$6AF4c6JVx{@+Ԯ)IB=NsHr9s<_~M12+GwO&9MM+CD9e5UI_,b]УX,\R+7*YW3(8n:F`xF?An:]Ơ?cŁ￿|r1if L;PЇlK?C/ز<ٟ9XkUEO clOsU=pP:] p`(kZBP:C3j6G]-2;˶}MY;i"dR[YϪoٿb0snp 9KeLauA1,)%LkpWxj3SyY(~Yk[6dsz q^"XM;# rjzX-X_Ƀ'&_*w`bnWO_{7@xyyLC0u v-W߄O򓽑l[ĤJYC4>,OY[QȘe8;r\L8gMEIŸgjLH޾lPI4/6Ba%!3CM-8 M=\umne){]dB9\MD8Z&3Ro`.) 13z %bS|Ʈ$p6T(2%-Qs'^#Z.COa3K ÑZlj)ӾXKlɮN&)V蓩!*Tc%5jd+.6QYJeV洟j;2Dc=sx6&:8& @EI]*7RAD%ETp3 h "Z`uD8K8JdE03e W ʒpHaK&)F/sI J4赠$́5H]%2ZhL-,^A~g,XtHs)ΤA2E$K (HjbHį+1E}=E$i)?<<'3; b޻خZCvI:=+twNf,*ԪMwMBFwtED?Z0G 2Ew<0ݨ xe,S~ѣgAk2`YQ au&M񦌪+$8@ID:aKqI-W .M3; =~.푿I_ 1ᶁ>icc_k@X"Р.<HXyg4<(TBLiĀC$axٺ!o \XA!׌. @Ra؆}"5=SvHC=U֛,"3Ӑ8Xxo9QC{:21P0:らKAs1Jt3>e"K#K4%ml%ޥvH˰د&ljiɲ9NJvPG x *@G s =!)rY)8qk4P')Sh:><԰n2A-sb_lXc~$̲ow/Sp{2*8L̺8kl:\0R g+jmZ-\Jisג.ϡJW<oi^Kԍ Kb=Gf76&#*v8a2UF٦->?=z?ڊڝ3QSEܭg̱;{ i9b3>s$)S #"1fDa)`.F0|oo\&b. Rك50aH0(=T酂.ز,}ҰN AAclG 9t/Z^e]8"aoҐ)Te ,ul^Ҍ?(r;).d09|y]X?e]B"liOZvY#؎B=ˀTx[>D6n:Ž>M6Gh,813nn;dkϱxUK]Y rq[i-fn:Lqg+mom Vn aek8 bQ?͊>S<٢?g.,dNGcU,Dlޝdǘ|-ߓ6T/9T*!57ֽ+q$3dwjv74ÖtU( Pa{ot 2)bD-HT!BOUŖmFFW,׊琪JaQ43,;ˡb Sy֛ 7ZA̢zДRS4L { ײ ]>2Klnm^H%S2xP 2iQq!Z35yg6<D02g3<rfs >V?ȜAAq#@b~ _י`g"'"Q4R+Ќdo%z8-sDںAP 9wn"Coݏ꯴ځf`%V }V)+__C0ELSzOuȊʹ Ѡ-Yjmg#ӳ!vǟR( Ӈ愄c1*X!`hT4OբU뒽nm5Y1Gt)z~S.4heRGqf/OKB! 3<c>GcЁ2ε>!MߛwTԄ4>GI2f6꓆יӳ5\O _ӯمU+7wI7E+ ١Lf`"Ч{~τ_ ./n-'?*NE#b/B_ᯌ/쌴H:\?^"}"q7j_=8//\U>3"\F}y$-T HP<¶~AX8ouTf ߧq@r>_ÙCxb}uT/ވG(lo,FԊ u2kf4 yk؟Y5JE7ɗ7R> _I< 3^g-eܖg&ր-Nw7DT!2M#1P:'DM1϶Dذ?Ђ{9g"Y2Ʃl1oT!s*>`uCdy_AQ2k@^qf{:|wV7Va2,A ̢cG1Ȼ{0"{FlTy Omğ^miAyU=M-0w5?h96sTnK_-}4;.q 8}vh;"3Qĉ;^}Yw <\92xqQ25P*:SڥO^}} hwͦ<^’IpvL,VCO.b{{!rt|t% )f^ͦ,Ebja" 30Ɲ|,vo>< % {ʸ2ugu#O٨ WgՇsJ?d W_غ烗&g9ѹϝU#gӸOsҪ`+<rKCbEH=hَ79&nG풚c]d]CWAʱВqKe@G܌2dniB1NARpc]zlخа VlW(zPPh'pUհp 1 MOc ._>}~B:>3+JM6Dž}2cNsƐ"ג0}8=B ,)G㤩20h+k7 ܍O@uܹ?w<:shǺ9^#û9٩:'|[=AW N=vJH.m@zı9'A (cc+?vou;h1GV?ǴDt 􂽁N烨̯Yk"Xq `tQS?(&1B >r(Ad_YEDWF:?ޣOԇjܠ?%x^Qeӛ8!A쓪3-(WtKs5-F?fg9-(mދ9$-Q$}zz6Ns;Fg7nmsVbw=i4wowU LƗ5!'Wꌰ(B [Ăyfi:0"ZM˗gjjBfsUk0Z[3ϒAМ6K*9,lr Hݏ?h3] (vuifŰ<]̬̃ڎ˭D[5voHaç<8hCҕ7!'GN;p2ԁkڎVdȜgӳ'Lʢ 핒Ŝ^ħqD"wfߗ)ܩHqsC]SOҖALs'ր'JOk)[T×@I`O',5c7lGHAEpN:?pN:n/b(vSՄ ϻ6H(:e'b +A `ѩ=[q'=h;6!}T12&=MXePvS8A1C}mS Ez~O?^/\.tLA=Uׯg\5(g>sdbQޠD1e1B‘q6%C 3hjt-_^! q0NkD!?5mܛ_Cn bMdK7_ɨ[&*VE)PbUn\Ìfxh"3i@>Ze@gcZul,jd7DVQY:f?~qFF)d@Ѓh] }F0Vmn?As/6/zYYC :*!]Uz!4,o-as5Ⱦ?}|00f򁍘re9oGp>E@# 5|0u@# yRʝ᱆Z: OJz| C $?zA qs8$ߛJ%綬ed@;v+l'nX on[!YF6oQ @>*d>|BAaj'XAN.yXWeh%) ?u̇vO(]1 ]v`79.*ۃ@M pGv'U@*S7˷~2'Ly>CU)dP^jD|1(oܮ@ط;-h*R$SP!)hw;ܩA8( lipbpo.> .0Kn/wdwndiᴚĄ΋nKٻ ! $35kX`cf5kzWon>_v&nFN3lR51!V꫃Srhv`yuz@ќX[ =pNΜ 4Lm'0h71o`)CقBQI[ZnV?0x**-څ :{^E[QÀ9)Xvڮ ɹ^-$Ovae8iAMX-ە6:zF=r)Euc(M߃Y&e3P7K b0v-:y#dZC^_BʤoGT%--CХMуդa/DWˤȁ{mN J 4ͯw |Q55UU:7v;xS$=S>љfc컧2xWb0\wϵ*g+! nj;ܑ6ك1 ٩nma%K'.+-! [vbXaREp?"j]A /Nu GIH h 1q!1SgV R1 fVgUim4背)Tn)ML\9L;W AȫMR1&;g ? M.Q±) 9^9Cuu#i/fDs`uDf?ޗY:#[ 5n6ąlUX3<*Y(bz*.UWl60b+fK46c@B:>-MKQ7aq F80w0ApOԉeLrًX}{PL>' ?0e*R1U[H}ov$U2r{R=c(T70 O˲Aeh]^N#g`x=%piKӭ>BxO8VDM 8`HsT KCiRvS٪#Yߠ<5kr|v}4 ȱ.#gfM׾)sÝtVvlW 7 IIv{^ 1 X&%ťnxJ1Qv-kԃ.d2UL\SL4.,/CȵLBNvv!X &'\"mA\| Iw4Lk ]rw$nwbBP6OɱL{Ih˪JRv;"hD-_ZUV^w/1 |5~{P,і˫} 6]ƿhZ ERL6>g߼C}xW.g2Dz(8p?1aӏN6`hL0 GV/Sf iH%sUuTLćON/)qWUBp\G 0F>C &3{C ooߐfҽ7\٩w/HF_yI؜I-pQݦ*5ݥ?!_1or:[ X*Fjڻ%K}o2n.Uj=i79|}vG* A>%GAɣ2{uoπvbpI-t7q?\R+n52g~1)-aRıZK]Tdۚ~d{_/sNo_H3_f! B\R!vT_^2v%*C IENDB`,Dd 0  # Ab- )ثF)3JXj;n|- )ثF)3JXPNG  IHDRb sRGB pHYsdhIDAT(SnAEfg)@d6 8Enx1161$6 y!¢UEwwKKpnNs0Ȳ|^!|>_^O˻n>;dDhfTjji3.K6bj`3V$xP(?2 U*Hh/nH(J$hW#[!$U?nn`0yV: 7Fz~~t0f:z^:l?)pF7 r mFCzv d}{(t, 3Z2BM&j}NW<`!{ }e"WWiAj-n*pāddld. $h48>mU71D.f`` _g=:UQNX|"|DBD8HIfH$LLdH!T*VE]l0X,&|!O xYsx/?In՞IENDB`Dd 0  # Ab"[{\ KI6>n[{\ KI6PNG  IHDR2sRGB pHYshi\*IDAT8OURN@Nϻr \\&h|5DI 0*{)lN;͒LfN?>i_'-bt:Rʭ͍XȼΈRʲLZ;^{wpp4MQ`Z: 9B/5\x3.k]?JI(uzz!&Ϸy<LWj 'hc,16_,UmFJyy ;;֒ hhZȗ6w\ C}_qg5iT+o n7j[CHo7ߦ-; ,IA=!gҺMc0\.%RwwwS5c b 2F<"ZM!_`ABIUAT)!@^mx< S؅ n\O p8>(UimUS,X+pZ@QEn/z3-2I" jEURਪJ8(iWR[ O&&]1!7юP HZL0u}3Mog(N;<!ͭ-<-%_^O˻n>;dDhfTjji3.K6bj`3V$xP(?2 U*Hh/nH(J$hW#[!$U?nn`0yV: 7Fz~~t0f:z^:l?)pF7 r mFCzv d}{(t, 3Z2BM&j}NW<`!{ }e"WWiAj-n*pāddld. $h48>mU71D.f`` _g=:UQNX|"|DBD8HIfH$LLdH!T*VE]l0X,&|!O xYsx/?In՞IENDB`u@@@ NormalCJ_HaJmH sH tH Z@Z Heading 1$<@&5CJKHOJQJmHnHuV@V Heading 2$<@&56OJQJmHnHuT@T Heading 3$dHx@&5CJ(OJQJ\N@N Heading 4$hP@&5CJ$OJQJ\R@R Heading 5$<@&56CJOJQJ]H@H Heading 6$hP@& CJ OJQJT@T Heading 7$@&5B*CJOJQJ\^Jph3fP@P Heading 8$@&5B*OJQJ\^JphN @N Heading 9 <@&CJOJQJ^JaJDA@D Default Paragraph FontViV  Table Normal :V 44 la (k(No List B'B Comment ReferenceCJaJ88  Comment TextCJvOvtabs0 h@0d5$7$8$9DH$^`0#CJOJQJ_HmHnHsH tH ufO"fbody hd5$7$8$9DH$^h#CJOJQJ_HmHnHsH tH u`O2`Semis5$7$8$9DH$)5:CJOJQJ_HmHnHsH tH ubOBb Q chapter head dXCJ8OJQJ]_HmH sH tH ZORZ Q Text hhd`hCJOJQJ_HmH sH tH DOQRD Q Text no indent ``Ob` Q Head-1$$dHhx5CJ$OJQJ_HmH sH tH JOqbJ Q Head-2d@P5CJ OJQJBOqbB Q Head-3d<6CJPOQP Q hanging indenthP^h`DObD Q hanging lastlineP>OQ> Q handoutP`6HOQRH Q extra info`6HOH Q extra lead-inCJH*OJQJS*4 @4 Footer  !.)@. Page Number4@4 Header ! !6U@!6 Hyperlink >*B*phDT@2D Block Text#x]^2B@B2 Body Text$x<P@R< Body Text 2 %dx>Q@b> Body Text 3&xCJaJPM@ArP Body Text First Indent '`HC@H Body Text Indent(hx^hTN@T Body Text First Indent 2 )`RR@R Body Text Indent 2*hdx^hTS@T Body Text Indent 3+hx^hCJaJ@"@ Caption ,xx5CJ\aJ2?@2 Closing -^$L@$ Date.RYR  Document Map/-D M OJQJ^J<[@< E-mail Signature0<+<  Endnote Text1CJaJh$@"h Envelope Address!2@ &+D/^@ OJQJ^JN%@2N Envelope Return3CJOJQJ^JaJ>B>  Footnote Text4CJaJ:`@R: HTML Address56]Re@bR HTML Preformatted6CJOJ QJ ^J aJ: : Index 17^`: : Index 28^`: : Index 39^`: : Index 4:^`:: Index 5;^`:: Index 6<^`:: Index 7=^`:: Index 8>^`:: Index 9?p^p`H!rH  Index Heading@5OJQJ\^J4/@4 ListAh^h`82@"8 List 2B^`83@28 List 3C8^8`84@B8 List 4D^`85@R8 List 5E^`:0@b: List Bullet F & F>6@r> List Bullet 2 G & F>7@> List Bullet 3 H & F>8@> List Bullet 4 I & F>9@> List Bullet 5 J & FBD@B List ContinueKhx^hFE@F List Continue 2Lx^FF@F List Continue 3M8x^8FG@F List Continue 4Nx^FH@F List Continue 5Ox^:1@: List Number P & F>:@> List Number 2 Q & F>;@"> List Number 3 R & F><@2> List Number 4 S & F >=@B> List Number 5 T & F l-Rl  Macro Text"U  ` @ OJ QJ ^J _HmH sH tH I@b Message HeadergV8$d%d&d'd-DM NOPQ^8` OJQJ^J4^@r4 Normal (Web)W>@> Normal Indent X^4O@4 Note HeadingYDZ@D Plain TextZCJOJ QJ ^J aJ0K@0 Salutation[6@@6 Signature \^FJ@F Subtitle]$<@&a$ OJQJ^JT,T Table of Authorities^^`L#L Table of Figures_ ^` V>@V Title`$<@&a$5CJ KHOJQJ\^JaJ H.H  TOA Headingax5OJQJ\^J&& TOC 1b.. TOC 2 c^.. TOC 3 d^.. TOC 4 e^.. TOC 5 f^.. TOC 6 g^.. TOC 7 h^.. TOC 8 i^.. TOC 9 j^FV@F FollowedHyperlink >*B* phJOJ lt1ldd[$\$B*OJPJQJ^JphHOH ntmdd[$\$B*OJPJQJ^Jph<O< Q User Input CJOJ QJ 2O2 Q Bold Text5*W@* YStrong5\>O> Y part0 stepqdd[$\$"O!" Ylabel>O2> Y part1 stepsdd[$\$>OB> Y part2 steptdd[$\$00 V<G`!Hd~?K8 9 ; H  N Z < u  C | dO#UTtT}slS?q>WMNc 7elL !'!M!}!!!"u"""7####$D$o$$$$v%%% 'q''=)x) *P**++\,,@-A---I.....b//0(0K00000000000000000000000000(00000000000000000000000000000000000000000000000000000000000000000000080q0q0q0q0q0q0q0q0q0q0q0q0q0q0q0q0q0q080s0s0s0s0s0s0s080t0t0t0t0t0t0t0t0t0t0t0t0t0t0t0t00000000000000000000000000000000000000@0ȑ00G@0ȑ00G@0ȑ00G@0ȑ00G@0@0@0@0@0@0@!0@!000}ȑ00lG000ȑ07S?q>Wc 7elL !'!M!}!!!"u"""7####0000000000000000000000000000000000000000000000000000000000000000000000000000000000000 00  &99< '088!#%'*?"})288 "$&()8 q) . +,,0XXX  "<!!"#b$OfÏ$--3Vb$@ ) 4V<_`kb$)w7nd b$b'RC:3{r$ n9 q&{b$$L21ȫ Ab$Kr@ pb$@]Yg[`)Tahoma?5 :Cx Courier New#1Hh4&IE11fBa)XBa)X!4d00- 2QHP ?"#~2 =Y:\Curriculum\Modularization\!template\CurriculumTemplate.dot,Creating a Budget using Microsoft Excel 2000jasondUser4         Oh+'0 ( 8D d p | 0Creating a Budget using Microsoft Excel 2000jasondCurriculumTemplateUser14Microsoft Office Word@bj9@@W@m;+Ba)՜.+,D՜.+,l( px  BMGFX0' -Creating a Budget using Microsoft Excel 2000 Title( 8@ _PID_HLINKSA~r0javascript:HelpPopup('xltip9.hlp','xldefPane');B7http://www.ehow.com/how_9701_create-simple-budget.htmlB7http://www.ehow.com/how_9701_create-simple-budget.html  !"#$%&'()*+,-./0123456789:;<=?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`bcdefghijklmnopqrstuvwxyz{|}~Root Entry F?+Data >$E1Tablea-SWordDocumentzSummaryInformation(DocumentSummaryInformation8CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q