(Get Answer)

Please see uploaded files for details Assignment #3 – Ch 10 Data Case Assigned Class 5 – Due 11:55pm on Sunday Week 7 100 Points – Excel spreadsheet Review Chapter 10 Data Case on page 362. You will work on items 1-6 and submit is as an excel spreadsheet (item #6 you can just type into the spreadsheet). Make certain you have all the details for the calculations so the instructor can follow your thoughts. You must upload your file to Blackboard under Week5 Assignments. Go to the Assignment, scroll down to “Attach Local File” and click Browse to select YOUR file, then hit SUBMIT. Evaluation Criteria for: Excel 14BElements of Paper-- Individual Assignment 3, 100 points each WD “A” 100 to 90 Points Dev “B” 89 to 80 Points NSW “C or lower” 79 to 70 Points or lower Content and Analysis (80%) All work is completed in one Excel workbook with separate tabs for parts a-d. Work is supported with cell formulas, comments, and headers. The worksheet answers are correct, and the worksheets are free of spelling errors. The required answers are clearly identified. All work is completed in one Excel workbook with separate tabs for parts a-d. Most work is supported with cell formulas, comments, and headers. One or two computational errors may be present or one or two required calculations are not supported. The worksheets include no more than two spelling errors. The required answers are clearly identified. The assignment solution omits one of the required sections; no more than three required cell calculations are omitted or properly supported; the worksheet includes not more than three computational errors; or the worksheet includes no more than three spelling errors. Required answers are present but not clearly identified. Format and Appearance (20%) The format is appropriate for professional or business use. The worksheet formats are laid out in a consistent manner and are easy to read. The worksheets are formatted correctly to print on letter The format is acceptable for professional or business use, but worksheets are formatted differently instead of as a unified presentation. Ease of reading may need minor improvements. The The format is inappropriate for professional or business use. The worksheets are formatted differently instead of as a unified presentation and are difficult to read. Text comments are difficult to size paper and include a page number and file name. Colored cells are in light colors and easy to read and print. worksheet print format includes one or two errors, such as omitting headers, not setting the print area to fit letter size paper, or omitting the file name or page number in a header/footer. read or run off the page. The worksheet print format includes more than two errors, such as omitting headers, not setting the print area to fit letter size paper, or omitting the file name or page number in a header/footer. N S W = Needs Significant Work D = Developing WD = Well Developed