Cis 200 Quiz#1 Questions
AU02 CIS200 QUIZ#1
Name ______SS# ______Score ______/ 40
Lab Day/Time ______Thurs 9:30am ______Thurs 11:30am
Instructions:
· You will have 20 minutes to complete this quiz.
· 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.
· When you finish your exam, stay in your seat until time is called.
· When time has run out you will be told to put all pens/pencils down. Failure to do so will result in point penalization.
TRUE/FALSE. Circle T or F for each statement (1 point each).
T F 1. One byte is 8 bits.
T F 2. A URL is the same thing as an email address.
T F 3. A keyboard is considered an output device.
T F 4. The ROUND function changes only the display (i.e. format) of a cell.
T F 5. Z:\A\B.XLS\C is a valid file path.
T F 6. Auxiliary memory is erased when the computer is turned off.
T F 7. SMTP defines the protocols used to allow communication on the World Wide Web.
T F 8. RAM is also called Primary Memory.
T F 9. Microsoft Windows 2000 is an example of an operating system.
T F 10. The syntax of the search criteria is important.
T F 11. When using the COUNT function, I can use the names of the students in a file to determine how many students are in the class.
T F 12. Windows Explorer is an application software that helps to manage your files.
Description: You are trying to figure out how the below table was created. You know that you are given the number of points for each touchdown (F2 – no extra points considered) and each field goal (G2). The column E information from rows 5 to 11 have a sequence of numbers that indicate the number of times you have scored a touchdown or field goal. Column F of the same range (rows 5 to 11) are the number of points earned for the column E number of touchdowns, and the same for column G with field goals. So if you score 4 touchdowns, you have earned 24 points (F8 is 4 scores at 6 points a piece) and if you score 2 field goals, you have earned 6 points (G6 is 2 scores at 3 points a piece).
DESCRIPTION (each question is worth 4 points): Excel University is looking at the statistics for the football team from last season. The given data is in gray. The number of points for a touchdown (no extra points considered) and field goal are in columns G4 and H4 respectively. The information for each of the seven games is in the range G7:H13 where the number of touchdowns is in column G and the number of field goals is in column H.
18. I want to find the average number of times the team scored this season. The Excel formula I wrote was =AVERAGE(SUM(G7:H13)) which is syntactically correct. Will the formula give the correct answer? Why or why not?
NO, because SUM returns a single value and the average of a single value is itself, thus this formula returns the sum of the range (not the average)
19. Notice that the average total points scored in a game for the season is 17.6 (see cell I14). If I use the “decrease decimal” icon and decrease the decimal by 1 position, then type the formula =COUNTIF(I14,18) in cell I17, what will be the answer in cell I17? Explain your answer.
ZERO, because even though the format of I14 is changed to 18, the precision is still 17.6 and it’s the precision that is checked when comparing I14 to 18 in the COUNTIF
AU02 KR Quiz#1B Page 2