Excel Homework

1- It’s a good idea to have an inventory of your personal items for safe keeping. Design a worksheet that will keep track of your personal items divided by category; for example: living room, dining room, bedroom, and so forth. Each category may have as many detail lines as needed It’s a good idea to have an inventory of your personal items for safe keeping. Design a worksheet that will keep track of your personal items divided by category; for example: living room, dining room, bedroom, and so forth. Each category may have as many detail lines as needed if applicable; and the replacement value. Determine the percentage increase in replacement value. Sum the price paid and replacement value in each category and the total value. Format the sheet using the features you have learned in the first three labs. Add your name in a custom header on all sheets. Change the worksheet orientation if necessary; preview, print, and save the workbook as Inventory Tracking.

2-Roberto Sanchez is thinking about purchasing a new car. However, he is concerned about the insurance rates. Before purchasing, he wants to find out the insurance rates on the cars he is evaluating. Select three different car manufacturers and models. Use the Web and select three different comparable insurance companies to get the insurance premium cost information for different amounts of coverage (minimum required). Use your own personal information as the basis for the insurance quotes Create a worksheet that contains the cost of minimum coverage, cost of optional coverage, deductibles available, and insurance premium quotes for each vehicle.

Create a chart of the data that shows the coverage and premiums. Enhance the chart appropriately. Add pictures of the cars. Include a header or footer that displays your name and the current date in the worksheet. Save the workbook as Insurance.