Create an Excel worksheet named Budget which meets specifications and layout described and shown below.

Columns:

Item: manual entry, formatted as text

Prior Year Budget: manual entry, formatted as currency with zero decimal places

Prior Year Actual: manual entry, formatted as currency with zero decimal places

Surplus/Deficit: calculated as Prior Year Budget Prior Year Actual

Current Budget: calculated as Prior Year Budget Budget Adjustment * Surplus(Deficit)

the formula should use an absolute reference to Budget Adjustment

Additional Fields: Budget Adjustment (calculated)

Additional Rows:

Total: create a formula which sums the values of the four rows above for each column,

formatted as currency with zero decimal places. All values should be boldfaced.

Average: insert the between Total row and Budget Adjustment row

create a formula which shows the averages of the four values above for each column, formatted as currency with zero decimal places. All values should be italicized.

Additional charts:

Create a pie chart which appears on the same worksheet tab as the spreadsheet above.

This chart will show a breakdown of how the Current Budget is divided among the four budget components.

Formatting similar to that in image below. A high level of neatness and professionalism is expected in you work.