ࡱ> RTQ7 \bjbjUU 0n " f Named Ranges 2 Multiple Graphs Open Excel. Select File ( Open, and open Name2 from your floppy disk. In Cell D7 type p, in Cell E7 type q, in Cell D9 type 9.7 and in Cell D10 type 8.4 Use Method (2) from Producing a Column Range of Numbers on the Named Ranges 1 Exercise to produce a series that ends on a value of p equal to 15. Select Cells D7 to D28 and choose Insert ( Name ( Create, etc, to give the values the name p. In Cell E9 type in = - (p^2)+8*p, and press return, taking care where the parentheses are placed (due to the minus sign). You should now see the value 171.69 in the Cell. Left button mouse click anywhere on the worksheet to return to the Cell edit mode. Click back into Cell E9 once, position mouse cursor over the Cells fill handle and, trying not to move the mouse, double click the left mouse button to automatically fill the remaining Cells opposite the p range with the same formula. Next, highlight the Cells D7 to E28 by dragging the mouse over them with the left mouse button held down. Select Edit ( Copy (or press Ctrl+C). A flickering border will now surround the selected Cells. Next, click once anywhere on the previous x-y graph with the left mouse button and select Edit ( Paste Special, and then fill out the resulting Dialogue Box as shown below  After pressing OK a second graph of p against q will be draw, superimposed upon the previous x-y axes. Notice that, to remove the flickering border around the previously copied range of Cells simply press the Escape Key on the keyboard. An Interactive Graph In Cell F2 type m and in Cell G2 type c.. In Cell F3 type 1 and in Cell G3 type 0. Highlight the four Cells F2 to G3 and then select Insert ( Name ( Create, and click OK. Now check exactly how Excel has stored your names. In Cell F6 type = m*x+c. , NOT forgetting the period after the c, and press Return. The Cell should now have in it the value 10. Using the fill handle in Cell F6 try to copy down this formula using the double click technique. You should find that it doesnt work. This is because this new column is not immediately adjacent to the x Column. Instead simply select the fill handle keep the left mouse button held down and physically drag the formula down, stopping at Cell F31 (Method 2 from Named Ranges 1) We now wish to plot this new function of x on the same axes as used for the previous two functions of x. We need therefore to highlight the non-contiguous ranges in the columns B and F. This is done by first selecting the Cells in the range B6 to B31, then with the Ctrl button held down, select the range F6 to F31. With these two non-contiguous ranges selected press Ctrl+C or select Edit ( Copy, then, in the manner similar to plotting p against q above, click on the graph once and then select Edit ( Paste Special, but this time choose the options as shown below since this time we elected not to give a title or Name to the data list. This should draw a third graph on the same axes. It should be a straight line. To make the next task easier, select Tools ( Options( Edit Tab, and then uncheck the Move selection after Enter Box. This forces the current Cell to remain selected after Return has been pressed on entering a new value into the Cell. Now go back to either of F3 or G3 and alter their values, pressing Return each time to enter the values. Observe how the graph dynamically changes as the values of m and c. change. To Alter Graphical Settings Position the cursor over either curve and double click the curve with the left mouse button. This will open the Format Data Series Dialogue Box on the Patterns Tab. In the Line frame check Custom and alter the Style, Color and Weight as you wish. Repeat this for the other curves. You may expect to produce a picture such as the following. PAGE  PAGE 6 YES, type in the period symbol . too!  :;  $ %   / $% "#)*+,-[\ﻸ0JmHnHu0J j0JUjCJUmHnHujCJUmHnHujUmHnHu6 jCJCJ j>*CJ 5>*CJ(: !jkVh$ &   / 0 \    l0[ !"-./0XYZ[\&`#$301hP. A!"R#$% n&}ym,܈UPNG  IHDRJ:QsRGBWIDATx^]iG! È `!dY!l b cp 802l6 hZ9Jjͪꭾeee~Y_eVo;99 !pҥ\C@k}٫Wƍ]8>>Wn7|\rPhh%=o$L(2* "Of}jȰP J{Vc:ўTϽJk 0oJAe-# douFQF^|~,7/ߟLA+do=huY1ٟMiggGgwwӧ8r_ {No~!m~y zf.\&䯡^k7w4bJoḞ~T0.SWQ%@W\1j 05K=biXЩ5aG:ExG=5vVzƓw^첛;zwذ>,_y+_? ;7#ʰ|_ ;f/]o$@SMMnp ymvߢwo6of>߽g`=뻿o9Z{_|z~#ߗexa/ __^4֯N!L 43Bz|/{s}{O^`({09ko^mܜ zfQNsv{}ה?'|xwR@`JDWv{B.^ Lqnv8wMe̹̕I1S74,@9iHfX{w +p:MT_:+{ŹHZgp?~d9e|׻֦ zpS}2/Ts|㑒Bez&SscGFwx;k0q2& A .@uo/X 23(Xk@wXB^W`-@&5OKcI>U]3.lzg=vh*lJ3}@?#-Ȧw #s{h=Qi 7)Ǐ֪ۖսBVKC|{Z"3Hr6M8ރ2RbHWEswbI3 `IJ V[/n$ԡ_0k]{{;FGJ)Zf6sёTmxuzK<5 UF4/_.eVn|AYPm`2-{gvwfuGϪ,fuNp-sIo.ְY"yH?W73 WJ-"rrV`.#5X^44%gggU 6[{95z5XE+#Ɇ Q=p^ G븫-~\l K\F4s1%,I,0E5,WI ""- EDf0~z䀘/yиjDG "1& (kf\:1aZxR܃0=i\oׯL.)M ,otD!O ԄSwRUI;j./\BoæKyIf[50%s柤|WI̠Oc0{}Ҽ6hk""IG/l#PRςm36Щ$ـkpB`5FEE @`5ޫ  \v  "-P]Bz0xDd9X%%׽yG*=4foe˽roeE.z ,:7v6Րrxh-\uL2"d=h0˼.)Qxu}^"yMp-uSZVh.7+Z7qu?DW7/YV4=k^*^‡>K1y[%[vєC{6<ά#ܑ{{c4{=͊M8u\ODo7+rS?~/R[,1xqa6MuŹs}YhգЊCpV%T=(dy17kk(-س>ҹrL\m^9fg&]۸7o +Kr+BmTUMr#"ӫ uD\˓˟Jnka||y@EETUE3 2Y"qL.z%Slb慆/rS@HOY/[`IfP4/E0"/"\dΕG4~ S,dGʞZL#DEI%[AԤ7eWk+kCM&faaĚ$IH!TlRҒ B3VGF2y `hNoFYUoB5>Icis@Q*{ c@Mz( k+lb%deq>`y05>ݵvxx{7k8k (LݔzeSs*m 6@O5}b"zEb",Y] \R/EZpU)o1KUgΕokYݕgɨ+)n4@-#W76*b8nCAޚuָ!8XfKk#?#XYGLi5dghbo໙qV$4Nb#'<"Mog/5o,G>+i_eI=VZf#9*ׇ#Vqq8'do/:^BXǭ@xqJdUy`8b5s,-34' 4c*0o] !5z(\wHF枾N|" OG402(Bnb՚4HmwwOGd%5S=oMmdLhTz$fHwID8K.$`Aԩb4а7g*o2/TBYU5F9&d.@$t+X ;YZl-p#"y%M-##zjPݩ p붋wZ"myu[wHkNJ?wt~L2+yE0ZTBBÂK K|،&9iۖݵ]9}vƷ<=J"M-ghւ{CxU4nkP5#M=?J XЙW>b@`ޛ -7,fC ǀ161 0X)W$EqPNG  IHDRJ:QsRGBWIDATx^]iG! È `!dY!l b cp 802l6 hZ9Jjͪꭾ~23_u6 6Kvs xg^zN7nt B>z_rp|\rPhh%=o$L(2* "Of}jȰP J{Vc:ў{׸#@`6,Α:G ZF*<Yn_?Vz  pSb?]V+)Ύ<3Oq._6ZCnf=/pś[koZ&`4BME#%!@y'cs K>G/ͣGx,J5̢$i^ZЊ~ܷzkA賉'& Fl.htzW'ܒ F2Pagy[ P~ Z9ϱ#{#{;Wf2KsuCc+ѧn}}ȗj©;|*٤M5GB.V!aͥ${70%s柤|WI̠Oc0{}Ҽ6q5q3k6()g\m36Щ$ـkpB`5FEE @`5ޫ  v  "-P]Bz0xDd9X%%{rE*=4fάp蝹闲roeE.z ,:7쫶jzzyՐr|hOMG=h0˼.)Qxu}xkED MiK["eӻ ެh->DW7/,+u[֞5//倲c)&E`oZ ~LAoM=l: iVDLnsxr"zY1+&Ο\W,f^Z:~V= Ы):Y>ouXBSMFwx>2Q=븅ϖmܐGdh10@-袄ƽ_`|cXi0->X[Rn'h `J\GU;I+WɲwʗT$^DU^4Ќ*/c%"'Q2Ŧ],׼^& ̗t${3("E)L!.z+MD\ǀY݅5*H|2aj5ԒatAr/m%^$;] Q_1 蕳j] 2*Y*蝄@дn @(Ǡ@&B=Y?@ȏME5c]= X> JЁ-PN b{// =VmkgTґ߽-B;m\=zwD :W2 zG^`ղ$Т`q$a @ӟk˻΁@`%Txd%L )ݻ{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|л{2|7, @k ^:bDn@ ;Qd@`^J޻.d%3I)@Lns}_IM4q ȂKo?$!M8MI[b>0SM'yh)tn4%#Ns4'1\M_24ˏnOFEܴ;G^nCXwJ6m3%"w\\GicKlgXVQ$jN&MwQb@B@Eo 9MfPc]6&✕XWr6>|=] iz\ۑB4M,NŚ&I1YitJdCr iz-nK \A˓ILӔ]Jq[R%5L䶜ʱHCƫ׫<ܓIҒ$c:%rv35![vxxɻ 0;&I^|YckC彲ָ ކ[;#x Vx CElh[$ w6h6x[\odES/V֢Y! JI* 2*%WU;Է\굦ָ!8ȶWIG$73nVГM$D}|74Xj H[,) }qo\QMg$8΢ۅU>pL&pvK2B@Uz'ż1ALX|[K7Nx:C>0ey\ !c\<0^f$scȩ8r)I]0Xa\3r^Eof9(x;Jo¬F0-Gu(ж4{ \Xo4GEPuL^df&>)1ex0MoɼIh 4K=ePݮed ǽ\;k5_T4tdi*|F[LGj \Wmpز:b#V1oQhu$|$LzXU\Zq`1ȵc~<UE f/m-2 VtXw̕-:fN5 ԎD Ae27v=%4쇿#b{h@`$ex9X立 #\k&ZGGGS}$@hֈ@;4  l^ Ӽlٺk{[#8Ӣ""OYW[ 8f 8w"W| @2 Ek1gu6-I)lu;r{a#·r!dHש#PzJF+u^j~ p )&m1Ӟm^H,ޜyd&{IɈq-h IVy] UV)EЛ37Ƨn*s1媊|cqV.(Lc+i!z{4JZG1EdJ/4Cgv&.Z3Z"my󦵬;E4!SPJIFDFJnK')B2=H]{(uˁM:nB{CFam٪5|[3QBhBoz-.Xsˬk7׊_;͵,yhBy]B@DZC`]Oh B^P0` ]Oh B^P0` ]Oh B^P0` ]Oh B^P0` H*6 fG ̓@B#ӱگIENDB`n "%w+\PNG  IHDRrsRGB '">Z-~#˥Q]6|(E.)|^t,YB<<~-q(r7@~{<]f1~l~ುf_6/ۘLjc9o,!0rA8lZ"P !s+U%E4%K2t)iL sL#=i B<~^AL(rNE^;lP8@ ~s֢4Qt*Ɔg @rV-#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$@#$'@#e$p}Gx<>>>ZV#5ubf@w#qk|7vF/KkUb pyB'~Y|X, @ *ˁ,XOWLg%*S=gkcoׂ @e<2]ȏA @U*Lݷ';fKV$o>=ٽɿ%0Z&d[8<+kΞOWVGm+ g-1w p:W-+>9f@%о" @j]( DEa/()4BȫE  tb;\ PN F! WWW0sy Vd}f@`I"0( @"/ ƕ|@g+{ P,e;~g*E^XsDZfEގmFZ @ 9b9F pEO EL ECo[r 5}@`E"Hp!kPv>@_hF(A@/&,b })o/%MENsrb!%v`e P\^\E 9o˗u"@ψ3( PbhqE b/nȞ [߆0}g d lT=!___%LapA-.a h4_@sM"PoQ< \U{|r|rI{piy~yᨑˋ6lD;,G<4{u"b"S'%_柼FV V]@uI2oP^aȊv>MS\v%QtyFкєZ<ǪEIzuI V-ƶfc[͜F? ֜' ݽgJ2̘0'y({=b^ F/|ZX&/o L՚(<={զ Yʨ2ĸKY3sQrC*;Js2};g ])`go;\qt Qhuw9)ΕX%"G)|Q1WyvŰ,ݑ;{kJ=coFoHM{:bYˮqGYd5繈?;xk7_|z*hĮ8k y 3[]2"]tI@?J9nlYG&{&Z{f>oα}5EyN\iӕOp͙G/ X$@l<~3eDJ|. َx|O|UpwQ'ϭUIvcEv*pm˲({,οIg!;J 2[(rWP;Zޯ,Γ"=}x/;~:U^TvSɪExej4M#iG-U8+Ilޒ~govѻDwkFWZlJM7$g:E> lNTfiȯѱs1bG^Qȳ9G(bR V}UM(rAkJGT$!X/FԮ _]zFB "G-ezٌ^PQiyv*s*vUH+T()r"\AZEbl o!@E(rE*T6dP~/ziXH5ĸSTk'szVg!(4b )9:i}Kj1F16 5B2KLP&,`t&?r;М9pr*"p"/ϒWCÁn (DsG@Ke,ZMI9Lg-zTB1|pxA V&!۴2Xu|icZ";xϮ\p%o,?GQ&9 Ns;QEk>]BpBZrf7>yϵxF[7/&j2htDot:9%SȥoLr\@M.ӯU[>ms p}9B٤@ ~ OS&ӯIQ^"}`oZ]E>j]&@@R:AO=k2gm@vS!s+ϓɲg9yj4F1j{},\5~3XwC ;w*xVeζQo"oFAH9u ;Y(NPd;{ץGxXL Zݻ wu5)ˈC:/w^{ 9]TX ,7WONeVN)ru "0Y@ vb/٪ޠh@!!U* ~18 >]gp?ׄ\=FvH;5 F 52Ew%SMEyv[r&jx35r8[vu17ջ wW]jrbۓ9nx<}]pBLƋȁnOz)\4:E2'ț Qտ [kȭgI wN(= gG7XZX.(X#fv!O<823٧F·78R(X-5 秥y=^ :RvB9"V-"UeunQݪEBUS$O[w~/'_&:}0 #0Z"i1:yyz/(kJOBjw D7= F>XG. my)QHx)|)8wr۶-thUvc6?#f Fy%c'OXȭ^/yfd*瑋NL|p΁=ȹm2En)'w̥8k#" @{Lٽ'=os>A~+7->G=$Yg#8.`jyqevyX'`բp/\5v X>! IV!jjQxvo ~z6>lG[<~ I\RN]/PvȅVn%yKSQ# <ʘȩF/F 8FyB%Qht:IEv-WwuoIsae 7~%5nqPS#PҦ"'9&%x0sKcr>e>xv٪ž+pxi{Կ{][5r*)LV#{wwR` ?[2j8oy\W#|-9*D` ''Ξ]\IUn:UR#ïHV--AB J3@e5.V^CP#P#ϹM7qYy-앟v#g[(c?XqE"go}nSd4--F՜@N9c qFL#V<j&@k@6Wj&|E͓"7\SCP]z&|L{NosG>m_e$@U9edǽ~S[ EN{ez"@{"&$2=P2@ ZZ'8E>A@ 0Ҥ ??z~m61E^ ZD7糔7 6P8nz{Uuϫo68NgX#@[ˋ7TGv*C|(EFojn Ds Psym\m?@ =ϴgPsG&0/glbcx6g_9>cs?Ǹ=؜]T,7,_n6g;~Kr?k~pݬZ2 Eǫ¶ O%M:{qa1[lpC'hOc3mr{t4mo6%".\CWQ:wYt(+丬xXh.&;B4E(~fz yPm ؞ P\@&@% P  'JIU~ d+: LRPR"@"@Hr(E.%@(@J!@W"RғtF"wpE PypܤWpr Plz P<ۦ+J_"X@M*&@+@1TL"W<#@c(rc5E *Na#P0M*'@+ @!gbpcHCa5Ebr\erPBjB P-\m8ͅԄ@Zq#@ !@(r84G_EvtslBTO_E>t&QձCgBn=*2!;gy@zT!n7 tG .nl j#@k@]ؚF"1"@(r53mp;ۏ#fǷ7 N#俾k5"f6K#!#qCk|7vFM$Rzd^"P>^HpSCrO:!Ћ"7^1hIZǸpĦ+ ȁ8ijr37&@ߊjR`A9 EޅƳ%+4 0~m 2 @`LR9wt|<2d.D #fytFx~ /FuhVǰp\{G 8kJ؍L 8kQv|x$%ERV!y P|YG PpVZ"y P|YG PpVZ"y }znɛ5#@M)כIV@$M)I !Д"z<*\L)E@c(1~z#Pt,YB#@ӱd 8F"7 ENǒ%@=@o(@\K PcF[G yt|` $P"@tVtXB'@@E  @)(r) @ P \J$Pd9B" ~ Y ȥD E @)(r) @ P \J$Pd9B" ~ Y ȥD E @)(r) @ P \J$Pd9B" ~ G#q@vW>,#|eP&13ߋLjůPB`|u|x8xk&fT: @ Sm_gRg 64d(E.#I Fi^6xJf2M%Ĵ.njb&@(rq6KE!J|\B0+%[^YK~?{,}ՀQc -}-"2gy|l0~qpP'*huZ#9t֠{x/"tc~AkXG.)}yܨjrfn2+#=7 zfB@| f [[8a xK"K@Hr(E.%@(@J!@K?@,@RPR"@"@Hr(E.%@(@J!@K?@,@RPR"@"@?[~,_~ 0!|mԕ X}'@ۏ"@-(r-'O"c3DZPZ"O@@?] Lt_;~IENDB` i8@8 NormalCJ_HaJmH sH tH 0@0 Heading 1$@&CJ 6@6 Heading 2$@& 5CJ \:@: Heading 3$@& 5>*CJ\<A@< Default Paragraph Font2B@2 Body Text  lCJ .P@. Body Text 2CJ,@, Header  9r &)@!& Page Number*\ *-\ "& "& \ !jkVh$&/0\  "-.0XY](0(0 00@ \ \ [  !! ?b$&}ym,܈U5b$ Z>X)W$Eq3b$"%w+\ I@h (    C A~..\..\..\Program Files\CaptureEze Pro\Conference\Paper1\14.bmp".b J>/$(2   3"`B B c $DJ024T   # >/$(2A    C A~..\..\..\Program Files\CaptureEze Pro\Conference\Paper1\15.bmp"   C A~..\..\..\Program Files\CaptureEze Pro\Conference\Paper1\16.bmp"B S  ?$ \  4 J t 3$ T  m$zT&)",0Z] V[), ",0Z]:::::::p 0] Mark Dabbs1C:\My Documents\Conference 2000\Paper 1\Name2.doc Mark Dabbs1C:\My Documents\Conference 2000\Paper 1\Name2.doc Mark Dabbs1C:\My Documents\Conference 2000\Paper 1\Name2.doc Mark Dabbs1C:\My Documents\Conference 2000\Paper 1\Name2.doc Mark Dabbs1C:\My Documents\Conference 2000\Paper 1\Name2.doc Mark Dabbs1C:\My Documents\Conference 2000\Paper 1\Name2.docWGHSA:\Conference 2000\Name2.docPre-installed UserA:\Conference 2000\Name2.doc Mark DabbsA:\Conference 2000\Name2.doc Mark DabbsA:\Conference 2000\Name 2.doc]@4\p@UnknownG:Times New Roman5Symbol3& :ArialEMonotype Sorts"1hXCFXCFCEf.q #0dG+2Named Ranges 2 Mark Dabbs Mark Dabbs Oh+'0 $ @ L X dpxNamed Ranges 2ame Mark Dabbssarkark Normal.dots Mark Dabbss2rkMicrosoft Word 9.0@F#@մ@lDѿ@lDѿ.q  ՜.+,D՜.+,@ hp   none.G Named Ranges 2 Titleh 8@ _PID_HLINKSA '?..\..\..\Program Files\CaptureEze Pro\Conference\Paper1\14.bmp' ?..\..\..\Program Files\CaptureEze Pro\Conference\Paper1\15.bmp' ?..\..\..\Program Files\CaptureEze Pro\Conference\Paper1\16.bmp  !"#$%&'()*+,-./012345789:;<=>?@BCDEFGHJKLMNOPSRoot Entry F@|DѿU1Table6WordDocument