Excel Midterm

CS302 Midterm Project Part I: Write a description that completely describes your project to be implemented. Be sure to choose a project concept that will be of personal use to you. (5 pnts) Midterm Project Part II: Create the workbook to complete your project. Your project must implement the following technical requirements. (60 pnt) 1. Well formatted with some background color, borders and style 2. Contain a database sheet with at least 10 records of data and at least one calculated field. 3. Use an if() function someplace in your project. 4. Implement a goal seek analysis using absolute cell references and an assumption area. 5. Use conditional formatting on the database sheet. 6. Use two or more of the functions from this list: iferror(), sumif(), countif() 7. Use a database lookup function like VLOOKUP() using a lookup table. 8. Create a filter sheet. This requires a criteria and extraction area with some filtered data 9. Create some scenarios and generate a summary report. 10. Add at least one macro with a button to run the macro. 11. Use solver in some way. Be sure to create an answer report. 12. Add at least two different data validation fields 13. Create 2 charts of different styles using different data. Include a trend line in at least one chart. 14. Add an imbedded image with a link to another web site. 15. Add cell and worksheet protection. Highlight the unprotected cells. Make the password "MIDTERM". 16. Save your project 17. Be sure to add comments to your project workbook pointing to each of the requirements above. Include the requirement number as the first line in the comment. The comment should point to where you implemented each of the technical requirements. This is required for grading purposes. To add comments right click the cell and select the insert comments menu option. If comments are not added to your workbook it will affect your project grade. Note: I will be doing the project for my budget. Data will be provided once I receive a quote