CSE200 SP09 KREEVES QUIZ#1 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.
· 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.
· Please stay in the answer box for each question.
· 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.
TRUE/FALSE (1 pt each = 9 points total)
1. The internet is a good example of a local area network.
2. A gigabyte is larger than a megabyte.
3. It is always okay to have two files with the same name stored anywhere on your CSE account, no matter where they are stored.
4. Secondary memory, which is also called RAM, temporarily stores information so that it’s readily available to the CPU.
5. Given the same configuration, a desktop computer is more expensive and more portable than a laptop computer.
6. =MIN(A1:A5) yields the same result as =LARGE(A1:A5,5)
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. Excel and Access are considered operating system software.
9.
Clock speed is more important
than the bus speed since it’s usually faster.
FUNCTIONS AVERAGE(number1,number2,…) COUNT(number1,number2,…) LARGE(array,k) MAX(number1,number2,…) MIN(number1,number2,…) RANK(
number, ref, order) ROUND(number, num_digits) SMALL(array,k) SUM(number1,number2,…) The INPUT data for this problem is given in cells A4:E22
and M4:M22.
10. (4 pts) Write an
Excel formula in cell A23 to determine the number of players on the J-Excel
franchise baseball team.
11. (3 pts) Write an
Excel formula in cell C23, which can be copied across to cell E23, to determine
the total number of hits for the J-Excel franchise baseball team. NOTE:
Remember that the wording of this problem refers to determining the total
number of hits initially, but then determining the total RBIs (runs batted in) and
the total number of home runs, respectively, as the formula is copied.
12. (5 pts) When I was setting up the worksheet, I was
debating whether to leave the cells blank instead of put in a zero for players’
hits, runs batted in and home runs in the range C4:E22.
a.
Will changing the zeroes to blanks change the results in
cells C23:E23? Yes or No.
b.
What if I want to find the AVERAGE number of hits for the
team? Will it return the same results with blank values as having zero values? Yes
or No. Explain.
13. (5 pts) Write an
Excel formula in cell F4, which can be copied down and across to
cell H22, to determine the batting average for John. FYI: the batting average
is determined by the number of hits per at bat.
14. (6 pts) Write an Excel formula in cell I4, which can be copied down and across to cell K22,
to determine john’s batting average ranking in relation to the rest of the team’s
batting average where a rank 1 designates the person with the best/highest
batting average.
15. (6 pts) Write
an Excel formula in cell L4,
which can be copied down to cell L22, to determine the average for john’s
batting average, RBI and home run rank values rounded to the nearest whole
number.
16. (4 pts) In cells M4:M22, I averaged the ranked values
(in columns I, J, and K) without using a function to round the resulting value.
In N4, I put the formula =L4-M4 and copied it down to N22. Be sure to explain:
·
Why are some of
the values zero?
·
Why are some of
the values positive?
·
Why are some of
the values negative?
17. (6 pts) Write an Excel formula in cell Q4, which can be copied down and across to cell
S6, to determine the top batting average value on the team.
CSE200 SP09 KREEVES ANSWER SHEET QUIZ#1 SEAT# ____________
NAME _______________________________________________ Lecture: TR 1:30-3:18pm
Lab section (check one): _______ F 1:30-3:18pm ________ F 3:30-5:18pm
ANSWERS TO TRUE/FALSE QUESTIONS. Circle one per question.