Case05_JoshuaNolan_2 - CaseGrader: Microsoft Office Excel...

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

View Full Document Right Arrow Icon
CaseGrader: Microsoft Office Excel 2007 Casebook with Autograding Tech Joshua Nolan, Case 5 Submission #5 Score is 100 out of 100 points ü 1. In the Documentation sheet, verify your name is in cell B4, and then enter the curren ü 2. On the Stationery Sales worksheet, calculate the amount of each order, placing the r ü 3. Calculate the appropriate discount for each order. Use the IF function with an absolu ü 4. Calculate the total for each order, placing the calculated value in the Total column (c ü 5. Freeze rows and columns in the worksheet so the column headings remain visible as ü 6. Create a table for the Stationery Sales worksheet. The range for the table should inc ü 7. Add a record with the information from the casebook. ü 8. Find the record with customer ID of NLC-41-4889, and update the quantity to 3. ü 9. Delete the record with customer ID of NLC-39-3041. ü 10. Apply conditional formatting to the Total column. Highlight orders in which the total i ü 11. Sort the table by multiple fields: by category from A to Z; within category by product ü 12. Create a copy of the Stationery Sales worksheet. Rename the new worksheet as A ü 13. In the AutoFilter worksheet, use a filter to display only those orders from November ü 14. Add a Total Row to the filtered table. ü 15. Create another copy of the Stationery Sales worksheet. Rename the copied worksh ü 16. Sort the list in ascending order by salesperson. ü 17. Convert the table to a normal range, and then use the Subtotal command to sum th ü 18. Return to the Stationery Sales worksheet. Create a PivotTable, using the orders tab ü 19. Lay out the PivotTable to show totals by product name and salesperson. Use Produ ü 20. Format the data items as Currency. Resize the columns as necessary so the colum ü 21. Format the PivotTable using Pivot Style Medium 2. ü 22. Create a PivotChart based on the PivotTable. Use the Stacked Column in 3-D char ü 23. Filter the Chart so that only the four letterhead products (Elegant, Excalibur, Excels Excel Autograder - COPYRIGHT © 2007 PGS Systems Inference Engine version IEv2.23, Knowledge Base version KB05v2.1
Background image of page 1

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

View Full DocumentRight Arrow Icon
hnology nt date in cell B5. result in the Amount column (column H). Use a formula that multiplies the price by the quantity. ute reference to the discount value listed in cell I3. The discount only applies to orders with a quanti olumn J). Use a formula that subtracts the discount from the amount. s you scroll vertically, and the Order Date and Customer ID columns remain visible as you scroll ho clude row 5 as the header row. is greater than $120, using a Yellow Fill with Dark Yellow text. t name, from A to Z; and within product name by order date, from oldest to newest. utoFilter.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/19/2011 for the course NETWORKING IT 273 taught by Professor Edwardswalcott during the Spring '11 term at Kaplan University.

Page1 / 39

Case05_JoshuaNolan_2 - CaseGrader: Microsoft Office Excel...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online