ࡱ> tvs5@ <bjbj22 %JXX<2222222FNNNN ZF      $R D2D22YRRR 22RRRf22f whN$fo0fo!*o!fFF2222o!2f,RDDFFdH FFUniversity of Massachusetts Boston College of Management MSIS 110: Introduction to Computers (Instructor: S. Mathiyalakan) Excel Project 2 Q & A True/False Indicate whether the sentence or statement is true or false. ____ 1. If a formula is entered into cell F3 to multiply the values in cells D3 and E3, Excel recalculates the product whenever new values are entered into those cells and displays the result in cell F3. ____ 2. Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators. ____ 3. Excel has more than 400 functions that perform just about every type of calculation imagined. ____ 4. Including the wrong cell reference in a formula is one of the least common mistakes made with Excel. ____ 5. The formulas version of a worksheet displays the actual formulas entered, rather than the resulting values. ____ 6. Sheet names can be up to 31 characters (including spaces) in length. Multiple Choice Identify the letter of the choice that best completes the statement or answers the question. ____ 7. The __________ preceding a formula is an important part of the formula: it alerts Excel that a formula or function is being entered and not text. a.number sign (#)c.percent sign (%)b.dollar sign ($)d.equal sign (=) ____ 8. In Excel, functions can be entered using any of the following methods except the __________. a.Function command on the Tools menub.keyboard or mousec.Insert Function box on the formula bard.AutoSum menu or Voice Command mode ____ 9. The __________ function sums the numbers in a specified range and then divides the sum by the number of non-zero cells in the range. a.MINc.MAXb.AVERAGEd.COUNT ____ 10. The __________ on the Format menu lets formatting be applied that appears only when the value in a cell meets specified conditions. a.AutoFormat commandc.Conditional Formatting commandb.Cells commandd.Style command ____ 11. When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of __________. a.8.43 characters, or 64 pixelsc.12.75 points, or 17 pixelsb.64 characters, or 8.43 pixelsd.17 points, or 12.75 pixels ____ 12. To save a workbook a second time using a new name or on a different drive, __________. a.click Save on the File menuc.click Save As on the File menub.press SHIFT+F12d.press CTRL+S  ____ 13. The Print dialog box in the accompanying figure does not display when the __________ is used. a.Print button in a dialog boxc.Print button in the Preview windowb.Print command on the File menud.Print button on the Standard toolbar ____ 14. In the Print dialog box in the accompanying figure, the __________ instructs Excel to print the selected range. a.Selection option buttonc.Active sheet(s) option buttonb.Print to file check boxd.Collate check box ____ 15. In the Print dialog box in the accompanying figure, the __________ instructs Excel to print the sheet displaying on the screen or the selected sheets. a.Selection option buttonc.Active sheet(s) option buttonb.Print to file check boxd.Collate check box ____ 16. In the Print dialog box in the accompanying figure, the __________ instructs Excel to print all the sheets with content in the workbook. a.Entire workbook option buttonc.Selection option buttonb.All option buttond.Active sheet(s) option button Completion Complete each sentence or statement. 17. _________________________ can be used in a formula to override the order of operations. 18. Excel includes prewritten formulas called _________________________ that take a value or values, perform an operation, and return a result to the cell. 19. The _________________________ is a format that displays a dollar sign to the left of a number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent (hundredths place). 20. When using conditional formatting, a(n) _________________________, which is made up of two values and a relational operator, is true or false for each cell in a range. z 2 l r {|w;<دn^hB*CJOJQJaJph.j,h?$-h-lB*CJOJQJUaJph+h?$-h=D6B*CJOJQJ]aJph%h?$-h=DB*CJOJQJaJph+h?$-h=D5B*CJOJQJ\aJph%h?$-h?$-B*CJOJQJaJph+h?$-h?$-5B*CJOJQJ\aJph"h?$-h?$-5CJOJQJ\aJ#9{ - .   w x $ L*$7$8$H$` *$1$7$8$H$ *$1$7$8$H$^$*$1$7$8$H$^a$gd?$-< 3 4 Zkkd$$If-\;Y hh4 -a $$*$7$8$H$If$ L*$7$8$H$` *$1$7$8$H$ *$1$7$8$H$^     |q^$ L*$7$8$H$` *$1$7$8$H$ *$1$7$8$H$kkd$$If-\;Y hh4 -a $$*$7$8$H$If eEkd$$If-0; h4 -a $$*$7$8$H$IfEkdD$$If-0; h4 -a e\Q>$ L*$7$8$H$` *$1$7$8$H$ *$1$7$8$H$Ekd$$If-0; h4 -a $$*$7$8$H$IfEkd0$$If-0; h4 -akkd$$If-\;Y hh4 -a $$*$7$8$H$If TWjml^^^^ $$*$7$8$H$If$ L*$7$8$H$` *$1$7$8$H$ *$1$7$8$H$kkd$$If-\;Y hh4 -a $$*$7$8$H$Ifkkd`$$If-\;Y hh4 -a36TWrwiiii $$*$7$8$H$If$ L*$7$8$H$` *$1$7$8$H$kkd$$If-\;Y hh4 -arsv $$*$7$8$H$Ifkkd$$If-\;Y hh4 -a36Uugggg $$*$7$8$H$If$ L*$7$8$H$` *$1$7$8$H$kkdF$$If-\;Y hh4 -aUVYily $$*$7$8$H$Ifkkd$$If-\;Y hh4 -ayz{}~+l^^^^ $$*$7$8$H$If$ L*$7$8$H$` $*$7$8$H$ *$1$7$8$H$kkd$$If-\;Y hh4 -a +,/NQv $$*$7$8$H$IfkkdR$$If-\;Y hh4 -avwx -ugggg $$*$7$8$H$If$ L*$7$8$H$` *$1$7$8$H$kkdR$$If-\;Y hh4 -a-.1IL^ $$*$7$8$H$IfkkdWS$$If-\;Y hh4 -a^_`<ugggg $$*$7$8$H$If$ L*$7$8$H$` *$1$7$8$H$kkdS$$If-\;Y hh4 -a<=@X[m $$*$7$8$H$IfkkdT$$If-\;Y hh4 -amnop#&>l^^^^ $$*$7$8$H$If$ L*$7$8$H$` *$1$7$8$H$ *$1$7$8$H$kkd=U$$If-\;Y hh4 -a>?BTWu $$*$7$8$H$IfkkdU$$If-\;Y hh4 -auvw;{{hhhh$ L*$7$8$H$` *$1$7$8$H$^ *$1$7$8$H$kkdV$$If-\;Y hh4 -a ;<$ L*$7$8$H$^#0P/ =!"#$%$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -t$$If!vh5h5#vh#v:V -5h5/ 44 -t$$If!vh5h5#vh#v:V -5h5/ 44 -t$$If!vh5h5#vh#v:V -5h5/ 44 -t$$If!vh5h5#vh#v:V -5h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -IDd 4g 0  # AbcIp~b|&Jj@?Ip#n7Ip~b|&Jj@PNG  IHDR)6%sRGBPLTEf3̙f3f3ffffff3f3333f333f3f3̙f3̙̙̙̙f̙3̙ffffff3f3333f333f3̙f3̙̙f3̙f3ff̙ffff3f33̙33f333̙f3ffffff3ffff̙fff3fffffff3ffffffffffff3fff3f3f3f3ff33f3ffffff3f3333f333333̙3f3333333f3333f3f3f3ff3f33f33333333f333333333f333f3̙f3f3ffffff3f3333f333f3 pHYs  EIDATx^}ˎHԅnD4ɜAg.fЀSz\ŢS@P*Jc?0Nw{HK\QeǮ}fʡz인$%}y KD-y-c!_[`!2}hb08b)qn\n 8xAXV\"3 NȊ!@b{eT}*)( PƕVA #/ c B=* A)T;Q`q70D1)w|kŎ$e1۠W¾8N9-H\wJbur*yzt>cGhv_)P7a@0 0¼hWCX(!`lmZ=\Mgn t 8+QpmLJ`%Te.y#K%z^0t|K+%dR6*kb("\[I$<-uMnn -?Nn=]J0*Oּ1o$N_cSYqT>lXx|U%&:_g0ֽwzWï[k=d ZJ+ZFnA ~`Ȇ7Jy!o2WZp` 8xT:yy8?>ՂDZ )_+E4ـ_8UFpI d" \4 C @L; Eګ+`и~#HA ?!ݦc2%wk5LƣдERJ WdDײA=SpeN1gݭ)_z Ȓ΄Xyo]bϠ|]EZȞѳ 2?i 9ԛRjX3AFϾr7zw 0(1Y3^ Ŵ8⼻y%i^&C$rmJ?R&lQ N}|݇.QEojDF/\P0f-PZ0Q0 LO.ֿM-68Z@g"QM.ZA1@kVP2 `~i#}_V UN5t_7_{V,OhgէĂFуqTʈ1ZAV4g SPD~ 6aJ[ώ`D~Rg Ӆ{25"j}0jQYhy'@ä:y_f ZE^BmDp c{#e[cpffΐFV? 7>}_\Q/hYV+^'` )L W4s/#>C 7_}e W_Y l)T(`,eX4УSyr23%g؊;%\:xTPC%|9X(-s737?Zʓ[6dH[m 4z-<-"^o)/z> 'E!M5nYkX'q{Ls#,8r]2ްƝiJI*GXVn\Ua2yӆlm F2׃@)pb,v+U6)doPpƂ(2b/-^Wt-$C5lS'_x!: |AC V<02LJRƝXwųR/ѻVז-:fCXꀝK .GPvc6 Gw5D(p =PxDèՀC *P×j󲯂2(P[AHnO/:J0 V,c7Ml\^ё0FpDn'e mG*kKXE76ܔv\C#2K-$grg.6e.Jk64h*C;r$$%R ao(TbXہ_V:"kke kkYkkf>βM>&egc}]5C[guȾx obK~33`?j7HTD2Yn>WIi (>=`|,y4g(I/i5ߦҡ<* ZL==б?SB#3l]:H =w碎^/t94hݚ [f%dl{}B-X{|&Brȅ"뇅[F  ,Vo.n0㧏(Gɜ!i7?WQ>Gu֍U8*< A?nvƭ7 l-7B ` )d^@EYGigůSf5-hÛ."0RNN4i muWبX8cvͫL]`|tX̞eG|4 H=J;eS?1K:cc1L݃2g ep1I뀸`,STT\` J5 \¿JOTs^ B_ pit6LupS~躕i2Hzt7@Md}\`h7G)fB}Bǣo Ɖx_ |eMVX\.Ȉ pq`M=#`sQ GET IS4Gx:VpW CH\$K2K$KF* 4-Tos a0'GW4(偑I YGFw1A  Y;.Ѐe0ON0tSY#]drGF ZT`A<<8M&~*e|V3#8S|L 0$M0ҿ?G&ԜO} . ՙdo^ p-R2 H!uVpGIJ-K$U 4 Ma?vuƽ6񴦡0%L0sMÇS3$(0K_.;_`{$ZssMn\ gQC4ikuQ$%iԄ^KS7ȅ2L!or{٥4/QV0ٱFJ2Z@j8`QCTq 7watA]8P(cr7F dLU ;t*) aĽx5gpph {` {0TPs^`\ eTZ)mjqTPKԂ1T TVVX~XDHƲHkB㓨]my -vL;]2C1~,lݠ C1Bhհ+`;z0z _{VN)wo/uh1񰭻cuR_A 8>] 9RTu3zG a=qH6 i:[4Ova C9ݐ<6!|-ڢt!XoN`r:dPĐ/E@/z07:e ±\|,= O2¶pH\uT׺rB0\E]}[ }QDop`b :H +j׃P I`J-;w  7-&} ~Պ\F}߫Z ט),|c@nNYfrACfg0 wKW!a!)3ޘkQ14p7J J|0}U<B*IKy`@O+(ZP 2vMG<jɛ:xg89D lqQC@QS۞zg0|=g՘BY²Ok %,4jܨ{v)cv+_1k TwxYMsjҫ8Au6?rmD(Jny<ȿo /`Y|;=8npZHe8a$i`l@X;raƭ8 4LJ8Ro:Y0[H<܄'ezqAjle^ Mg ̇M[B 2 ^l} .Cr4 "6r+H(xG2(_ԥRF,eޔu<{Wω [DÔH9NesFe׸dƶJ[H89``LkiӦJKAQkkLӒតe(N4t/Ju4[؄eߘLA`D =AͩjHFT%iz%$Hu\ݙ81`J` 26l@(LwSeh[ aNRp ,nifInyD.쁗zR(E )I a-+}`@@ ^APl2J& B_,M81ɣ4͢?g1d12(̲5l DYzqX6&ȅN"xKMB #/S)nW':$M=.m}}!i]b9 +QKދMX$ɢ ')q[$R3(4%)Q;q駌ݎ)Xʦۋã!,{R@ "f$`Wuh6:L)P7Ds6P,<gl/ Y0\E x)8 N 3]B&TI'.% 3gR7C1BwOud|Պa QE(qm6{2 eCL"aZfhm1,nU) 3a n 3ע!tGz#TC%vB \[cܛ hpa m >b,;6lKXG50aJ包g4(9`R3veK0$"(_$U|ɗ 5GZc|4K -2&"\QTX@yYQXD0\ޔrGQEe͡B_ OM`KS29r[NxĴLp,`I SqK/Z2)[ tuWT!gx!0QC[&g,rSaH DI%x.."ေ4x̛LNA!/aJQ"Hxl'8Hk!Z@ikOw6 F$ˉZ|@V9U +m˜ 23طdUXb?l@Fc"ߤ.92Meya`侷R0چ) Uy(ʐwP*"ԥ.$ږpםo{}2[@q.x(d+LJYN=X )J4Gpi:[M_58`'#|?97ʬ¹ЩlHOҽ:wWHOhT*;ҹXp8y0 _ZX'S!4;`\jBݫ*tِa\ZÔBK L§P,&J*XXÒ^MB?Ҍ92({X\:QV@i\JRFʸ,e'OmK#pE`,kV%',܅=AV)k 1}eg>%c2ʢA0Z'MN)"4 ` )L=P9;0u!Ae0Ž"*K 9g &hFfPoo<R 0֔BB*©=qb#.rFsΰS+(DUH0.݀2tcHc {jJ&7u| Y4%\ [%$hS `TP ô|Z#m. u0F SiBb#ZC$71Da#WA3;D8I|[RpܜĬm {IȲN+ɰT8lMT(Zemp֖Tۗ\:L6T xTr *Wh,itH4Ҏ]ס ܾEӸT*]٪Nl3Jb_iYeg12ZWh3 K1u@mڬrM`/5R4!TjD "z/50hWon|@uqwB`ږ)SFeLM"q_ @0I|; YGz#6vuvNF͘;GoīEq Ifbm(Ĭ:}d  7>#{Ë+\`o[`b?CxG߉Y$,{@hMc~=2$]C|Ēb\!3ǔ1.A+RI"霃_8t{̂!(Dмy 6#q6C\ yFUk⼉KGrSף ʗ q}q₡1JJ`+Nl/Bd|[q RޖҲ@ޭ*, Le|в`hБ BGtҔf0C,˹#Pu$!U(#W"r$qYj\ &}:q ;(A8a}tdY,e }S3!$L?zRf>y9NEfqp=@Ie$f\Ptj{&qI-I4+a`i*(; WK|pUc-ooCqLj\%,5.ɗs1 vcc)g]dHo4I.NTUr%4n}%pY8>̬F=53 = 0+M]/dD NgiD Sb|:ꔻ*= PɐmwRLlÊA0`XzvG*g-fYcp1$La`i7qLN(%D]%I$R1N΍e<ôl/:Yl8B`Po l((-%hכ44({;i@ < vkRa\-9V^ f߶o80ĸl]6%[a\ )#K&2ML+IVk+ a4|(W^LjD _ vKCz0$xX$7dBڍK$S~^жa\r)jKfXqɜDٯmCj OtP)\ iu;Q7%&Jt&(zvH '*4.**XvJTEC,sn0lPq m MU"ĭhU%:S_]TJcȇ9 Ha-S^EȥEJtL[4)d5L ێa"˔ynqڢ*ݮnE+ #0VT0qưQ3 KD4b\bMBi28~ilB؜$ V]猳mofo[U0 N0I` \rI(:"T!9C䅛rn\*ٸ8RRT&E\zpA9AWYu FD@[Kx8/L1ø75zrp#E S>LY\lU?gm3 d% 4Z)XҲ8)1-W푅{ UϬ.]`SXIF}z`K&7/붯 7KnSRqĖΦܷcg%w[TjiVYyp#T0#Zaq+s@\Öq% Y,dVbaZ !(#į_`Y+N|x[ȚK̈OMm= KI'[IWHVN)m=O ɢ%H^3QH=5`jtдlUH I ]>pV (S}ehpd% 1>l D:H\蒅cvMK}wZ04Y ?}%U(d% z eR3]RcTґ FENeŬN )Ca@^B<^jQzd\BYfzPiT\rd`z YBNޠU6yxC%plGBL6eZ< bwarkBnS}(37D fr#ՇA$>,l{ׅ_$4,I?)#RÁ광 DayoK.]jeb%XhoBr|+8%,on݃96gC2g؉```'ZF+fq(p3hWkz +YQExqBۋ*\/2v *gfe麶k("g<*02xN V}48NwB̧4Uwqg0h8%,'CrA k;@nwHp|zy!dA:fi'X!ADqK'u .-rTn`]ݮs֕nMwOM9am1B3ǫ05H%!qӼ _< ub+R Y I&{ }g0:ykL`s}C4mKic(or2l5E4Y)6QdjV ] X!jb?R a6B0{=avDɐN #4mmEY"^|#8 :0Jn;-L$c.7GeŔ$[\G Q ekuiQ3sC-=DƂg'P -6ue3ӥp1|4CS i <2Dv/`zM@ VZ LGCSA0uX .FqmgxtqE; } S] \,b4͏VI[P1Q- &8X`Lv4 ghzM H d .ȧiOA&Ç)[s?0zNA' iᅬ,.8]iA 9)׀@60⇉{L|`,DAz`vVC]\BfuM )n6LH1Lm4C8gNUgM 9@8M/l}D@M #c0FgU,֌aUvΙJ'o-,_øWzXy>ƞ 2HqFִ~]ZE]ǘcrU7x"v4~.iYu 짇j&,[g ~+ZX{L 5!L`nzk3$0RT ! \6M R5)/*uY8;ya2\d; :ve5YTz#sH2N]W Ihڙ0hG:D'IK00`6ߨN߀ F D4N0\ly% 1TNͺDȲ>4-#m=$yk #r:M)dt .*Nޝuh, X̖\g3d;}djT`!M%+A>fFƶFJ7+$#_( " 06\ݥM]6xmW!mlgFX,SS]h`p-3a r4ذw+Pr*2M=`HHD'A-`})SH=ͺЖ) 0tuWD30t,O3 Sx XKH("gF0 !Y8LZҥ :dp .x. >.foe  fCJ¦ūN8-vGrQ?cn*Ŝ k`y8DbGT[7g0&f]EnN23 5B8%PőO6*U`ڮkJX\ ifn.-ʴ s_;ZVYb?SjQ"]9Z.2)6x"b[W&k+ dCY[2jNl&CS  }WQanOPߖGu "ujhաD& p̠O..s6L+C2UM<}Wslϩ_MR͐](mu `m\u%r9:PCu>i]X9.$m* q\rPd=bdk:%Jqa[^rf* r~j\BM%CU0:` Lxy;q:/ǩ¸Q9^YI`2!fUF3D6._Ѡe )T<Y-U?IއH.zkr=V$X8NnUBҤ4.IjZZ_G2kekwW3)Yɕ0DWp&icf+=t+ PwoWRԪ:Vs^`zJ Wv~u9Ai;^ ;8}{jAr{խY]"ҟ&Zz@Vr>P3: q/ t0*`z2WpS!`쀯CĐ:EbGU vɐ=k{r.Rv*{Cx?dxc׬9`.!gƉ)Cx3. yȩ)y0#USם3 XϬ t73T*KB ]̀ B_u¸!`<G3`lG-O]+ agz4=;E'sΩr MWttq23ïK;]%pmoTJoqcDtŖx(d`7cCyY^"V3 &8r 1uOP4k1Cb' _ /j`-ÉdΞk y 2pD;H3ya fz`@K&(>[9FjP̻x 4{p{ZY[/~c*>8}38}B#p. !c6`#Kt2h $iIe] H|IC %`*)`CzН3u q çOrS@! &#U<]"#8[a*>C~*``88Ŝa Lp5e,r]w43VXD0urSܔpMLGcrpSR.ah<4a?V=WxiMvW\'3kЖ?e >^`{99@@4IENDB`$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -$$If!vh5h55h5#vh#v#vh#v:V -5h55h5/ 44 -@@@ NormalCJ_HaJmH sH tH DAD Default Paragraph FontRi@R  Table Normal4 l4a (k(No List<J#9{-.wx34  TWjm36TWrsv  3 6 U V Y i l y z { } ~   + , / N Q v w x  - . 1 I L ^ _ `    < = @ X [ m n o p   # & > ? B T W u v w ;>00000000000000000000000000 0 0 0 0 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 000 0 0 0 0 0 0 0 0 0 000 0 0 0 0 0 0 0 0 0 00000 0 0 0 0 0 0 0 0 0 000 0 0 0 0 0 0 0 0 0 000 0 0 0 0 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 000000000000#9{>Oy00My00My00Oy00 X <  rUy+v-^<m>u;< !"#$<>.5 x4;% ~ x ` h p x >333333333333333333333{T3  3 6 V z   , / N Q  . 1 I _  = @ X p  W w >>mathi-l=D?$-%  TWjm36TWrsv  3 6 U V Y i l y z   + , / N Q v w  - . 1 I L ^ _    < = @ X [ m n   # & > ? B T W u v >@;;X ;;<0@UnknownGz Times New Roman5Symbol3& z ArialE& Century Gothic"hVxVxl l #xx2443Q ?-l"University of Massachusetts BostonmathimathiOh+'0 $ @ L Xdlt|#University of Massachusetts BostonrnivmathisiathathNormalimathii3thMicrosoft Word 10.0@@,Ժh@,Ժhl ՜.+,0  hp|   r4A #University of Massachusetts Boston Title  !"#$%'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQSTUVWXYZ[\]^_`abdefghijlmnopqruRoot Entry FϵhwData &#W1TableRo!WordDocument%JSummaryInformation(cDocumentSummaryInformation8kCompObjj  FMicrosoft Word Document MSWordDocWord.Document.89q