{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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) tail Price and Discount e product ID entered in cell B5 e product ID entered in cell B5 o the product ID entered in cell B5 C17 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