CSE200 AU10 KREEVES QUIZ#1 SEAT# ____________
NAME _______________________________________________ Lecture: MW 8:30-10:18am
Lab section (check one): _______ R 9:30am-11:18am ________ R 11:30am-1: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. The following is a valid path name to an Excel file: Z:\windows\reeves\Documents\Labs\Lab1
2. The ##### Excel error value means that the cell value is too big to fit in the column width.
3. The CPU works with memory to execute the arithmetic and logical processes of the computer.
4. A kilobyte is smaller than a megabyte.
5. =MAX(A1:A5) yields the same result as =LARGE(A1:A5,5)
6. Given the same configuration, a laptop computer is more expensive and less portable than a desktop computer.
7. Bing is a search engine that has successfully indexed all the available content on the web.
8. Excel and Access are considered system software.
9. A faster clock speed will not necessarily speed up your processing if the bus speed is too slow.
10. Relative addressing is the process by which the computer knows where to store your files.
FUNCTIONS: 
11. (6pts) Write an Excel formula in cell F4, which can be copied down and across to cell H17, to determine the total price of the cse1 binder clips item order based on the quantity (qty in column D) and the cost per item (column E) including the discount specified per column (in F3:H3). REMINDER: whenever you see a % sign, that means that the actual/precise value is less than one.
12. (6 pts) Write an Excel formula in cell D18, which can be copied across to cell H18, to determine the average number of items (i.e. the quantity) ordered, rounded to the nearest tenths place.
13. (3 pts) For the value given in cell D18, what is the number in the hundredths place? That is, if the value in D18 was increased by one decimal position so that the hundredths place was shown, what would be the numeric value in the hundredths place?
14. (6 pts) Write an Excel formula in cell K4, which can be copied down and across to cell M8, to determine the total cost for the cse1 purchase order (i.e. the total for all of the cse1 items) including the discounts as specified in K3:M3. NOTE: the values in F3:H3 will always be in the same order as the values in cells K3:M3.
15. (4 pts) Write an Excel formula in cell J10 to determine the number of purchase orders on the excel-lent office supplies list.
16. (5 pts) Write an Excel formula in cell N4, which can be copied down to cell N8, to determine the percent of the cse1 purchase order with no discount (cell K4) in comparison to the total cost of all of the purchase orders on the list. NOTE: using column K, i.e. the value with no discount, the cse1 purchase order price is 10.7% of the total cost of all of the purchase orders put together.
17. (4 pts) Explain why the values in N4:N8 don’t seem to add up to 100% on paper, but when I type in =sum(N4:N8) into cell N9, the result is exactly 100% with all zeroes for the decimal places.
18. (4 pts) Write an Excel formula in cell O4, which can be copied down to cell O8, to determine the ordering of the individual purchase order non-discounted total costs from highest to lowest cost.
CSE200 AU10 KREEVES ANSWER SHEET QUIZ#1 SEAT# ____________
NAME _______________________________________________ Lecture: MW 8:30-10:18am
Lab section (check one): _______ R 9:30am-11:18am ________ R 11:30am-1:18pm