CSE200 WI09 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 in name/seat#/lab information correctly is worth 1 point.

· Put away all books, papers, and calculators. 

·   Turn off all beepers and cell phones.

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

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

· Don’t use a $ if NOT copying

· Only use the functions given. Be sure not to use IF structures for this exam.

· Your answer should update correctly when additional input data is added to the problem or when input data is changed. That is, all answers given should be “updatable” unless otherwise noted.

· Only use quotes when necessary – do NOT use quotes around Boolean values.

NOTE: You MUST turn in ALL the pages of your exam or it will not be graded.

CSE200 WI09 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

1. (5 pts) Which of the following formulas will work to determine if all of the orders have less than 3 scoops? Circle YES if the formula given will correctly determine if all the orders have less than 3 scoops.

YES NO =MAX(F3:F10)<3

YES NO =COUNTIF(F3:F10,">=3")=0

YES NO =COUNTIF(F3:F10,1)+COUNTIF(F3:F10,2)=COUNT(F3:F10)

YES NO =AND(F3:F10<=2)

2. (6 pts) Write an Excel formula in cell SCOOP!H3, which can be copied down and across to SCOOP!J10, to determine if a sugar cone was used for the raspberry chip flavor order.

3. (3 pts) Write an Excel formula in cell SCOOP!H11, which can be copied across to SCOOP!J11, to determine if someone ordered a sugar cone.

4. (5 pts) Write an Excel formula in cell SCOOP!I12 to determine if only sorbet orders use a waffle cone. NOTE: This question is considered “not updatable” to a certain degree. That is, cells SCOOP!B3:B10 will not change, however, your answer should be able to handle the cone type changing.

5. (7 pts) Write an Excel formula in cell SCOOP!K3, which can be copied down to cell SCOOP!K10, to determine if the raspberry chip ice cream order is healthy (true or false). An order is considered healthy if it uses 1 or 2 small scoops and has type sorbet or frozen yogurt.

6. (3 pts) Write an Excel formula in cell SCOOP!K13 to determine if all of the orders are considered healthy.

7. (7 pts) Write an Excel formula in cell SCOOP!K14 to determine the percent of orders that are considered healthy. The cell is already formatted for percent.

8. (7 pts) Write an Excel formula in cell SCOOP!L3, which can be copied down to cell SCOOP!L10, to determine the total number of calories for the scoops of raspberry chip ice cream. NOTE: Notice that in cell E2, the label shows the “calories per ½ cup”. This is your starting point. Be sure to include the ½ cup designation somehow in your solution; and don’t forget to check the UNIT worksheet for more information.

9. (6 pts) Write an Excel formula in cell CALORIES!B2, which can be copied down to cell CALORIES!B4, to determine the total calories for all the frozen yogurt orders.

SCORE _______________/50