CS110 F07 Final Exam-1

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
(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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/31/2008 for the course CS 110 taught by Professor Anderson during the Fall '08 term at Hartford.

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 Right Arrow Icon
Ask a homework question - tutors are online