CSE200 SP07 KREEVES QUIZ#1 SEAT# ___________

CSE200 SP10 KREEVES QUIZ#2 SEAT# ____________

NAME _______________________________________________ Lecture: TR 1:30-3:18pm

Lab section (check one): _______ F 1:30-3:18pm ________ F 3:30-5:18pm

Instructions:

· Filling out the correct seat# and lab section on both the test and the answer sheet is worth 2 points.

· Turn off all beepers, cell phones and anything else that you can turn off that might make noise.

· Put away all books, papers, calculators, cell phones and music devices. There WILL BE a point penalization with the possibility of a score of ZERO for not adhering to these directions.

· When time has run out you will be told to put all pens/pencils down. There WILL BE a point penalization with the possibility of a score of ZERO for not adhering to these directions.

· Read each question carefully and fill in the answer in the space provided. Answers must be legible or they will be marked incorrect. If there are multiple answers to choose from, please CIRCLE the correct answer. The question will not be graded at all if there are multiple answers to choose from.

· Please stay in the answer box for each question i.e. do not write an essay for a short answer problem!

· Be sure to use values as determined by previous problems and do not use values from problems that have not yet been solved per the ordering of the questions.

· Use cell references whenever possible and appropriate.

· Don’t use a $ if NOT copying

· Only use the functions given.

· Do not use unnecessary functions, for example =average(sum(a1:a5)). If you use an extra function that is not needed (the “average” function in the given example), it’s assumed that you thought it was necessary thus will be marked incorrect.

· Your answer should update correctly when additional input data is added to the problem or when input data is changed.

WORKSHEET DESCRIPTIONS

The Excel-lent summer job options file has all the summer job opportunities that you are considering as well as calculations that create new information to help you determine the best job from the list.

Q2jobs –The input data is given in the range A4:H11. For each job, the start and end date are given along with the salary for the given timeframe; the benefits column contains Boolean values where the TRUE means that you will receive some kind of benefits at that job.

Q2unit – This worksheet has conversion factors needed to calculate new data. Be sure to use the data given here as a cell reference (not a constant value). I understand that most of these values do not actually change, (except very possibly the value in A1) however this is being used as a learning experience so please be sure to “use cell references whenever possible”.

NOTICE: The functions you can use for this exam are listed on the worksheet page i.e. You can only use the AND, OR, and NOT functions on this exam.

CSE200 SP10 KREEVES ANSWER SHEET QUIZ#2 SEAT# ____________

NAME _______________________________________________ Lecture: TR 1:30-3:18pm

Lab section (check one): _______ F 1:30-3:18pm ________ F 3:30-5:18pm

Q#	PTS	MINUS	QUESTION and ANSWER
1	4		Write an Excel formula in cell Q2jobs!H12 which determines if at least one of the jobs on the list has benefits.
2	8		Write an Excel formula in cell Q2jobs!I4, which can be copied down to cell Q2jobs!I11, which determines the total number of days you will work at longhorn. NOTE: We cannot help you with the calculation on this problem as it gives the solution away. See the conversion factors on the Q2units worksheet. FYI: Remember that you can subtract two dates to get the number of day’s difference between them.
3	4		I want to work for exactly 60 days, i.e. 12 weeks, at longhorn. I can’t change the start date, so only the end date could be changed at this point. Is this a goal seek or a what-if analysis?
4	8		Write an Excel formula in cell Q2jobs!J4, which can be copied down to cell Q2jobs!J11, which determines yearly salary at longhorn. NOTE: We cannot help you with the calculation on this problem as it gives the solution away. See the conversion factors on the Q2units worksheet. HINT: Remember that you are not working 365 days per year, but 52 weeks at 5 days per week.
5	6		a. What type of chart is shown on the worksheet page? b. Give the data range used for the creating the chart. c. Name two other different types of charts, besides the one mentioned in part a above, as learned in class.
6	5		Write an Excel formula in cell Q2jobs!K4, which can be copied down to cell Q2jobs!K11, which determines if (true or false) longhorn is one of your top choice job opportunities for the summer. A job is a top choice job opportunity if the job has benefits and a yearly salary of at least $25,000.
7	5		Write an Excel formula in cell Q2jobs!K12 which determines if *NONE* of the jobs on the list are considered top choices.
8	8		Write an Excel formula (not shown) to determine if *ONLY* the job opportunities in OH are top choice job opportunities. NOTE: Due to the type of problem this is, the values in the state column cannot change, but everything else can change and your answer should still work.

SCORE _____________/50