CSE200 SP07 KREEVES QUIZ#1 SEAT# ____________
NAME _______________________________________________ Lecture: TR 1:30-3:18pm
Lab section (check one): _______ R 3:30-5:18pm ________ F 1:30-3:18pm
Instructions:
· Filling in all the above data 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. Failure to do so will result in point penalization.
· 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. Circle one answer for each (1 pt each = 13 points total)
T F It doesn’t matter what search engine you use when looking up information on the WWW.
T F It is okay to have two files with the same name as long as they are in different directories.
T F You can store folders in a file.
T F Operating System software are computer programs written to perform a specified task.
T F Speed, in reference to a computer, is measured in MHz or GHz.
T F A gigabyte represents more memory than a megabyte
T F A desktop is more portable than a laptop.
T F Primary memory loses its data each time the computer shuts down.
T F When referencing the cell C$2 in an Excel formula, it means to reference the cell absolutely with respect to the column and relatively with respect to the row.
T F =MAX(A1:A5) yields the same result as =LARGE(A1:A5,1)
T F The #REF! Excel error value means that a cell reference is not valid.
T F The Excel operators and order of precedence issues are exactly the same ones used in regular math equations.
T F The CPU is software.
FUNCTIONS AVERAGE(number1,number2,…) COUNT (range) LARGE(array,k) MAX(number1,number2,…) MIN(number1,number2,…) RANK( number, ref,
order) ROUND(number, num_digits) SMALL(array,k) SUM(number1,number2,…)
1. (5 pts) Write an Excel formula in cell F7, which can be copied down and across to cell H12, to determine the calories from fat for cookie crisp cereal. HINT: there are 9 calories per gram of fat (F3) and there are 2.5 grams of fat (C7) in cookie crisp cereal.
=C7*F$3 No extra $ signs allowed
2. (5 pts) Write an Excel formula in cell I7, which can be copied down to I12, to determine the remaining calories for cookie crisp cereal that are not attributed to fat, carbs or fiber (as determine by the above question) given that the total calories is in cell B7.
=B7-SUM(F7:H7) Optional $ on column
3. (5 pts) Write an Excel formula in cell J7, which can be copied down and across to M12, to determine the percent of fat calories with respect to the total calories for cookie crisp cereal.
=F7/$B7 No extra $ signs allowed
4. (4 pts) If you add up the values shown in cells J9 to M9, they add up to 100.1%, but if I put in a formula to add up the values in J9 to M9, the result is 100%. Explain in detail why this happens. Why do you get 100.1% when you add up the numbers “by hand”, but 100% when you use a formula to calculate the total percentage.
Actual/precision value VERSUS format/displayed value; 101.1% is the FORMAT/DISPLAYED value however the ACTUAL/PRECISION of each cell reference has a more exact value. It is this actual, more exact/precise value, that is used to add to 100%, not the formatted value.
5. (4 pts) Write an Excel formula in cell J13, which can be copied across to M13, to determine the average percent of fat calories for all the cereals.
=AVERAGE(J7:J12) Optional $ on row
6. (4 pts) Write an Excel formula in cell J14, which can be copied across to M14, to determine the average percent of fat calories for all the cereals (as determined in the above problem) rounded to the nearest whole percent.
=ROUND(J13,2) Optional $ on row
7. (6 pts) Write an Excel formula in cell J15, which can be copied down and across to cell M16, to determine the rank for the average percent of fat calories for all the cereals in relation to the other average percents from the highest percent to the lowest. NOTE: as you copy down the row, the formula should be ranking the rounded averages.
=RANK(J13,$J13:$M13) No extra $ allowed; ,0 as the 3rd argument is optional
8. (3 pts) What is the result of the following formula: =SMALL(J7:M12,COUNT(J7:M12))
69.6% OR .696