ࡱ> DFABCq` @bjbjqPqP @N::7A 0000XXX {{{}D~\ K2pp(AAA$}hXA00ڥڥڥ0Xڥڥڥ6TXd ӊj{V&0K<ڣ8XDAϘڥϚAAApjAAAK   D``i   `i   000000 CIS 101 - Autumn 00 Final Exam KEY Points ____________/300 Name _______________________________________________ SS# _____________________ Lecture Time:_________________ Instructions: Fill in your name, ss#, and seat number on both the question sheet and answer sheets. Do not open your exam until it is time to begin. You will have 1hour and 48 minutes to complete this exam. Put away all books, papers, and calculators. Read each question carefully and fill in the answer in the space provided (next to the question). Answers must be legible or they will be marked incorrect. There are 11 pages in this exam - this sheet, 8 pages of questions plus two pages for spreadsheets and database tables. When you finish your exam bring it to the front of the room all pages must be turned in. Failure to do so will result in a penalty. You may tear off the spreadsheet and table page in order to work be sure to re-attach it when handing it in. When time has run out you will be told to put all pens/pencils down. Failure to do so will result in point penalization. It is required that you do not discuss this exam with any other student. Functions - to be used for Reference: Financial Functions FV(rate, nper, pmt, pv, type) NPER(rate, pmt, pv, fv, type) PMT(rate, nper, pv, fv, type) PV(rate, nper, pmt, fv, type) RATE(nper, pmt, pv, fv, type) Logical Functions AND(logical1, logical2,) IF(logical_test,value_if_true, value_if_false) NOT(logical) OR(logical1, logical2,) Other Functions AVERAGE(number1, number2, ) COUNT(value1,value2, ...) COUNTIF(range, criteria) MAX(number1, number2, ) MIN(number1, number2, ) SUM(number1, number2, ) SUMIF(range, criteria, sum_range) ROUND(number,num_digits) Lookup(lookup_value, lookup_vector, value_result_vector) General Topics/Short Answers (all questions are 2 points each): Multiple Choice Fill in the letter of the item which best completes each statement. A space is provided to the left of each question. _A____1. Protocol on the internet refers to ____. a. rules of communication b. backbone architecture of a WAN c. HTTP protocol d. none of the above __C___2.When setting up a relationship between two tables you create a ______. a. field property b. auxiliary key c. foreign key d. primary key ___D__3. A ______ is a field on a table for which a particular value should give a unique record a principle key b field property c. foreign key d. primary key __B___4. To change the toolbars which appear in Word , Excel, etc , you should select the following menus ______. a. Edit Toolbars b. View Toolbars c. Insert-Toolbars d. Tools ___C__5. A record is composed of data in a series of categories referred to as ______. a. databases b. files c. fields d. rows __B___6.When you close a document in a windows application ____. a. it is erased from hard drive disk b. it is removed from screen c. both a and b d. None of the above ___A__7. Use the _______ in Access to modify a query a. Design view b. Data view c. Print Preview d. none of the above __C___8. Use the ______ application when managing very large tables of related data a. Word b. Excel c. Access d. PowerPoint ___D__9. In order of precedence, the _____ is/are evaluated first. a. + and operations b. left most operations c. * and / operations d. expressions in ( ) _D__10. A query in access is capable of the following ______. a. summarizing data by group b. performing calculations on selected fields c. selecting specific records d. all of the above ABCD148A1/A$32643A1+A214 _A____11. Using the table above, what value would result in cell D2 if you copy the formula from cell C1 to D2? a. 4 b. B2/B$4 c. B2/A$3 d. 0.4 __C____12. Using the table above, what is the value of the formula B2>A1 a. #N/A b. TRUE c. FALSE d. 0 Fill in the Blanks 13. This function returns TRUE if one of its arguments is TRUE. ___________OR__ 14. Copying the formula =A$1*$B4+B2 in cell C2 to cell E5 results in the formula ____C$1*$B7+D5______ 15. What is the name of the tool available in Excel which does the following: _________Goal Seek_______ allows you to specify a desired result for a calculation allows you to specify a variable (cell reference) you wish to change to get that result returns the appropriate value for this variable that will ensure your desired result 16. Name the tool available in MS Word which allows you to write a form letter which includes selected fields from a database. This form can then be used to produce multiple letters with the data from the specified fields filled in for the appropriate record. ___________Mail Merge_ 17. Yesterday you placed an Excel spreadsheet into your Word document. This morning you updated the Excel spreadsheet. You now open the Word document and notice that the data in the Word document already includes the changes you made this morning. What feature did you use when copying this data? ______________________Object Linking_______ True or False Circle T or F for each of the statements below. 18. T F. The clipboard is erased when information is pasted into an application -- F 19. T F To change the precision of a value in Excel you can modify cell display -- F 20. T F A query can refer to more than one table -- T 21. T F The Mail Merge feature in Word will only work with an Access database. -- F 22. . T F It is possible to copy, delete and move files from Windows Explorer. -- T 23. . T F A byte is 10 bits of data -- F 24. T F .A monitor is an input device -- F. 25. T F In a Windows operating system it is only possible to open one application at a time. -- F Excel Problem Description (100 points): The spreadsheets for this problem can be found at the back of this exam. Use cell references whenever possible in your answers. You are going to complete a retirement analysis for the employees of XYZ Corporation. You will be determining each employees current annual salary, whether or not they are eligible to retire, and if they are eligible their yearly pension. To be eligible for retirement an employee must be at least 65 years old and have a minimum of 25 years of service. The yearly pension is 50% of the current annual salary. An employees salary is based on his or her salary code. On sheet salary! there is information regarding monthly salary for a particular salary code. On sheet req! there is information on the companys retirement qualification requirements and the pension due qualified employees as a percentage of annual salary. On sheet analysis! is a listing of your employees and their personal information. (15 points) Write a formula in cell analysis!F2, which can be copied down the column to determine the employees current annual salary. _______=LOOKUP(E2, SALARY!A$2:A$7, SALARY!B$2B$7)* REQ!B$6____ (10 points)Write a formula in cell analysis!G2, which can be copied down the column, to determine (True/False) if the employee is eligible for retirement. ___________=AND(B2>=REQ!B$3, D2>=REQ!B$4)______________ (15 points) Write a formula in cell analysis!H2, which can be copied down the column, to determine the employees annual pension after retirement. If an employee is ineligible for retirement the pension amount should be $0 (displayed as - in currency format). __________IF(G2, F2*REQ!B$5, 0)__________________________ 4. (5 points) Write an Excel formula to determine if (True/False) at least one person is eligible for retirement. Use a Boolean function. ________________=OR(G2:G9)___________________________________ 5. (10 points) Write an Excel formula to determine how many people are ineligible to retire at the current time? _______________=COUNTIF(G2:G9, FALSE)___________________________________________ 6. (5 points) Write a formula to determine the average annual salary for employees. _______________________=AVERAGE(F2:F9)_________________________________________ 7. (5 points) Write a formula to determine the number of years of service for the employee with the least seniority. _________________=MIN(D2:D9)_________________________________________ 8. (10 points) Jenkins started a college fund for his grandson 18 years ago by investing $200 dollars per month at 9% per year compounded monthly. How much is available for his grandson now?. _________________=FV(9%/12, 18*12, -200, 0)__________________________________ 9. (10 points) Hawkins has decided to buy a new sports car which costs $90,000. She is putting down 20% and financing the rest with a 7% per year loan over the next 5 years. The loan is compounded monthly. What is the monthly payment she will need to make? ____________________=PMT(7%/12, 5*12, 90000- 20%*90000, 0)____________________ 10. (15 points) Smith is saving for her retirement. She wants to determine how much she needs to set aside today in order to have $100,000 at the age of 65. She intends to put this money in a money market account which pays 8% per year compounded quarterly. She will be depositing an additional $150 per quarter into this account. Write an Excel formula to determine her investment today to reach this goal. ______________=PV(8%/4, (65-B2)*4, -150, 100000)____________________ Access Problem Description (150 points): Answer the following questions based on the database provided at the end of this exam (Airline database): These tables show part of the database for the USA Travel Agency. The Airlines table contains the details of the various airlines that it deals with. The flights table lists the details of flights that these airlines fly on. The details of passengers confirmed are in the Passengers table. The waitlisted passengers are given in the Waitlisted table Draw the relationship diagram among the tables. Indicate the primary key(s) if any, and the foreign keys that relate the tables. (25)    You are doing an analysis of carriers who fly to Columbus. Write a query to list the names of Airlines flying to Columbus. (15) Tables Required: ______Arline, flights___________ Join on (foreign keys):_______Airline___________ FieldNameToTableAirlineFlightsTotalSortShowXCriteriaColumbusOR American and Delta use the same caterer. This caterer needs a list of the Vegetarian passengers (Veg) on Delta Airlines flights and on American Airlines. Write a query to list those names for the caterer. Include the passengers Last name, flight number and the airline they are flying. (25 points) Tables Required: ____________Passengers, Airline, Flights________________________________ Join on (foreign keys):___________Flight, Airline___________________________ FieldLast NameFlightNameMeal PrefTablePassPassAirlinePassTotalSortShowXXXCriteriaDelta OR AmericanVegOR TWA has asked you to prepare a list the passengers on TWA flights. The list should include the passengers last name, confirmation number and flight number. Sort the list (highest first) by flight number, then alphabetically by passengers last name. (25) Tables Required: ________Airline, Passenger, flights_________________________________ Join on (foreign keys):_____Flight, Airline_______________________________________ FieldflightConf no.Last NameNameTablePassPassPassAirlineTotalSortDescendingAscendingShowXXXCriteriaTWAOR As part of your industry analysis you would like to compile a list summarizing the number of passengers for each flight. You list should include the flight number and total of passengers on that flight. (20 points) Tables Required:_________Passenger____________________ Join on (foreign keys):______________________________________________________ FieldFlightConf No.TablePassPassTotalGroup ByCountSortShowXXCriteriaOR In this query you will try listing all passengers whose last name begins with in the letter M or D. (20 points) Tables Require: __________Passenger_________________ Join on (foreign keys):________________________ FieldLast NameTablePassTotalSortShowXCriteriaLike M* OR Like D*OR Using the results of query 5 and any other tables create a list that includes the flight number and total dollar amount of revenue (ticket price times number of passengers on that flight) (20 points) Tables Require: _________Query 5, Flights_____________ Join on (foreign keys):_______flight_______ FieldFlightRevenue *TableQuery 5 / FlightsTotalSortShowXXCriteriaORAdditional room for calculations if required: *Revenue : [Query 5] ! [Count Of Conf No] * [Flights] ! [Ticket Price]   USA Travel Agency Database The following tables are part of the database for the USA Travel Agency. The Airlines table contains the details of the various airlines that it deals with. The flights table lists the details of flights that these airlines fly on. The details of passengers confirmed are in the Passengers table. The waitlisted passengers are given in the Waitlisted table. Airlines Airline#Name1Delta2United3American4USAir5TWA Flights Flight No.AirlineFromToModelDepartureArrivalTicket PriceAvailable23452WashingtonColumbus7477.409.40$357No67854PittsburgSeattle73719.4023.50$489No8888.5PittsburgSeattle7379:2510:25$525Yes67543New YorkLA74717:3520:53$399Yes Passengers Conf. No.FlightSeat No.Last NameFirst nameMeal PrefPhone number24567123458ClintonBillNon-Veg4444444456789678519ClintonHillaryVeg8888888907865888832ColemanMichaelNon-Veg7777777678954675444BlairTonyNon-Veg6666666678956.6754.13SpearsBrittany3843849948583888833VoinovichJohnVeg3948322 Waitlisted FlightWaitlist orderLast nameFirst namePhone number23451BushGeorge678954323452CheneyDick678932167851Gore Al567891267852 .LiebermanJoe2847384      DATE \@ "M/d/yy" 6/6/05 page \* arabic3 Sheet:analysis! Sheet:salary! Sheet:req! Airlines Primary key(s): Airline# Foreign Key: none Passengers Primary key(s): Conf No. Foreign Key: Flight Waitlisted Primary key(s): None Foreign Key: Flight Flights Primary key(s): Flight No. Foreign Key: Airline  #$,DEL P P     . 0 : L N X k w y FGĻٰٻٰ٠h 56CJ h 6CJ h 5CJh CJOJQJ h CJh 5OJQJ\h 5OJQJh 5CJOJQJh CJ OJQJh OJQJ!h*CJ\ h 5CJ h CJ\ h CJ\h 5>*CJh 5OJQJ h CJ h 5CJ h 6CJ6m=>^_`WP "^`" ! h^h`j]+m $$Ifa$$IfYSJJJJ $$Ifa$$Ifkd$$Iflrh FF04 la   YSJJJJ $$Ifa$$Ifkd$$Iflrh FF04 laYSJJJJ $$Ifa$$Ifkd$$Iflrh FF04 la !"YSJJJJ $$Ifa$$IfkdR$$Iflrh FF04 la"#&':;YWQWQWWOW !kd$$Iflrh FF04 la 'i9WCdY^OT[ v{}! !!h!l!""Y"""#!#"######%%!%<%%%%%ȵ hf5CJ h 5CJh 56CJ\]h 5CJ\h 5>*CJ hfCJ h CJhfhYh mHsH h 5\h D;_GH6fg_`UV ! & Fx|}~()!!_!"X"Y"""!#"#####%$a$ & F & F%%<%%%&{&|&&&"'#'s't''''1(2((((B)C)G*H*I***$a$%&{&|&&&#'+'I'r'''(0(( ))A)I*P*o****7,g,|,},~,,-#-'-Y-c---'.1.d.p.///// / ////////0 0000ѷѩћѩїїїїїїhBjhBUmHnHujh UmHnHuh 56\] h 5\h 5>*CJh hBhB5B*CJph hB5CJ hf5CJ h CJ h 5CJ;*5,6,7,|,,-w.x.///// / / / ////////00 d$Ifx< & Fx<0000 003kd$$Ifl4Nֈ* tF$8x04 la^f4 d$If00000 03kd$$Ifl4ֈ* tF$8x04 la^f4 d$If 0&0'0(0)0*0+0 d$If0&0(0,070<0A0B0R0\011 2&2I2R2S2Y2Z2^2_2h2q2u2v2z2{222222222222222222244G4k444444444444444444445 5555555#5(5(6166666666h$hBjh UmHnHuhYh mHnHuh V+0,010203040<0000 d$IfgdqS;kd|$$Ifl4ֈ* tF$8x04 la^f440506070A00' d$IfkdK$$Ifl4 ֈ* tF$8x04 la^f4 d$IfgdqS;A0C0D0E0F0G0 d$IfG0H0Q0R0]0^0<3333 d$Ifkd$$Ifl4 ֈ* tF$8x04 la^f4^0_0`0a0d0e03kd$$Ifl43ֈ* tF$8x04 la^f4 d$Ife0f0g0h0i0j03kd$$Ifl43ֈ* tF$8x04 la^f4 d$Ifj0k011B2C2I2S2Z2_2i2j2 d$If & Fx<x< j2k2q2v2{22<3333 d$Ifkd $$Ifl4Nֈ* tF$8x04 la^f42222223kdV $$Ifl4ֈ* tF$8x04 la^f4 d$If2222223kd% $$Ifl4ֈ* tF$8x04 la^f4 d$If2222222 d$IfgdqS;222222<3333 d$Ifkd $$Ifl4 ֈ* tF$8x04 la^f42222223kd $$Ifl4 ֈ* tF$8x04 la^f4 d$If2222223kd $$Ifl43ֈ* tF$8x04 la^f4 d$If2222222 d$If2223@44<6-66 & Fx<x<kda$$Ifl43ֈ* tF$8x04 la^f444444444 d$Ifx<444444<3333 d$Ifkd0$$Ifl4Nֈ* tF$8x04 la^f44444443kd$$Ifl4ֈ* tF$8x04 la^f4 d$If4444443kd$$Ifl4ֈ* tF$8x04 la^f4 d$If4444555 d$IfgdqS;555555<3333 d$Ifkd$$Ifl4 ֈ* tF$8x04 la^f45555 5!53kdl$$Ifl4 ֈ* tF$8x04 la^f4 d$If!5"5#5)5*5+53kd;$$Ifl43ֈ* tF$8x04 la^f4 d$If+5.5/505152535 d$If3545556F66<6-66 & Fx<x<kd $$Ifl43ֈ* tF$8x04 la^f46666666 d$If666666<3333 d$Ifkd$$Ifl4Nֈ* tF$8x04 la^f466666666666666777788888%8*8/808?8U8I9Y9o99999999999999999;:::::::::źh 5>*CJjh U jh 5>*UmHnHuh 5OJQJhK0wh B*phhK0whK0wB*phhK0wjh UmHnHuhYh mHnHuh$mHnHuh h$86666663kd$$Ifl4ֈ* tF$8x04 la^f4 d$If6666663kdw$$Ifl4ֈ* tF$8x04 la^f4 d$If6666666 d$IfgdqS;666666<3333 d$IfkdF$$Ifl4 ֈ* tF$8x04 la^f46666773kd$$Ifl4 ֈ* tF$8x04 la^f4 d$If7777773kd$$Ifl43ֈ* tF$8x04 la^f4 d$If7 7 7 7 777 d$If7777<2) & Fx< hx<^hkd$$Ifl43ֈ* tF$8x04 la^f47777777777 d$Ifx< 778 8 8 8<3333 d$Ifkd$$Ifl4Nֈ* tF$8x04 la^f4 8 8 88883kdQ$$Ifl4ֈ* tF$8x04 la^f4 d$If8888883kd $$Ifl4ֈ* tF$8x04 la^f4 d$If88 8!8"8#8$8 d$IfgdqS;$8%8/8182838<3333 d$Ifkd$$Ifl4 ֈ* tF$8x04 la^f438485868?8V83kd$$Ifl4 ֈ* tF$8x04 la^f4 d$IfV8W8X8Y8Z8[83kd$$Ifl43ֈ* tF$8x04 la^f4 d$If[8^8_8`8a8b8c8 d$Ifc8d8e809g99<6-66 & Fx<x<kd\$$Ifl43ֈ* tF$8x04 la^f499999999 d$Ifx<999999<3333 d$Ifkd+ $$Ifl4Nֈ* tF$8x04 la^f49999993kd $$Ifl4ֈ* tF$8x04 la^f4 d$If9999993kd!$$Ifl4ֈ* tF$8x04 la^f4 d$If9999999 d$IfgdqS;999999<3333 d$Ifkd"$$Ifl4 ֈ* tF$8x04 la^f49999993kdg#$$Ifl4 ֈ* tF$8x04 la^f4 d$If9:::::3kd6$$$Ifl43ֈ* tF$8x04 la^f4 d$If::: : : : : d$If : :;:::<666x<kd%$$Ifl43ֈ* tF$8x04 la^f4::::::::<<#<$<-<2<$If h^h` :::::::;P;Y;;;<<?????????????????????????????@ԻԷssh 5B*CJ\aJph h CJh OJQJh=;CJOJQJmHnHuh CJOJQJjh CJOJQJUhsjhsU h 5\h 56\]h h 5>*CJ jh 5>*UmHnHujhj8|UmHnHu+2<3<5<;<vpp$Ifkd%$$Ifl0 p 064 lap;<<<><E<$Ifnkd&$$Ifl0 p064 laE<F<H<Q<$Ifnkd3'$$Ifl0 p064 laQ<R<T<Z<$Ifnkd'$$Ifl0 p064 laZ<[<]<a<$Ifnkd]($$Ifl0 p064 laa<b<c<k<l<w<<<<<<<<<<<Ff+$Ifnkd($$Ifl0 p064 la<<<<<<<<<$If<< kd9.$$Ifl `|A djb$#Bl06$$$$4 la<<<<== ====$If == kdh/$$Ifl `|A djb$#Bl06$$$$4 la=!=#=-=5=9=>=D=I=M=$If M=N= kd0$$Ifl `|A djb$#Bl06$$$$4 laN=S=U=^=a=e=k=q=v=z=$If z={= kd1$$Ifl `|A djb$#Bl06$$$$4 la{=|==================Ffq4$If==>> >2,,,$Ifkd6$$Ifl֞8v gXI:,">064 la >>>>&>$If&>'>.>3>6>2,,,$Ifkd7$$Ifl֞8v gXI:,">064 la6>>>F>N>V>$IfV>W>^>c>f>2,,,$Ifkd_8$$Ifl֞8v gXI:,">064 laf>l>q>y>>$If>>>>>2,,,$Ifkd89$$Ifl֞8v gXI:,">064 la>>>>>$If>>>>>2,,,$Ifkd:$$Ifl֞8v gXI:,">064 la>>>>>$If>>>>>20.0kd:$$Ifl֞8v gXI:,">064 la>>>???$If??#?$Ifkd;$$IflrX h 2064 lap2#?%?*?1?9?:???A?H?M?Rkd<$$IflrX h064 la$If M?U?V?[?]?c?f?n?Rkdx=$$IflrX h064 la$Ifn?o?t?x????XRRRRR$Ifkd>$$IflrX h064 la??????????XVVVVVVVVkd>$$IflrX h064 la ?????????????@@@!@.@3@4@?@@@P@Y@f@m@n@y@7$8$H$ !@ @!@3@P@m@@@@@@@@@@h hBy@z@@@@@@@@@@@@@@@5 000P/ =!"#*$T% K 000P/ =!"#*$T% P0 (/ =!"#8$% A 0/ =!"#8$% P0 = 0/ =!"#8$%0 $+ 0/ =!"#8$% A 0/ =!"#8$% P0 + 0/ =!"#8$% A 0/ =!"#8$% P0 = 0/ =!"#8$%0 $A 0/ =!"#8$% P0 + 0/ =!"#8$% A 0/ =!"#8$% P0 3 0/ =!"#8$%0 $A 0/ =!"#8$% P0 3 0/ =!"#8$%0 $A 0/ =!"#8$% P0 + 0/ =!"#8$% A 0/ =!"#8$% P0 + 0/ =!"#8$% A 0/ =!"#8$% P0 1 0:p=;/ =!"#$% A 0/ =!"#8$% P0 + 0/ =!"#8$% A 0/ =!"#8$% P0 + 0/ =!"#8$% A 0/ =!"#8$% P0 + 0/ =!"#8$% `!2qkclG WR8.0x\lW~{޹[UqHW6pgלh8tj$m.ػ]XtQKFQBQ%@Tw"i2H;prܦRU*W47ybwͼC@ C%D2$Hc+oIqcKp :C˂A " J~u K*:K9K?^Ut7dYFd2֬Y֭[:::І ͛сSO=,ڹs'r?} }rUdU 5_Hb8R Z  ,H qo~؎{1)@lހR ) RAzHb8-H qT m  mR 5R0Hb8XH q,kqk`PW2Vܕ Gƶ@ m[-`< PX r}Ѓ8IP6CgQ =8RA\ Pz  PX  PbX  A^d,H q@0,\G!=Hb8xHb8X׬vpG.:tV_F: OЧ~>s_ ݽ{9_|YDh8 ?qd腨'_^T"M:94t_G X9[^QVBI80]tS:@]oXf"K6b5a51K6b[l-s;;H ; cqFy={>mE⒍{ D{co5 aTⱸd#vc`CXCeXC⒍ V`+!<7·YaZ<l9[aqv)=K6b!=h  ƠNŖ[t~{MBd@Dz62lVDza_켇}3o&켇}ahDz7x QCɮɱ8sidV2TSI*rgT5Ò5keWkPNдͿO"62(TcON:ӽt?XnνVt@wKD%\fH kv45ztQ,Uvq͹$z(eHa5saTaWc+1ďh<զLA^B%-?Cʹ#k###ˠof#:siOVrGVm탷zҳ š?Or`^Fkͼ^Z^lב< c_{.?HZFZ;pűҤiC-1ߥZqaXڨ=&+$لoct]̪Zj/d2,܁2bӎ!rЦwe[ƞS> D 6+M_h =6sS.CӤO<5<6H *HcfFPWކo&7ظX(r40trr2_$<gYC-:*OMs']5^Lԕ謮wtsτz~~{?cGƞϛѨX΢mNV#ɧg_}fa̅:g \OoXki8>?lVMybrԏFmi>ө -*{ !K1,[8`DoV~bz񛌜[d%Go:Tb8-Dm]]]fpd8zJ&K#'A#3:SISN -ܦEFئ O(V[mˠtչ`w\]R˽blnBY]yK>ADʽ~{);_nCr!Nlׇ)3ZZ=-iDL# Ǣ  1ȢgD"C|8골B͒CDh\2<T)z,KU?rVEa+bInd[n&Nq&ɤ eRLDbR%Is&UBLz3L<&trh~/WHg;,I2w{|yi7YC+ž)g&)*͋4uEMeb\6/z̠]Xki>2#n$:n@Ğaɍ={ccEöذDX{%_)ذD[V2^OVcH,d@IF>Y)."蓕Ep'+=o<[hIjn#3xu]wm~4Jsb'մXFϴ}6, qer>@Y-}d}XgGs:6>n> = &? ]v T$'Mʃ)6Is Fm蠾[vt?uҾީw֪,\}X|]u3莞m}$&2UAը ڮ~o͢]!aO&NNSyu>Xϙp_Dh~/:}=n>B~o&8X=eBf0\xs}Kl}H]om伿Ύgf}lmrDd 76cOńβyd2W<\.݌8{m<_HQ>tY9jF {uV[we,G~Z͒zMsSѬ@6 f}Qzm:u6ؿG{wͅ䙣Y㧼%ȁfT,Gn2{ S y%7vlޝY]o|sFp˝El|=*W"qp vȰ[xV1ϱ`e.cAʰ#j(^~kDoK.m 1Gq#gx;3|gt<9팞;vc`Biz;3|gt<|"Xo紷3zǞaoq&[!q>R23a`CXCeXC [i;;f5jX\23aM63lJ⒋GRgg3QG.z1}J_DOO(}ceCWeZ !t`!Rנo*5G\%uh8' x͗MhUGϽwrˇmCKI3"5טF"5 (. iyc6ȢdM &qɪ:VH)HW*LgyW-d3gތ9TOzs @}r\cm gWeC|1GccLESQc*Y]]W[$/͊&,ZZZD[[hoogΜ'NW9yRӷB?4by h@H$P@HA( =І  ~($P@HB( Ё h`X3Ѐ@$D.H"D.Ё h`I@4  H2Ѐp,c(pB|paMB᪁A;Wh`i@ЁdW xux9pN54A@}t`&H$P@@p.Ёa %j.9h`I#U6)@404t  4Tjc`y] 1s#ibzzZ\|YܺuK )ݻ'|uS)k=eB ϟoz hK5?KY{걻qj]Yo3oYZ7q-ܤݴEG_6p۴RSubW>宙5ꚩreؕq\ܧܵR]kU>/vyi.SM\*pRaZkg]E]&O5粒6(Oe~.904P?É_D V Gwm:#nt%ʀ*A,FʁDpC;Qr Dii~'QceJ=QX7SvG9~zXʟހ[;A\#߹cskS8~vvZ}ܴl ѓ>uaƽ/$gvLwch}/dt~gC! yE[G+s%L+]5x]pd[MjAd~XurC#C㓹k؝Jǒu'\+bx;7Kum=cWG;}f[ξo}gslsuxpɝ-}^̝rZٖm2nw;[MmdaΣU6o,yu=z_Zxu"FkW!lԈǮE?-V:1Zki]uk=յ^:ĮN\kƮF7}]wםTם*/v\GJu5u5q9/οx sʬ]ƫVwp[V[+#,-`!O[]!@%UDD(/!px͘OhWY7IUlc lB qY3@D=Eи4=»*Уx>h+$Vm "TҮ¯7fCV?;o{7/F",a #9hI=҄#Vxǽhm'f{qNr91,,,¯ 4C$^LF-[Ȏ)]ѣGȈ?|\1q6whS4@yr!|տᾂXgs⦆l IoSܛ$=ԯ9N^q".y_7Mo.Jb=Mқ-B&ͽ@zsz{cHoh^ҫ{D^+4NCk}-"OW+$R&$ W} |MӻW1v'עOݍߔB>ݭT$o}Qv̳T~[j8}} >:@ښjRZJu-չ9k5ծ5ꚭs*\5&R]unni.[vVU~߯qZkEVDl+>,^x7 z!R ~W})G+ )F$$If!vh55F5F55#v#vF#v#v:V l055F554$$If!vh55F5F55#v#vF#v#v:V l055F554$$If!vh55F5F55#v#vF#v#v:V l055F554$$If!vh55F5F55#v#vF#v#v:V l055F554$$If!vh55F5F55#v#vF#v#v:V l055F554$$If^!vh585x5555#v8#vx#v:V l4N0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4N0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4N0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4N0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4N0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4N0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l40585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l4 0585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If^!vh585x5555#v8#vx#v:V l430585x54a^f4$$If!vh55p#v#vp:V l 0655p4p$$If!vh55p#v#vp:V l0655p4$$If!vh55p#v#vp:V l0655p4$$If!vh55p#v#vp:V l0655p4$$If!vh55p#v#vp:V l0655p4$$If!vh55p#v#vp:V l0655p4$$If!v h5555#555B5l5 #v#v#v#v##v#v#vB#vl#v :V l Z065555#555B5l5 4pZkd)$$Ifl `|A djb$#Bl Z06$$$$4 lapZ-$$If!v h5555#555B5l5 #v#v#v#v##v#v#vB#vl#v :V l065555#555B5l5 4-$$If!v h5555#555B5l5 #v#v#v#v##v#v#vB#vl#v :V l065555#555B5l5 4-$$If!v h5555#555B5l5 #v#v#v#v##v#v#vB#vl#v :V l065555#555B5l5 4-$$If!v h5555#555B5l5 #v#v#v#v##v#v#vB#vl#v :V l065555#555B5l5 4z$$If!vh55>55555#v#v>#v#v:V l F0655>554pF:kd2$$Ifl֞8v gXI:,"> F064 lapF$$If!vh55>55555#v#v>#v#v:V l0655>554$$If!vh55>55555#v#v>#v#v:V l0655>554$$If!vh55>55555#v#v>#v#v:V l0655>554$$If!vh55>55555#v#v>#v#v:V l0655>554$$If!vh55>55555#v#v>#v#v:V l0655>554$$If!vh55>55555#v#v>#v#v:V l0655>554$$If!vh55555#v:V l 20654p2$$If!vh55555#v:V l0654$$If!vh55555#v:V l0654$$If!vh55555#v:V l0654$$If!vh55555#v:V l06548@8 Normal_HmH sH tH >@> Heading 1$@& 5>*CJ$F@F Heading 2$@&5>*CJ\aJDAD Default Paragraph FontVi@V  Table Normal :V 44 la (k(No List 4@4 Header  !4 @4 Footer  !8B@8 Body TextdhCJ6P@"6 Body Text 2CJXC@2X Body Text Indenth^h` CJOJQJ|>@B| TitleL$$d%d&d'dNOPQa$ CJ$OJQJTQ@RT Body Text 3 7$8$H$5B*CJ\aJph ,b 8`_^ihjk ,b ^`W  P   ] + m &8 * 7* * * * 0+ ]+ + + , O, , , - 7- z- - - . b. . . / H/ u/ / / (0$%&DEF{|P9:XYk";Tm=>^_`W  P   j  ] + m     !"#&':;_GH6fg_`UV|}~()_XY!"<{|"#st1 2 B!C!G"H"I"""5$6$7$|$$%w&x&''''' ' ' ' ''''''''((((( (((((( (&('((()(*(+(,(1(2(3(4(5(6(7(A(C(D(E(F(G(H(Q(R(](^(_(`(a(d(e(f(g(h(i(j(k())B*C*I*S*Z*_*i*j*k*q*v*{*****************************************+@,,,,,,,,,,,,,,,,,,,,,,,,,,,----------- -!-"-#-)-*-+-.-/-0-1-2-3-4-5-.F...................................../////// / / / ////////////////0 0 0 0 0 0000000000 0!0"0#0$0%0/0102030405060?0V0W0X0Y0Z0[0^0_0`0a0b0c0d0e001g11111111111111111111111111111111111111112222222 2 2 2 2 2;222222222244#4$4-4243454;4<4>4E4F4H4Q4R4T4Z4[4]4a4b4c4k4l4w4444444444444444444444455 55555!5#5-55595>5D5I5M5N5S5U5^5a5e5k5q5v5z5{5|555555555555555555566 6666&6'6.63666>6F6N6V6W6^6c6f6l6q6y6666666666666666666666667777#7%7*71797:7?7A7H7M7U7V7[7]7c7f7n7o7t7x7777777777777777777777777888!8.83848?8@8P8Y8f8m8n8y8z88888888888888000000000000 0 0 0 0 0 0 0 0000000000000:00Y000000000"0"0"0"0"0"0"0"0"0"0"0"0>0>0>0>0>0>0>0>0>0>0>0>0>0>0>0>00>0>0>0>00>0>0>0>0>00>0>0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0>0>0>0>0>0>0"0*0*0*0* 0* 0* 0*0*0*0*0*0*0*0*0*000000000000000000000000000 0 0 00 0000 0000 0000000000000000000000000000000000000 0000000000 00000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @0 @0 @0 @0 @0 @0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @0 @0 @0 @0 @0 @0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @0 @0 @0 @0 @0 @0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000000000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00I00I00@0I00@0I00@0I00@0@0I00I00d0I00B0I00B0I00000000I00000000I00000000I00B000000I000  "#((( (+(,(6(7(G(H(`(a(i(j(j*k*************,,,,,,----*-+-3-4-..........////// 0000$0%05060Z0[0c0d0111111111122 2 22434;4<4E4F4Q4R4Z4[4a4b4444455M5N5z5{55555&6'6V6W66666667797:7U7V7n7o7778K0pbJzJJJ K0JzJJJ K0<JzJJJ K0tJzJJJ K0 fJzJJJ K0  4gJzJJJ K0  lgJzJJJ I00IBJzJJJI00JzJJJK0h@ 0?@K0؃@ 0?@K0@ 0?@K0H@ 0?@K0@ 0?@I00w@ 0?@ I00B@ 0?@K0 !(@0N NK0"#@@0N NK0$%@@0N NK0&'@@0N NK0()4A@0N NI00 ~@0N N I00B@0N NK0. /A@0 K00 1B@0 K02 3p@0 K04 5@0 K06 7@0 I0 0 dB@0 I00B@0K0< =l@0+K0> ?l@0+K0@ Al@0+K0B C0l@0+K0D Ehl@0+I00\@l@0+ I00Bl@0+K0JKtE@1 K0LME@1 K0NOE@1 K0PQF@1 K0RSTF@1 I0B@1 I00B@1K0XYF)L)A K0Z[4G. K0\]lG.AA K0^_Ga 0 K0`a LNttXj7 < K0bc  0 30< K0de 1 (o ^ K0fg8  K0hip  K0jk  K0lm  K0no K0pqP K0rs K0tur~ K0vwXj7 | \ K0xyh8<a K0z{( 0 K0|}! # Xj7 P~ K0~ 0 3 6< K0HQ~ &>6>V>f>>>>>>>?#?M?n???y@@"$&'()*+,./02345789:;<=>?@ABCDEFGHIJKLMNOPQRTUVWXYZ[\]^_`abcdefghijklmnoprstuvwxyz{|}~@# &)8:C!st2$qkcl:U02$lj<ǡHyb$v $RMP' 2$נo*5G\%uZAb$ZOg(Db$~tRL 2$cRmt2$[]!@%UDWG2$*d>*@@)s(  V , C 1?"V - C 1?"V . C 1?"V / C 1?"V 0 C 1?"V 1 C 1?" V 2 C 1?" V 3 C 1?" V 4 C 1?" V 5 C 1?" V ; C 1?"V < C 1?"V = C 1?"V > C 1?"V ? C 1?"V @ C 1?"V A C 1?"V B C 1?"V C C 1?"V D C 1?"V Y C 1?"V Z C 1?"V [ C 1?"V \ C 1?"V ] C 1?"l ^ 0^̙" l _ 0_̙# l ` 0`̙' < a # A%< b # A$H h # h H i # i H j # j H k # k V l C 1?"!V m C 1?" V n C 1?"V o C 1?"V p C 1?"J s # A"`&B S  ?''' '7(8(9(:(;(*****-----.....%0&0'0(0)0111112222228ja^th,E Vti, tk iBt/X s"t.sHt0hst- s t,Xst4X s"t3sHt5hst2 s t1Xst>X s"t=sHt?hst< s t;XstCX s"tBsHtDhstA s t@Xst\X s"t[sHt]hstZ s tYXstoX s"tnsHtphstm s tlXst^y*t_PtbM  4a }= 4s!T`u st/ykZ0ykt1ykx2yk<3ykԬ 4yk5yk6yk7ykC[8yk\^9yk :ykW;yk yk?yk @yk\AykBykxCyk DykwEykl Fyk, Gyk Hyk\xIykxJyk ?'?'''S(S(2244444444#5#5-5-5U5U555 6 6668     G'G'''[([(2244444455,5,54545]5]55566668 9*urn:schemas-microsoft-com:office:smarttagsStateV*urn:schemas-microsoft-com:office:smarttagsplacehttp://www.5iantlavalamp.com/8*urn:schemas-microsoft-com:office:smarttagsCityB*urn:schemas-microsoft-com:office:smarttagscountry-region   %)?CJL- 3 &hk''((d*h***.1.555566J6M6u6x66677777777777777777778,2!:?ko"*;?TXmqGMIJW X h i z {   = > Z [  *   m n  %S^69oq X[ch$mrMP&) LQ;C ! !^"b"F$I$/%<%&&((r+}+. .<2E2Y2[2o2r2t7w777777777777777777777.828P8X883333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333339 - 4 #9&x&&''''k())C**++,5-./w/?0[0e01 2377777777777777777777777!828Y8l888888- 3 777777777777778 p$VM-d2Grona/ڱ|{8v]9|n@UFz rOJ c  hh^h`OJQJo( 88^8`OJQJo(o ^`OJQJo(   ^ `OJQJo(   ^ `OJQJo(o xx^x`OJQJo( HH^H`OJQJo( ^`OJQJo(o ^`OJQJo(hh^h`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.0^`0o(.88^8`.L^`L.  ^ `.  ^ `.xLx^x`L.HH^H`.^`.L^`L.^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.h^`o(.h^`.hpLp^p`L.h@ @ ^@ `.h^`.hL^`L.h^`.h^`.hPLP^P`L.h hh^h`OJQJo(h 88^8`OJQJo(oh ^`OJQJo(h   ^ `OJQJo(h   ^ `OJQJo(oh xx^x`OJQJo(h HH^H`OJQJo(h ^`OJQJo(oh ^`OJQJo(hh^h`CJOJQJo(.hhh^h`.88^8`.L^`L.  ^ `.  ^ `.xLx^x`L.HH^H`.^`.L^`L. hh^h`OJQJo( FM-ro]9 cp$ > rOJa/|{8n<                   X        F*8K                 F*8K                            $ =;qS;4E4F4H4Q4R4T4Z4[4]4a4b4l4w4444444444444444444444455 55555!5#5-55595>5D5I5M5N5S5U5^5a5e5k5q5v5z5{55555555555555555566 6666&6'6.63666>6F6N6V6W6^6c6f6l6q6y66666666666666666666667777#7%7*71797:7?7A7H7M7U7V7[7]7c7f7n7o7t7x77777777778@/ / / / 8@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New;Wingdings"1hss4&ssKF/dKF/d!4du7u7 2QHX?j8|22CIS200  Homework #1  Simple Formulas & FunctionsOhio State University Debra Gross8         Oh+'0   4@ ` l x 4CIS200 Homework #1 Simple Formulas & FunctionsOhio State University Normal.dot Debra Gross7Microsoft Office Word@`4<@.ãa@tc@vjKF/՜.+,00 hp  Ohio State Universitydu7 3CIS200 Homework #1 Simple Formulas & Functions Title  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./02345678:;<=>?@ERoot Entry F؊jGData U?1TableWordDocument@NSummaryInformation(1DocumentSummaryInformation89CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q