CSE200 SP10 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.
· Turn off all beepers, cell phones and anything else that you can turn off that might make noise.
· Put away all books, papers, calculators, cell phones and music devices. There WILL BE a point penalization with the possibility of a score of ZERO for not adhering to these directions.
· When time has run out you will be told to put all pens/pencils down. There WILL BE a point penalization with the possibility of a score of ZERO for not adhering to these directions.
· 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!
· 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 = 10 points total)
1. It is never okay to have two files with the same name stored on your CSE account.
2. The #REF! Excel error value means that the cell value is too big to fit in the column width.
3. Obtaining peripheral devices is not a very important part of the computer buying process.
4. A kilobyte is larger than a megabyte.
5. =MIN(A1:A5) yields the same result as =SMALL(A1:A5,5)
6. Given the same configuration, a laptop computer is less expensive and more portable than a desktop computer.
7. 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.
8. Excel and Access are considered application software.
9. A faster clock speed will not necessarily speed up your processing if the bus speed is too slow.
10. When you submit your labs, the files are saved in the hard drive associated with the PC where you are sitting.
FUNCTIONS: 
11. (5 pts) Write an Excel formula in cell H4, which can be copied down and across to cell I11, to determine the take home salary of working for longhorn for the summer. Take home salary is the original salary minus the tax amount, which is the percent of tax multiplied by the salary. The average tax amount for the given city/state is given in G4. We cannot answer any questions about the format of this cell; it is something you should know.
12. (5 pts) Write an Excel formula in cell J4, which can be copied down and across to cell K11, to determine which summer job has the highest take-home salary denoted by a 1 in column J, the second highest take-home salary as denoted by a 2 in column J, etc.
13. (4 pts) Write an Excel formula in cell E12, which can be copied across to cell I12, to determine the average summer salary for all of the jobs listed.
14. (5 pts) Write an Excel formula in cell A16, which can be copied across to cell B16, to determine the number of job opportunities on the list. NOTE: as you copy across, you should be able to determine the number of jobs that have benefits.
15. (5 pts) Write an Excel formula in cell D14, which can be copied down to cell D17, to determine the number of summer job opportunities per state (given each state in the range C14:C17).
16. (5 pts) Write an Excel formula in cell E14, which can be copied down to cell E17, to determine the percent of summer jobs on your list per state. NOTE: Remember, it is best to use already solved for data rather than rewriting formulas.
17. (4 pts) Explain why the values in E14:E17 do not look like they add up to 100%.
18. (5 pts) Given the values in G14:G16, write an Excel formula in cell H14, which can be copied down and across to cell I16, to determine the highest earning take-home salary.
CSE200 SP10 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
