CSE200 SP08 KREEVES QUIZ#2
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.
· Your answer should update correctly when additional input data is added to the problem or when input data is changed.
· All answers given should be “updatable” unless otherwise noted (see above bullet).
· Do not use extra IF structures. An example of using an extra IF structure is IF(cond,true,false) when just the condition would be the correct answer.
· Only use quotes when necessary – do NOT use quotes around Boolean values.
DIRECTIONS: Instead of pricing per level (like the previous
quiz/problem), the current pricing is based on the type of the tutor as either
U (undergrad), G (grad) or O (other).
FUNCTIONS AND(logical1, logical2,…) OR(logical1, logical2,…) NOT(logical) IF(logical_test,value_if_true,
value_if_false)
NOTE:
YOU CAN KEEP THIS PAGE BUT BE SURE TO TURN IN THE PAGE WITH THE ANSWERS ON IT
:O)
CSE200 SP08 KREEVES QUIZ#2 SEAT# ____________
NAME _______________________________________________ Lecture: TR 1:30-3:18pm
Lab section (check one): _______ R 3:30-5:18pm ________ F 1:30-3:18pm
1.
(6 pts) Write an Excel
formula in cell tutors!D5, which can be copied down and across to cell
tutors!F11, to determine if jon is an undergrad tutor.
2.
(7 pts) Write an Excel formula in cell tutors!G5, which
can be copied down and across to cell tutors!I11, to determine how much money,
if any jon will earn/hr as an undergrad tutor. NOTE: how much they earn as each
type of tutor is in cells tutors!G3:I3 and they only earn money if they are the
appropriate type of tutor.
3.
(5 pts) Write an Excel formula in cell prices!D3,
which can be copied down and across to cell prices!F7, to determine the
equivalent earning/hr yuan amount for a Chinese undergrad tutor.
FYI: the earnings per week by both type and level are given respectively
in columns J and K.
4.
(4 pts) Write an Excel formula in cell tutors!L5, which
can be copied down to cell tutors!L11, to determine (true/false) if jon earns
more when calculating weekly earnings by level.
5.
(6 pts) Write an Excel formula in cell tutors!M5, which
can be copied down to cell tutors!M11, to determine if jon earns more per week
by “level” or by “type”.
6.
(10 pts) Write an Excel formula in cell tutors!N5, which
can be copied down and across to cell tutors!P11, to determine if the weekly
earnings by type and by level are within 5% (see cell tutors!N4) of each other.
FYI: This solution is similar to the slide problem which compared if the
estimated and actual budgets were within similar ranges i.e. plus or minus 5%,
etc.
7.
(6 pts) Write an Excel formula in cell tutors!N12, which
can be copied across to cell tutors!P12, to determine if none of the tutors two
weekly pay wages (type and level) fell within 5% of each other.
8.
(5 pts) Which of the following solutions correctly
determines if only grad tutors have the maximum weekly pay by level? Circle Y
for yes (i.e. correct solution) and N for no (i.e. incorrect solution). NOTE:
the answer to the question is FALSE and
this question is considered “not updatable”.
Y N =AND(OR(L10,L11),NOT(L4:L9))
Y N =AND(C10="G",C11="G",L10=TRUE,L11=TRUE)
Y N =AND(L5=FALSE,L6=FALSE,L7=FALSE,L8=FALSE,L9=FALSE,L10=TRUE,L11=TRUE)
Y N =AND(L10:L11=TRUE,L5:L9=FALSE)
Y N =AND(OR(L10:L11),NOT(OR(L5:L9)))
SCORE ON BACK OF PAGE