CSE200 AU09 KREEVES QUIZ#1 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.
· Your answer should update correctly when additional input data is added to the problem or when input data is changed.
TRUE/FALSE (1 pt each = 9 points total)
1. The Internet is a good example of a local area network.
2. This is the correct ordering of memory size
from smallest to largest: bit, byte, kilobyte, megabyte, gigabyte.
3. It is never okay to have two files with the same name stored on your CSE account.
4. Primary memory, which is also called RAM, temporarily stores information so that it’s readily available to the CPU.
5. Given the same configuration, a laptop computer is more expensive and more portable than a desktop computer.
6. System software is programs that control computer operations and an example of system software is Internet Explorer.
7. When trying to research a topic using a search engine, only the differences in the database used effects the results of the search.
8. Obtaining peripheral devices is not a very important part of the computer buying process.
9.
Clock speed is the only important
factor when determining how fast a computer will process information.
The INPUT data for this problem is given in gray. FUNCTIONS AVERAGE(number1,number2,…) COUNT(number1,number2,…) COUNTIF(range,
criteria) LARGE(array,k) MAX(number1,number2,…) MIN(number1,number2,…)
RANK(
number, ref, order) ROUND(number, num_digits) SMALL(array,k) SUM(number1,number2,…) SUMIF(range,
criteria, sum_range)
10. (4 pts) You want to
determine the number of families vacationing at the Excel-lent Adventures
Company at any given point in time. There are currently six families listed as
shown in the range A4:A21 where each family is assigned a consecutive number
starting with one. Which of the following Excel formulas will correctly
determine this solution?
a. =COUNT(A4:A21) Correct? Yes
___________ No
____________
b. =LARGE(A4:A21,1) Correct? Yes ___________ No
____________
c. =MAX(A4:A21) Correct? Yes
___________ No ____________
d. =SMALL(A4:A21,6) Correct? Yes ___________ No
____________
11. (6 pts) You have 3
possible outing options: rafting (raft), rock climbing (rock) and trail hiking
(trail) as specified in G3:I3. A person can choose a maximum of 3 options as
specified for Cliff in cells D4:F4. Notice
that each person does not have to designate all 3 options as that’s the
maximum, but can choose just 1 or 2 options as well. Write an Excel formula in
cell G4, which can be copied down and
across to cell I21, to determine how many rafting trips Cliff has
chosen to take.
12. (3 pts) What would be
the value in cells G4:I4 if the value in cell D4 was “rift” instead of “raft”?
13. (3 pts) Write an Excel formula in cell G22, which can
be copied across to cell I22, to determine how many rafting trips people want to take.
14. (6 pts) Write an
Excel formula in cell G23, which can copied
across to cell I23, to determine the percent of trips that are rafting trips.
15. (4 pts) Why do the percentages in cells G23:I23 add up to 100.01%?
What should they add up to and why?
16. (2 pts) Determine the
result of the following formula =ROUND(G23,0) formatted to two decimal places.
HINT: be careful… be very, very careful!
17. (6 pts) Write an Excel formula in cell M5, which can be copied down to cell M10,
to determine the total cost for family#1 for all the planned trips. Cell L3
designates the cost per trip currently set as $60. Notice that for the current
data, family#1 is taking a total of 8 trips (see J4:J7 that shows 3 for cliff,
2 for kitty, 2 for dan and 1 for nick) at $60 per trip for a total cost of $480
(the explanation for the value in cell M5).
18. (5 pts) Write an Excel formula in cell N5, which can
be copied down to cell N10, to determine the family that spends the most on
trips, the family who spends the second most on trips, etc, where a 1
designates the family that spend the most money on their trips, and a 2
designates the family that spend the second most money on their trips, etc.
CSE200 AU09 KREEVES ANSWER SHEET QUIZ#1 SEAT# ____________
NAME _______________________________________________ Lecture: TR 9:30-11:18am
Lab section (check one): _______ F 9:30-11:18am ________ F 11:30-1:18pm
ANSWERS TO TRUE/FALSE QUESTIONS. Circle one per question (1 pt each).