CS110 F07 Final Exam-1

# CS110 F07 Final Exam-1 - CS110 Final Exam Fall 2007 Name...

This preview shows pages 1–4. Sign up to view the full content.

CS110 Final Exam, Fall 2007 Name Evan Trenkner Grade Tasks: Do the following tasks in order. 1 Make an Excel table using the data range on the Product List sheet 2 Add a column to this table labeled 'Discount' 3 Use an 'if' function to put 0.05 in each row of this Discount column if the Type is '56K Desktop' (a 4 Add a column to the table labeled 'Sale Price' 5 Use an Excel calculation to determine what the Sale Price is for each product row, using the Ret 6 Use conditional formatting to highlight the ten lowest prices in the Sale Price column On the Purchase Order sheet, a user will enter in a Product ID, Quantity, and Shipping Option 7 Use a vlookup function to put the Type from the Excel table into cell C7 that corresponds to the 8 Use a vlookup function to put the Model from the Excel table into cell C8 that corresponds to the 9 Use a vlookup function to put the Sale Price from the Excel table into cell C9 that corresponds to 10 Use a vlookup function to put the Shipping Cost from the Excel table at cells E16:F19 into cell C 11 Use an Excel calculation to determine the Total Cost in cell C19 from the Price, Quantity, and Sh 12 Create a column chart entitled 'Summary' on the Summary sheet that displays the data on that p 13 Extra Credit: Display error messages for all calculated values on the Purchase Order sheet if the user entered

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
(and a 0.00 otherwise) etail Price and Discount e product ID entered in cell B5 e product ID entered in cell B5 to the product ID entered in cell B5 17 that corresponds to the Shipping Option entered in cell B15 hipping Cost page, changing the format of the numbers to whole dollars d data is incorrect
ID Type Model Retail Price 1001 Modem Card 3Com HomeConnect ADSL Modem Ethernet \$285.31 1002 ISDN/DSL \$299.68 1003 ISDN/DSL \$299.69 1004 Modem Card \$47.54 1005 56K Desktop Actiontec Call Waiting Modem 56K USB \$78.83 1006 56K Desktop \$69.16 1007 56K Desktop \$78.83 1008 Modem Card \$95.95 1009 Modem Card Actiontec Datalink 56K PC Card V90 retail box \$72.56 1010 56K Desktop \$63.51 1011 56K Desktop \$38.51 1012 Modem Card \$73.78 1013 ISDN/DSL Adran NT1 ACE3 Triple NT1 \$270.05 1014 ISDN/DSL \$259.47 1015 ISDN/DSL \$320.21 1016 ISDN/DSL \$428.39 1017 ISDN/DSL Adtran ISU 128U Stand Alone Adapter \$625.31 1018 ISDN/DSL \$637.85 1019 ISDN/DSL Adtran NT1 ACE ISDN Network Termination \$137.89 1020 ISDN/DSL \$375.21 1021 ISDN/DSL \$306.49 1022 ISDN/DSL \$308.59 1023 ISDN/DSL \$618.75 1024 ISDN/DSL \$159.92 1025 56K Desktop \$54.54 1026 56K Desktop \$74.61 1027 56K Desktop \$66.89 3Com OfficeConnect ISDN LAN Modem S/T interface 3Com OfficeConnect ISDN LAN Modem U interface Actionec DeskVoice Advantage 56K 56Kbps V.90 Internal ISA windows fax modem Actiontec Call Waiting Modem 56K V.90 56Kbps V.90 Internal PCI modem Actiontec Call Waiting Modem 56Kbps external call waiting modem Actiontec Datalink 33.6 33.6 Fax Modem PC Card Actiontec Desklink Master 56Kbps, V.90, internal voice/data modem

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

### Page1 / 15

CS110 F07 Final Exam-1 - CS110 Final Exam Fall 2007 Name...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online