Reference no: EM132251926

Question: Part 1: Create a spreadsheet that tracks your expenses for a week.

• use a column for each day of the week

• include at least 7 expense items in rows (make up expenses if necessary)

• using functions, compute the total expense for each day of the week

• using functions, compute the weekly total expense for each item

• using functions, compute the weekly average expense for each item

• name the worksheet Expense

Be sure to label the rows and columns, and include a title.

Part 2: On a separate sheet titled Column, create a clustered column chart based on the total expenses per item. Be sure there is an appropriate main title, axis titles, and labels for the chart.

Part 3: On a separate sheet titled Pie, create a chart based on the total expenses per day using a 3-D pie chart and pull out the day with the most expenses. Be sure there is appropriate title and labels for the chart.

Content and style will be assessed. Name the file using your name. For example, John Doe would name the file SS-prj- Doe-John.xlsx.

Part 4: On a separate sheet using landscape orientation show me the entire ss using formulas. Call it the Formula Sheet