ࡱ> _a^y bjbj ]9{{ e@@@@@D48<jEttttt )DDDDDDD$GID@"D@@ttmE.tttR@t@tDtDttAD5Dt_-#p C&D.E<jE7C|J|JL5D|J@5D|1EtS _Y111DD111jE|J111111111 : aCSE 1111 Homework #1 (10 points) Intro to Computers & Writing Formulas in Excel Matching- Please write the letter of the best response. (1/2 pt. each) Application Software Absolute Border Cell Formula Formula Bar Gigabyte Kilobyte Linux Megabyte Menu Bar Named Cell/Range Operating System Primary Memory Relative Search Engine Storage Devices _ 1. Google is an example of this._ 2. RAM is an example of this._ 3. Approximately 1000 Bytes._ 4. Linux and Windows are examples of this. _ 5. In Excel, this type of cell reference is affected by the displacement of a formula from its original position._ 6. $B$4 is referred to as this type of cell reference. _ 7. In Excel this area displays the contents of the selected cell. True or False: Please indicate if this statement is True or False. (1/2 pt. each) ____ 8. The primary function of an Operating System is to help you prepare textual documents in paragraph format. _____ 9. The value resulting from the formula = A2+10/2 would be 7 if cell A2 contains the value 4. _____ 10. By storing temporary data in primary memory, the computer can reduce the access time because it doesnt have to go to secondary memory to get it. Short Answer 11. (1 point) On the left are the expenses for a party that John threw last weekend. The formula =B3+B4+B5+B6 has been entered into cell B7. Please explain (briefly) the most logical reason why the addition appears to be incorrect. 12. (1 point) Write the full file path (including file extension) for the Excel file named lab2 located on the Z drive in the Homeworks directory and cse1111 subdirectory. 13. (1 point) The formula =C4+$E$4+D$9+$B10 is in cell F10 of your Excel worksheet. What formula would result if you copied this formula from cell F10 into cell H11 on your worksheet? 14. (1/2 point) What value would result if you copy the formula in question 13 from cell F10 into cell A1 of your spreadsheet. Explain your answer.  15. (1 points) The worksheet above lists the prices and sales quantities of various best-seller books for different weeks in June by a Barnes n Noble bookstore. Write an Excel formula in cell G4 to calculate the total value of the At First Sight books sold (price * quantity) in week 1. Write the formula so that it can be copied down the column to determine the total value for each book in week 1 and across the row to determine the total value for each week.     Name _____________________________ Lecture time ________________ CSE 1111 hw1C.doc "STU_~V e f h i j k l xfQxfQxf(h(ha,>*B*CJOJQJaJph"h)>*B*CJOJQJaJphh>ha,CJOJQJaJhbB*OJQJhsbha,OJQJha,OJQJha,CJOJQJaJ"h ha,56CJOJQJaJh ha,CJOJQJaJh ha,>*CJOJQJaJ ha,CJha)CJaJh+9CJaJh>ha,CJaJTU  . > H V f g h i  & Fgda, h^h`gda,$a$gda)i j .ckd}$$Ifl$$ t0$64 lackd$$Ifl$$ t0$64 la x$Ifgda,   5 } ~   ĵĵĵĵĵĵĵrbh)5>*CJOJQJ\aJha,5>*CJOJQJ\aJhj9CJOJQJaJ(h(ha,>*B*CJOJQJaJph"h)>*B*CJOJQJaJphh>ha,CJOJQJaJha,CJOJQJaJhj#CJOJQJaJhzha,CJOJQJaJ(h(h)>*B*CJOJQJaJph   .ckdw$$Ifl$$ t0$64 lackd$$Ifl$$ t0$64 la x$Ifgda, | } ~ x$Ifgda,ckd$$Ifl$$ t0$64 lavx$If^v`gda,  T U 1 $xa$gdAgda,ckdq$$Ifl$$ t0$64 la    B D S U Y Z ^ `   0 1 6 7 : < ͯͯyyͯg[hJCJOJQJaJ"ha,>*B*CJOJQJaJphha,56CJOJQJaJ"h}ha,56CJOJQJaJ(h(ha,>*B*CJOJQJaJph"h)>*B*CJOJQJaJphha,CJOJQJaJh ha,CJOJQJaJha,5>*CJOJQJ\aJ%h ha,5>*CJOJQJ\aJ1 z{|}67$a$gdA$a$gdAgda, 0^`0gda, $xa$gdAL$xC$EƀFa$gdJ 5 A L i j { (+,-KTcfjk{|ѾqqqbqUha,5CJOJQJaJh+956CJOJQJaJha,56CJOJQJaJ"h/hha,56CJOJQJaJhdha,CJOJQJaJjha,UmHnHuh ha,CJOJQJaJ%h ha,5>*CJOJQJ\aJha,5>*CJOJQJ\aJha,CJOJQJaJ#HhFhJCJOJQJaJ 789OTnry㵒sd\X\X\X\hha,CJOJQJaJhghF;6CJOJQJaJhAhACJOJQJaJjhAhAUhCJOJQJaJhF;CJOJQJaJh)CJOJQJaJha,B*CJOJQJaJph"hkUha,56CJOJQJaJha,CJOJQJaJhkUha,5CJOJQJaJ"789:gda,$a$gdAgda,$a$gda,  h>ha,CJOJQJaJhzJh+9ha, ha,CJhlvج7mc.66q9K6W\lb*춊m^aQfe/q]9dm~ r6Ȧ\o9Z^ry뼮Slqq .czc0\u 9U!,WZ1-~1maf'7;1xi͛oKr F|^18$>N%qţkҏema HJ9 I*ŧ4(NA 'Ō"5RY)-Tq{!7]{> '~ǕrDO }ds\K7{^jknow"lZ º>Éisrb]Ķ* ɳ/uź ϾX[ZÖ.-M$6y>b]Ćg_,-aK$lӦ#-a˔!lk#M}mϾXc/Ć{11U2_ 72s|>$,WGݗTȘ:3;| Ӫ^ߔ}&&8"Wi K(agL۠ԇc_sC nwZo?rl8"wxoAgΆ~%8 e1/-) $ - B3I ƁNsR\}vvn?K8xAs5/S";Ec/^, y("|&ծԿ?ӆVm;)zooP>0}'yZ*=Ĵ 8!%(F'xNќ\W q~ _1km㢣 gR J`tXj[?r$A3Kx| ն~H ^9UxBA5 A kPmGP$`!֏IPb7P gζ~ҋN@ySe[k[mDO<"bC ]ߓP3Aj#d}  356_Us.i#M}i&b,ra>G5GպT#Ƴ[ 4ğ4ֵk,>cѠCm6qMyf~2n岪W})fR>Vm|Cᱢ'*٬[j]b{Sd~%"V0#s[t[mշD,#qH'Y5s F:L*HVH% gNnP 0'HiL7{}}E=+EW_\-JJxߎZ݂׃4fwlNNs)!;$Q[1c}ڽh s\m 4ScFl[[.b.r[۶~ K O: &{o1 `7DJm$U#D0m Ѭ `8ĩz !Zu-vySX^{$$If!vh#v$:V l t0$65$4{$$If!vh#v$:V l t0$65$4{$$If!vh#v$:V l t0$65$4{$$If!vh#v$:V l t0$65$4{$$If!vh#v$:V l t0$65$4{$$If!vh#v$:V l t0$65$4Dd 0*0  # A"CUTI*\2q2@=UTI*\2qllNx8x]}7د_*$`~AK㢂"KĊHehkc0ک6Zmk0h]qh4 jՈɚ-m} i=gΝ;3Ϧ}y99s?~sg%eYnZYەOhY7XVڍ,+eƏ ,3s-b9}g[KEiE[MY~(aŖ_e^ܛ߅8_/譙o﵋~E^kZ'`Nϝ;g~(YG*R+Ů9wt.a5/B]K"y0b\x[X5"VPl߶+}DŽ ~Rlƶ6Ȍ1 lkS^lAl})WNۈm$aMr..AlmWNېm(a{v$ְvv)IbN7J9t^E^ۚ '}*e7 acM$6Z llvrRnbmwJl,'D ll:夰ݕbmHl,''^lF夰obm, ll;'+6ӻ9r>/JJ# (oy-'s{kKJ䃢|(N~֎` ǟڏ]`jL#_,:/9q(i>%Ϥ>' >%a1%}/4̓Vs3O>}[0\l}^B|p|v|:`(>9g3'ɀug])k/ܞ}/ɺR>|%d])WZy5~+*gS<:O֕V;~SɺR>Q[bq5}ϫڳM?7}k|jd])1*>/>YW'Ƅwg;s4FyK*;zgAO<'^zaI52/''o/i2NL1-rw~Nkf]'wEK2|d\'m: Ohxu^^"׹kr>lZ$ s2 ,7}v1~N zP]"oW`uLu^]9VugǂX%bM}s*]9:Kjikǂ.뵶I]-2XysXqf?F>s+8Kq_6q?N{龧TޯWg>,1bu,,>$wu6{⊯xYRs_{tDuMwZ&׋qwuwWc+ v9+bcCdlJ?6tIF2%<[w"͢] m{Wueuxf?*fט],J<9?*e⏔;qj 698u^7]mbG&Skmxx迿x1N"-ㅮ/ރKڧcq|ڍMQ^qF8!N]qnȄ[G \0޹ǠsmS|窥_V}BU!>7];EU#o..Q#VNhDG?s^ߑ//f]}ѭkm1oDŽ1K*R]s6xc UR1`l(y> M2H?tQz<2KMU"cW ƚfg{|E81hyy.4W>9N'Cr9 {[3{ĶͺJÝcFͥUnXe{aܰGUnqq771gQ!Os nn4YQۍsЍF]ϪM0OP]T!0OP]uY 2&:Ĭ)1ײ\0ӷϒL86xq ǖ?XXF纾!ֆ ܘ1k} _ qg~9jq&K8>qf3Pܦ?ly9_x 1"Bؿj1wJ+S({ĿW]|ZSK6Gw!k  K9~"xခ"N%x!03`ȧ3gO* N8`Q,sB'0p(;D 3p'(Ԝa3DLpB=&tYzsj]C|`%  5^^%=1gk  yj04<k1  0JW?ᬌ8gدB/0Jy0r02<k1  1JNFG//cq  08Ϻ!_u[q& VC.Pnklo87(fʳM 9 QVڄk_s*k_sfk_s"ыk񵂁EJ k񵂁9Z?5Zל| *175ZלH<[&4_+S!_+3C65ZעGp 35Zל 5Zל 9 Dky 35Zל 5Zל 9 DI7B2ڄk_sk񵂁9e|?XbJ[gIN~C8jȯm}Mj7ao~`I"0M/~95Fzswl&VKq6ۏcd";lup6"4zfs06}lXN*o޼M`c[l+rRy;[C6fȆ֚5b{\wM*})Wtv M)W+YrǶ"w,߯j ac[l夰bm6VN؊edc9:1x|Q`1Ǔ4,yY8ci!bgYpN{+ǁmވK-\e`*F;b c`c8*6AkIa:*6AkIa:*6AkIa:*6AkIa1=S!c0=gmW =32 sv夰aƞgƞ+' ǰ6L=4]9)l?g*dXvѼ=\ez'`~)hΞm{Ɇ8'\rMʝc9ܩ}+SoyTϖڮwCaەtx~:~X~8NPHb8} Dir=5FmLҮ)qǨu:e2I;n=]_T-qm, 3w^,> ؽnk:d[Q{t^ 2 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HamH nHsH tH8`8 Normal_HmH sH tH >@>  Heading 1$@& 5>*CJ$DA D Default Paragraph FontVi@V  Table Normal :V 44 la (k (No List 4@4 Header  !4 @4 Footer  !LC@L Body Text Indenthx^hCJ.)!. } Page NumberD@2D / Balloon TextCJOJQJaJPK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3N)cbJ uV4(Tn 7_?m-ٛ{UBwznʜ"Z xJZp; {/<P;,)''KQk5qpN8KGbe Sd̛\17 pa>SR! 3K4'+rzQ TTIIvt]Kc⫲K#v5+|D~O@%\w_nN[L9KqgVhn R!y+Un;*&/HrT >>\ t=.Tġ S; Z~!P9giCڧ!# B,;X=ۻ,I2UWV9$lk=Aj;{AP79|s*Y;̠[MCۿhf]o{oY=1kyVV5E8Vk+֜\80X4D)!!?*|fv u"xA@T_q64)kڬuV7 t '%;i9s9x,ڎ-45xd8?ǘd/Y|t &LILJ`& -Gt/PK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!0C)theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] gi .*.}.. OOdddddddddddddddddddddg   i  1 7 l  ,"$o,y?z .@ (  V   # A3"`?B S  ? T OLE_LINK2  L d  ?*urn:schemas-microsoft-com:office:smarttags stockticker KT   jn }59U^1:JN   3333333333333333q}U`    "STVefj    s~[ f%:̢PI.j&o O!pZ$#vH,pS5 b$6vW!> Y@ '2xJFPInPgbq!&TppFw^#h ^`o(hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH. hh^h`o(hH______. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h hh^h`o(hH______.h 88^8`hH.h L^`LhH.h   ^ `hH.h   ^ `hH.h xLx^x`LhH.h HH^H`hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h hh^h`o(hH______.h 88^8`hH.h L^`LhH.h   ^ `hH.h   ^ `hH.h xLx^x`LhH.h HH^H`hH.h ^`hH.h L^`LhH.hhh^h`.h88^8`.hL^`L.h  ^ `.h  ^ `.hxLx^x`L.hHH^H`.h^`.hL^`L.h hh^h`o(hH______.h 88^8`hH.h L^`LhH.h   ^ `hH.h   ^ `hH.h xLx^x`LhH.h HH^H`hH.h ^`hH.h L^`LhH.h88^8`.h^`.h L ^ `L.h  ^ `.hxx^x`.hHLH^H`L.h^`.h^`.hL^`L.hh^h`o(. 88^8`hH. L^`LhH.   ^ `hH.   ^ `hH. xLx^x`LhH. HH^H`hH. ^`hH. L^`LhH.hh^h`)^`)88^8`)^`()^`()pp^p`()  ^ `.@ @ ^@ `.  ^ `. hh^h`o(hH______. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH. hh^h`o(hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h hh^h`o(hH.h 88^8`hH.h L^`LhH.h   ^ `hH.h   ^ `hH.h xLx^x`LhH.h HH^H`hH.h ^`hH.h L^`LhH.h hh^h`o(hH.h 88^8`hH.h L^`LhH.h   ^ `hH.h   ^ `hH.h xLx^x`LhH.h HH^H`hH.h ^`hH.h L^`LhH.h hh^h`o(hH______.h 88^8`hH.h L^`LhH.h   ^ `hH.h   ^ `hH.h xLx^x`LhH.h HH^H`hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.!>S5Z$#gb&IxJ$6InP&Tp O!%Y@,s~[ Fwl\D        Y        0        Y        .        j`I        j#^bB*+9F;CD=ADj99ZJ)zJa)Ja,q54 @ @Unknown Debra GrossG*Ax Times New Roman5Symbol3. *Cx ArialCNComic Sans MS[Rrx0Lucida GrandeCourier NewA$BCambria Math"qhF g캖 q;q;$24  3QHX?V2!xx 5CIS200  Homework #1  Relative & Absolute AddressingOhio State UniversitygrossL           Oh+'0( 8D d p | 8CIS200 Homework #1 Relative & Absolute AddressingOhio State University8903CB1C.dotmgross10Microsoft Office Word@0@`_ x@2P|@U*#pq;՜.+,00 hp  Ohio State University  6CIS200 Homework #1 Relative & Absolute Addressing Title  !"#$%&')*+,-./0123456789:;<=>?@ABCDEFGHIJKLMOPQRSTUWXYZ[\]`Root Entry Fh-#pbData 1Table(JWordDocument]9SummaryInformation(NDocumentSummaryInformation8VCompObjr  F Microsoft Word 97-2003 Document MSWordDocWord.Document.89q