ࡱ> po Fɀ`\p... Ba= =x !8X@"1Arial1Arial1Arial1Arial1Arial1QTahoma1Arial1Arial1Arial1Arial1Arial1 Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                + ) , *   @+  @ @  `+  8@ @  @  `  x  ""    ""    ""  8""  ""   8"" *    "X "P  @  x@ @     `[four square puzzle1snursery rhyme puzzleѣconditional formatting'format cell alignment and color planning gridT D0 /|Db "q. vps!n!q. vpsPNG  IHDR!E$PLTEue|TWTs &lіWWqg^8UttۊmZyi%A=Zy(D <}0MA^-qІi7x4PXNm.J⬙Db9{/ېőRqFdIbZ+Hh`Jhb~΢6S_~UtPn{˝0t{U6xnLjeB`ƩTrYCĤ3v,H_Wv뙼喹IgԝQpyxौs˴O0tuR]|ir[z$i+H>[?\3ӂ*oȭ#?@@@Էz;:zߜHH;az7:z;[ЖߜԜ[Xw;Xgf_zHtttHwdQpϜߜHHfo\{^}zЯ;H;_[H:a7t7;7_`ttkvMktcꚽa]}yʜHHttHHHHH:[ttߜtttЯa_[HttЖ:7;_՜HHH_7a:7;:[a:aa[Htyt,H㿿b1*bKGDH cmPPJCmp0712HsdIDATx^ Y" MԊ$eT b1V^rIBTx MHc$!$,ݹsf@޽w33眹aH I`G$(!D !E$#nGl_ +B xK$d?[e[tcP\]&r.r+Ct9LAT9,t=*?<o?6r饗?P~ @,{b}*;Y*]w#Ygu}'xq,|'PTyx++_C(?w;/n9¾7g㛷o}.}? S OlCpO<Bϡejp<9F&Ove~N8fp4fP?3^&$–I >C A㍏_p |[c|0 c"^{g,1$d $BH!ض Ÿ́ ( l(I|:AP(r!@Oh Dt#+C̏?Q PC-^ẗ́|4]&@B:iLէ]6DE9by!G{2oeȆ|gV BVQ"xY~+ jU2 &kDHm3f:e]sohRjℐ+!oa(BP]Mndo fOH֜Tm%2CYCkY-BH.6(li+_cp1T775į׶ QNo^ сUػz}TpE{f҉xNk$$HcydA8bZ04Pi1 !䯳[*&!sQoaB:L*C90";T.0V2JسVF'RGAQi!+/ ,5T?- [~+YoYAխ1y^5; Jݡ}{k;"OjnLB;T%%C . !~L W]6eG^س yom=6y0l̪}8_vac7NU $;B_m.@ K5![Q+"ƷKVڬa #6$:ؑ?> OثU]:m]Y{^ d?6EGî0Ui!>mD/iEl[/^m9xPz;LI0!68}BB ~[*dgC6/5VWE!Qp'}L$ !: wGGilH[=hfh:\ $[WX J4;I&Q ݑ[BevKcjxWlHXGRiEයnP3i P v$!bb٘g[,B  2f3񭐕Q>bvTNmC ,Y]ŠHC21@HR_Cs8w& IV@L[Ws !eKΊ5Rn+GBwGf~OdEHu!J6"qc47sw*;{&7Q39[YAt !4O &,J{X^hn ;M{k'3Î85&DH54;zz %ybS!)k2M [pf#`]\.|늗AdLbB!VwB"ΫoU@l\vmCR]p倇# .^*~Bې.Bsq"Ww{Bv .Q!3jsvk3`KӬRUft!BHF-MBHiTх! 4 !QeF"d$4+F]`KӬRUft!-tU@Vބ@r2}V񏥤NkwbZ-~XVΔRF x?UB/2_?𧔐 \I}(j_Yw|j^79 D;$_C*5ss}&t2mzE| !HR6O$3GjiAp߲I;,]]G-TabbbH eBe$2!9"_ !ʻxGB|8"!ٌ2e|V_"&hJH 4LBh=I54S}KF&$\uBI=3 $I %WB  i(I3!~oEϙUUTz!^ʊ;讱*xB5R"6374W!@-Bd BlAeuZ6'2! rRqBϕ d+Bf!-\v8}d6Ĵ/^fh18UjPQ Lqm[5Dej36 wü ?54FGͩATj!D3Ha: ^")cydA8bl[ڌwr2;{f>gov\m mQ~6p#p \gyK ڐd}3ྭ7V @ ns&4#7`"1^E$u NAugFQ!Lhք!gzDuqay711 14h`DP!*7!I5mdBS!t ! 1LA 0@"Oo̾2Д!ːщ`A^F#eΌՋI>bvm.EƮzu1PSQ8r/tR e5M.u@I5RFU#ft2B.oؚGxv q=ֹ] 5 M9W]Kl͜\缝4뼍3w>GkDnX;3/< DQ]_F'iM "ᤝI@)r>a!$gpBHT b)bR}SYs"!$/&8 !BHyBR+&peǪ!^!HQsvHsǥU?Zx7h]sL$BnJڿ`z;W/ ! әMȢ˧= noϸ.|ׅ@*h E3D/sUV;篁^hܗV}/C!kqmH(LZ4ѿgh^4l ]ʭwlF FDi"$XK!p_=  ~zwo2hBh5xFm`PaFWXNX[jB׶Ao~ЛeRǷ!@XP-c_](m2(.< A4 -ِmd#x>B}8e`ΊfĶ!0;z bZS{kglR f>؂/\HIv3(|uص ? ٭a *6$96?Mc`Vuu8uT#t:UrKPDxё*ư:aaD/KxIj<lEzeK]۠>av6@׆T̆0iq5t_Q 96|O1`ِzt8 0 1 GP b4I&؆PB.wGCbChk h=tp'S vܘ*>= {~@ M: C4WJ>$C)QT[;׆|]i$rwfwt q)>6$n̙;9V&ש[_{[M`5D.hC򁃎ņDbHU)BY+h6l. BM|S˄g~Ss8 vzBbnQC)*T$Y6ҶetwJ O9A<>"DT^&G#1kT]lH$sgBH Ѧw^8ByxFBH8Efl(\@i( ICFA$XB"I$ 6$?!I+ߨ{NT+k褈<% !!HĆ bC$DzUW\DzUW\DzUW\DzUW\)˜Nr!oFp=W0BRVHAS̩z$$i$$-Bn98k&Kِ{ _>!BHǓF}XinOa " ! !zNo:UHJgCx%ψFT#6FllGbC֬W  plQPiX S`BJ!Q0̰:T}O,CW ņ'XI16Ӣ]g@&XpmD iR cR8o&H|LdJPt@Cq`30gk6Brp "|id\2]@9qs 6S*=կNYh"'k. BR}F%Ċp<]ǐVL~KV< xH2 k!\mMJJ_\@21Jrn5'MdCֲ\|>'"U!Ć`5~S!:c9 K!Ɍ{nUlCh zX$kߤqx,je]I9O {Vf=/"U4a/c.ny ?N7 I$0/ ˀuƀT[mi%tve. !% i' b}2bRۭyVTg<[;5W݊}fc6ײi|EH$ j{n%9'q+QR(/rxYZqH Z^&SG4[:]ӖcM~ bI˴T)rBH[^ !RV[NUi tP!@j˩ !m{*HYm9U!-b/A)-*E:R eT@U5-O*Lj_ICe!E$ !DfYS(IENDB`ba"~?Nt]1<="n5"~?Nt]1PLTEbƨ्^}w'n $jfxuxe|tqHH8UܞZW؝ЖmZyJ#ji%A=Z(D <~0MA^cz-qІ4PNm.JDb9{+cYIőYRq[Fd+HhJh~6S)`# UtPnz0t6xnLjB`TrUk\>~3v}WI_Wv % 'lL뙼Igs˳uRnr[z#h+G>[?\⼂*o#?}n@@@Էz;:zȦߜHH;az7;[:zЖەԜ[Xw;X_zߜttH VtߜHHfdQpwo\{隽Я;H;_[H:a7;H;7JV`_ttttkvMkctHHHHHHtH:[ߜtttЯtta_[Ж:7Htt;_H_7a:7;:[[aa:aHHvӜw-IHHA;:7Ht⬛tttt|cՖ`bKGDH cmPPJCmp0712HsIDATx^ Y "# "*AEQh5Dm$jY )wnna %VnHcC">ByZkiJU8g;;sf;;s̙|9g$%pG$,@"I$'BD1 H`B#"Ht`NtNrtNuZLTNiNgt(}NBG(r-D' .W0)kW 6~ҟa:ӯS}HwuQ馛ҷQq<~sL'|oasHߋ!]wuMg}衇oR~Ӄ>S~`H?g N?G)]kO .x/Gy?ѧ~ꫯNJ!%UA$AZ}~{A؈ DfO4D&['qF/r5 E0eHCg&rW"OD=5{twui ~+YY:K&AhD{\Zd%Ѱ}.GI@ujC D|P: k)gLFp4>n,5r:~'E7w7!r:E3;\BB9-vuXȼqANoV^yx l݆[sEVJNEIt`Q7|\>w/IEYX~Wϳ?Ȼ7^9 ` (DQ0!N_ı"H  aR!mr2"J\dܵ5|E3!d?t懈Cë@-"Ju!2VfrUƞ~."2ۉRA9]Zj"E:I؆f"2:f"AOFCF"XCC-҄Z$Gӡ:]%D>v# tx*Dd%"]EC hUB]"-㋨Noi<{gs`.oϞ ;3߽Jd"W*S+UIy R$D?7@{Gy%O+qvv;@8pV1BmJ"Cz/5@oceex4خ D/ɷ|K@#54*zU6{"Mq "˅AdhF]Umk~;V<]} i@M?"K{׀w qh"]9 J?uzSJ @7xwFlWiB)T0\7 rn F="wᶝD]3<{锞X@Rr{Ȉj6UlD̖4fR10Q=D ߚ"Iv!dKb_ qK3qٸBħf@d>NH]_=H:Tm M!Y)-w K5^ { =gV-n2*=J({"؀S]^f-?A螱Mj5Q Q.04cq+D|ݓ{DfڈV$ RB-bkG˻hC36i]E 30G+cZ "jmY#S ?0\*z<2Y ސ4()H/2:Lmʀ8I) dSN/뛔TUȔM֘2s[3B-3X +}" {4J2yA( gLq̫EmH#$AbwPDFˬyP@ =6ePHvG{chN64T$ {a(}CSf^-ɘ\g)%)Nê:\.f2K{t_f(h,KХ⩇wWACg5%S(>&" =m\$ZA$Bk-͝ifxW"~5L~/5"/oL.z11S)=I(OIJQ:K9RK$e@TD]P ʛXD2y.(2oߏ8ZrH>KU/U _ROG~LZDB "9"".>"4w,bh\R3VęÅq Vw_]>6:9ɚ8YsLGڣn FۋWQQP/bjz:>"36.yJQ5m1|" @jkbƷXN?|ﮁqDR:UZ.8-bZX3c34`EtB/ Q(z5h6jo+|`FVBP+J6~ԍ[W!(!T$,hCbXd*S@4 xJ[i lz}D?ثlijACcltC+ZcDdKY$4E}'"HƋ4"M|Aiok,"h87W8a/GA:[0gWU?wL &! )[4"7>s:@ Z$D Xf[aVuxthQ(2 "QZ#CGV]Iu g"o}nݦ! ?q7)@-ǥHoJ-f`-(_ 6>YmR1̤L CN4Z<-B/"@`ɾM6"UV{ x&CnĨ F*tDw'KXND ]ʾvǦꡪ]`d^ dEºHvevT -¶Tf>^C*BݝL,s ie&6>P(Z|hD}+,<\c+ߝq2C};^Z}JBUطUp+GÆ,&A+;7iB$ACnJ2"zCg4Qy*(@x>@(B?_QIj; G{Kw/ybaMI(Ooj=c͗hq%DWvRɋsy ~h. |}do/0v9Uӑ?"BH"≴1 {Up!Hp.^R AqabvUĐiD,rJ0HUKd+A$[yjH-*GE$FStJORjGIJN##>4JOR]Dbzk("JORo$jXE%1WP"M{RQB ~@w"wv$-:"h6J}#ґ< "MV>W>+>"wz_s^4Hi+ ehoH,[L\ʨ`+ "sI cL2ZpȈCG =cZyMT=ĆΎA<"=ѵH"2F$ RB-bk%iC39w̷]ViϪ*qWKv˛ң姆:_/I?Z޵$ |@rh'ߚhnj: έL d@:}9:&߆Lbjs1e Ok;GSzt5S6Yc{yy{Y{cm ֌AH #^Ҩ3PE/Z$aF }a -bjʀ8[|у "!"4w,bh\R3VęÅq Vw:V ZW$p F$cVx1ӑh!.\^^<^}=MI"#28c'!l]ofAĂ'PZŚ/߻k`"Q@s\Zz)_ )ZŴH?6q%?r 6Fſw .b# _&A_l|a yh7@{oo LZk@C `]Y@6TL(Wj'йqs3J -hhlC6~nh[\ R_:y¨Bd5P`E ,d*4E:sDAD FVmN ]l"8xGu34-XJ=Zu{`ήXb"m-#Yvv*7KNcYGJ "!Z8ІwWYE 6عUv=g VLĠHh>Yu&!s4h2SϯP r| ۛԔI0"Z8DBu~S2E@aX`7ZQa_(qedpnL$ ":taO"M! !p` `#bo H d4G\YШXSߝ/aA$:C bvy KlAu'$ Mm{ZUR" ;YЏq9qp^,D4 Ͳ/=g=͐Qfg<#R9Ehr([1HDԸe$u8? 4QDS"謲@?7 m=:=6DeшWe̕+lz-vt"(IҎ$D8h&E5yG4^AA<O퀙A=:OwqmADhP$~>MDZm;AD[߱CS3(4,X0}*UE|mEzz2:ȏ?ku`YO !-hZ'E{4芴/ҿ}7DJRq%HSܟ^ 7qQ\]X ژxǸ$.Uiq9/-U|< j45mE@H0#QlW ^]⊆m %D0B :sMKx8Eڡ †G|V`D6UQV'£W7FD NJ2]%-jht vjƵ^U^]X-JbΪf)AohZg_>#Ի EUa{,L"`8h5wΑGB4魺;)o⮢H􄰡Q7T %Z;WFрFT+n:æA#x@mc*gD5WJT\&f-PP*?N`%lc2]~OiFQ]Y\k%T+{DeC2Pэh(:^oZ+eK -bf _)_ἽjFUDLXbhwm[C6bLGl@G ΪHUdDm~/#2 {A$mQ"mj.d$^FoeTsA$#A2H~. " :Dv\HF ~Vf!"I$$oD)IENDB`3 A@@   Q;threcaifdoglsnmwNursery Rhyme PuzzleType one letter in each boxIncorrect letters turn red.`Conditional formatting is used on the puzzle to indicate correct or incorrect letters in a cell.cTo illustrate conditional formatting look at the red box below this line. If you type the letter A,_lower case or capital, the letter will turn blue when you press enter. Try any other letter andhthe letter will turn red after you press enter. Look at the blue box. Determine which letter goes there.lIf you need a clue, click on the blue box, select the Format menu then select Conditional Formatting to see.`The image below shows how I formatted the red box. Select the Format button to see color choicescOK, now it's your turn. In the green box, set conditional formatting so that X is the proper choice@Need help? Send email to bylesb@internet4classrooms.com and ask.Ready for the next step?click on the arrow_The cells on the conditional formatting sheet were set, by default, so the letter are displayed^in the bottom left corner of the cell, but on the crossword puzzle page the letters are in theacenter of the cell. That is done from the format menu also. For example, type B in the orange boxBiThe letter should be green, unless you typed something other than B. But the letter should also be in theamiddle of the box. For a crossword puzzle that alignment looks more pleasing. To format alignmentUclick on a cell, select Format, then select Cells, then the Alignment tab. I selected`center from both the Horizontal and Vertical boxes. Ready for your assignment? In the purple boxpset conditional formatting so that the letter X is displayed in green, and any other letter is displayed in red.mAlso set formatting so that the letter will be centered vertically and horizontally, and make the font 14 pt XDoes Yours look like this?One more skill will make your crossword puzzle easier to create. You can select several cells at once and fill all of them with a color}That is done by holding down the Ctrl key and clicking on the cells to be highlighted one at a time. To practice that skill, select all of the blue boxes below and fill them with black. Do not fill any other cells with black, just the ones outlined in blue.oCongratulations! You are ready to start on your own crossword puzzle. The next step is a pencil and paper step.oMake a list of the words you want on your puzzle. Include more words that you will probably put in your puzzle.pNow, print several sheets of the grid paper in this workbook, and try to make the words fit. Plan on paper first\then open Excel and start your puzzle. If youj wish, use the grid sheet to make your puzzle.. Shortcut!!!PTo save some steps, after formatting one letter, use format painter to copy the Zformatting of the letter and transfer it to all other letters. I know, I know, be patient!RClick on a red letter (not incorrect, but the formatting is wrong). Next click on 2the Format menu and select Conditional formatting.jSee it? All you do is highlight the wrong letter and change it to the correct letter. Be sure to leave thequotation marks.6Clues can be seen where the red triangles are locatedBN N,OLP SFU X Z1 Fɀ !ekIl  dMbP?_*+%MKhp deskjet 3420 series (2)!@m߀drtBeRLdBeںںhp deskjet 3420 series (2)s (2),LocalOnly,DrvConvert"d??U} } m!f@@@@@@T@     &&&&&& &&  &''&  "&''& &&  &&&&&&   ):((( " " "  "  "  "  "  " " " "                             Dl.<<&<<:&&&&&&&&&&&   &0(  ~  < XPP?]4@ Hs  8nCf  B<CAcross - What a chicken lays (plural) Down - The opposite of hard<B~~  <8"XPP?t]4@8"z -3\A*a @<ADown - Another name for a couch. Sometimes they make into a bed.<@~~  <#XPP?]4@#< s@BjO ;<<Across - Abbreviation for Young Mens Christian Association.<P; .........>@ 7.?n Association.P e?n Association.P e?n Association.P g?n Association.P g Fɀ (s  dMbP?_*+%"??U} } } } } }  } I(##h#w@#@#@#@#@#@#@#@ #@ #w@ # # ###################  $F%%%%%%%%%%%%"L"     ("          ("           0"                   ("      ("          8 "    8 "    4 "L "L "L "L "L"L"L"L"L"L"L"L"L"L"L"L"L"L"L"L"L"L"D"lfP||~PPPPPPPPPPPPPPPPPPPPP #!#"###$#%#&#'# , ",!","",#",$",%",&",'".>000000 (    Bl  XPP?]4@l TV [I( <Humpty Dumpty was a big ___<  B  XPP?]4@ V ZJ:GKg=; 5<6How many bags of wool did Baa, baa, black sheep have?<95<~~  <4 XPP? }]4@4 LX We©6?D  6<7Little red riding hood was on her way to visit her ___<'6~~  < XPP? <1]4@ LY F-Ex?Q ;<<All around the cobbler's bench, The monkey chased the _____<];   B  XPP?  ]4@ DZ K^RPN:] ,<-Where did little jack horner sit? In a _____<,   B`  XPP?bH]4@` Z :ܩEsX %<&The bear, fuzzy wuzzy, had no _______<%  B  XPP?b]4@ <\ lIF$-} <Jack Sprat could eat no ____<  B(  XPP?q]NA]4@( <] v9ΥB 5 !<"What color was riding hood's cape<! ......... ... ......... ...>@ 7&   ?  5 XPP h?  5 XPP h>    ?  PP e?  PP e?  PP g?  PP g& ?  PP t?  PP t6     ?   PP r?   PP r?   PP w?   PP w  ?   PP a?   PP a   ?   PP d?   PP d  ?   PP f?   PP f  ?   PP c?   PP c  ?   PP n?   PP n  ?    PP i?    PP i  ?    PP o?    PP o?   PP m?   PP m?   PP s?   PP s?   PP l?   PP l Fɀ 7CQ  dMbP?_*+%"??U7 @  @             ;!"#$56 #3 !4 "5 #6 $7 58 69xv  ^(   t  # :A.conditional_formatting K0]&`<^  =jJfyK %'format cell alignment and color'!A1"`0x]`Da2   @oVyK 'conditional formatting'!A56"` < P ]`avn  # 4A(conditional_2nd_try% 4]&`bll  s *  A@   ]` hc <Click the arrow for a shortcut< >@7777? shortcut  A@'a? shortcut  A@ a? shortcut  A@ m? shortcut  A@ m Fɀ G?  dMbP?_*+%"??U} m   X@   ;@  @                         ! " # $ % & ' (  !) "* + , - . / 0 1:&( ( >@  7???  A@b???  A@ b  ? ??  A@x? ??  A@ x Fɀ ̶  dMbP?_*+%" ??U} I@@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@" " " " " " " " " "  "  "  "  "  " " " " " " 2" " " " " " " :,&&&&&&&&&&&&&&&&&&&4&&&&&&>@7 Oh+'0@H`l  Susan Brooksx...Microsoft Excel@x#pq@E>1՜.+,D՜.+,L PXx  )Memphis City SchoolsrA four square puzzlenursery rhyme puzzleconditional formatting format cell alignment and colorplanning grid  Worksheets< 8@ _PID_HLINKSA ^C %'format cell alignment and color'!A1 'conditional formatting'!A56  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^`abcdefhijklmnRoot Entry FWorkbookSummaryInformation(_DocumentSummaryInformation8g