This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: CaseGrader: Microsoft Office Excel 2007 Casebook with Autograding Tech Joshua Nolan, Case 3 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. In the 2011 Projection worksheet, in the range F7:F13, use the SUM function to calc 3. In the range G7:G13, use the MIN function to display the minimum 2010 quarterly sa 4. In the range H7:H13, use the MAX function to display the maximum 2010 quarterly s 5. In the range I7:I13, use the AVERAGE function to calculate the average 2010 quarte 6. Format the range B7:I13 as comma style with no decimal places. Apply the Accent 1 7. In cell B15, use the AVERAGE function to calculate the average of the 2010 quarter 8. In cell J7, use the IF function to display the text string Outstanding if Jim H.s quarte 9. Apply the Explanatory cell style to the range J7:J13. 10. In cell B21, enter a formula to calculate the projected first quarter 2011 sales for Jim 11. Use the SUM function in cells B28:E28 to calculate the projected 2011 quarterly to 12. Format the range B21:E28 as comma style with no decimal places. Apply the Acce 13. In the Future Value worksheet, in cell B3, enter 0.01 to represent a minute being w 14. In cell B4, calculate the value of an hour by multiplying the value of a minute (cell B 15. In cell B5, calculate the value of a day by multiplying the value of an hour (cell B4) 16. In cell B6, calculate the value of a month by multiplying the value of a day (cell B5) 17. Format the range B3:B6 in the Accounting number format. 18. In cell B8, enter a number between 1 and 40 to indicate the number of years you w 19. In cell B9, calculate the number of months (i.e., periods) by multiplying the number 20. In cell B11, enter the APR value of 0%. In cell C11, enter the APR value of 2%. Co 21. In cell B12, enter 12 to represent the number of periods per year (monthly). 22. In cell B13, enter a formula that calculates the interest rate per period by dividing th 23. Format the range B13:I13 to show the numbers as percentages with four decimal p 24. In cell B14, use the FV function to calculate the future value using the previously ge 25. Format the range B14:I14 in the Accounting number format....
View Full 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.
- Spring '11