CSE200 SP08 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 correctly 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.

·        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. Circle one answer for each (1 pt each = 10 points total)

 

         T    F       A name can be assigned to a cell, or a range of cells, which defines a mapping to its absolute address.

         T    F       A megabyte is smaller than a gigabyte.

         T    F       It is okay to have two files with the same name as long as they are in different directories/folders.

         T    F       Auxiliary memory, which is also called RAM, temporarily stores information so that it’s readily available to the CPU. 

         T    F       Given the same configuration, a laptop computer is less expensive and more portable than a desktop computer. 

         T            F       =MIN(A1:A5) yields the same result as =SMALL(A1:A5,1)

         T    F       When trying to research a topic using a search engine, both the syntax of the keywords used as well as the database of websites effect the results of the search.

         T    F       Excel and Access are considered system software.

         T    F       The power of Excel is in its ability to automatically update equation results when input values are changed.

         T    F       A faster clock speed won’t necessarily speed up your processing if the bus speed is too slow.

SCORE _____________/50

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)

 
 

NOTE: The types in cells B5:B11 are explained in A15:A17. Also, the values in cells C5:E11 are the number of hours worked per week at that level for that tutor.

 
 
  

 

1.      (4 pts) Write an Excel formula in cell F5, which can be copied down and across to cell H11, to determine the weekly earnings that Jon makes tutoring for level1.

=C5*C$3

No extra $ signs allowed

 

2.      (4 pts) Write an Excel formula in cell I5, which can be copied down and across to cell K11, to determine the ranking level of the earnings for Jon’s level1 tutoring hours.

=RANK(F5,F$5:F$11,0)

Can also used column C instead of column F

No extra $ signs allowed

The 3rd argument ,0 is optional

 

3.      (4 pts) Describe as a whole, all the values that would result from putting the formula =LARGE(F$5:F$11,I5) in cell M5 and being copied down and across to O11.

The same as in the range F5:H11

 

4.      (4 pts) Write an Excel formula in cell E12 to determine the average hours worked per person per level.

=AVERAGE(C5:E11)

=SUM(c5:e11)/COUNT(c5:e11)

No $ signs allowed (not copying)

 

5.      (2 pts)  Can the answer for the above question #4 be copied from E12 to H12 (not using the fill handle) to determine the average money earned per person per level?   Yes _X____     No ______

 

6.      (4 pts) Write an Excel formula in cell E13 to determine the number of tutors on the list.

=COUNT(C5:C11)

No $ signs allowed (not copying)

Can NOT use columns A or B, but all others okay

 

7.      (5 pts) Write an Excel formula in cell C15, which can be copied down and across to cell H17, to determine the total number of level1 hours worked by undergrads.

=SUMIF($B$5:$B$11,$B15,C$5:C$11)

No extra $ signs allowed

 

8.      (5 pts) Write an Excel formula in cell I15, which can be copied down to cell I17, to determine the percent of undergrads on the tutor list.

=COUNTIF(B$5:B$11,B15)/E$13

Optional $ signs column allowed

 

9.      (2 pts) What is the result of the following formula: =ROUND(I15,0) __0 or 0% or 0.0%___

 

10.  (4 pts) If you add up all the percent values in the range I15:I17 as shown, you get 100.1%. Explain why it’s not 100%.

100.1% is the formatted/displayed value but 100% is the actual/precise value