CSE200 AU09 KREEVES                                  QUIZ#2                              SEAT# ____________

 

NAME _______________________________________________        Lecture:  TR 9:30-11:18am 

 

Lab section (check one):            _______ F 9:30-11:18am             ________ F 11:30-1:18pm

 

Instructions:

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

·         Put away all books, papers, calculators, cell phones and music devices.

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

·     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!

·     When time has run out you will be told to put all pens/pencils down. 

·     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 – unless otherwise noted.

 

 

 

 

 

    

 

 

 

CSE200 AU09 KREEVES           ANSWER SHEET QUIZ#2            SEAT# ____________

 

NAME _______________________________________________        Lecture:  TR 9:30-11:18am 

 

Lab section (check one):            _______ F 9:30-11:18am             ________ F 11:30-1:18pm

 

Q#

PTS

MINUS

QUESTION and ANSWER

1

3

 

Write an Excel formula in cell q2family!G5, which can be copied down and across to cell q2family!I22, which determines whether or not (i.e. TRUE or FALSE) cliff does at least one rafting trip.

 

 

 

2

3

 

 

Write an Excel formula in cell q2family!G23, which can be copied across to cell q2family!I23, which determines whether or not (i.e. TRUE or FALSE) at least one person takes a rafting trip.

 

 

 

 

3

5

 

 

Write an Excel formula in cell q2family!J5, which can be copied down to cell q2family!J22, which determines whether or not (i.e. TRUE or FALSE) cliff does at least one of each of the trips. REMINDER: A maximum of 3 trips are allowed to be taken per person.

 

 

 

 

4

8

 

Of the following formulas, determine which ones will correctly find the solution to the following: Write an Excel formula in cell q2family!K5, which can be copied down to cell q2family!K22, to determine if cliff is taking ONLY rafting trip(s).

a. =AND(G5,NOT(OR(H5,I5)))                    Correct?    Yes _______     No ________

b. = NOT(AND(G5:I5))                                    Correct?    Yes _______     No ________

c. =AND(G5=TRUE,H5=FALSE,I5=FALSE)    Correct?    Yes _______     No ________

d. =AND(G5,NOT(H5:I5))                         Correct?    Yes _______     No ________

 

5

7

 

 

Write an Excel formula in cell q2family!L5, which can be copied down to cell q2family!L22, to determine if cliff is doing all three trips and is either a parent or an individual.

 

 

 

 

 

6

6

 

Write an Excel formula in cell q2outings!F4, which can be copied down to cell q2outings!F12, to determine the number of miles the option 1 rafting trip is traveling. NOTE: This is one of the problems where the numeric solution cannot be explained. REMINDER: you will find conversion factors on the q2unit worksheet.

 

 

 

 

 

7

6

 

Write an Excel formula in cell q2outings!G4, which can be copied down to cell q2outings!G12, to determine the speed in miles per hour the option 1 rafting trip is traveling. NOTE: This is one of the problems where the numeric solution cannot be explained. REMINDER: you will find conversion factors on the q2unit worksheet.

 

 

 

 

 

8

4

 

I was trying to manipulate each of the mph values in column G to get a suitable numeric solution by changing one or more of the inputs affecting that value. Was I using a What-If analysis or a Goal Seek? Give the answer you think is correct (What-If or Goal Seek), then define the other option (the one you didn’t choose as the answer).

 

 

 

 

 

9

4

 

 

a.       What type of chart is shown on the q2chart worksheet?

 

 

b.      Give the data range used for the creating the chart. Be specific! No $ signs are necessary though.

 

 

 

10

2

 

 

Name one other type of chart that would work for the data shown on the q2chart worksheet… keeping in mind the definitions learned in class.

 

 

 

 

 

 

SCORE _____________/50