Question

Using Excel prepare a spreadsheet to show the profit and loss figure for the last financial year. The profit and loss should be shown as dollars and as a percentage.

Enter the raw data below, applying as many presentation Features (Font, Font Size, Font

Color, Number Formats and Color, Cell Shading, Text Rotation, etc) to it as you wish.

Apply appropriate number formats to your numbers.

Center your spreadsheet horizontally on the page

Give your spreadsheet an appropriate title and center it across your spreadsheet.

Select the best page orientation for your spreadsheet.

Adjust the column width and row height to suit the layout you have selected.

Create a formula to calculate the profit / loss as a currency for each month.

Create a formula to calculate the profit / loss as a percentage for each month.

Create a formula to calculate the Annual Totals for the Income, expenditure, and profit/loss.

Create a formula to calculate the profit / loss for the whole year.

Setup an appropriate header for this spreadsheet.

Setup a page number for this spreadsheet and place it in the footer.

Use the following raw data:

Month	Income	Expenses
March	1259.9	1410.45
April	1163.98	1499.10
May	1533	1370.25
June	1774	1440.8
July	1631	1530.25
August	1658	1490.55
September	1781	1369
October	1821.54	1420
November	2233.82	1611.81
December	2537.22	1577.63
January	1650	1423.98
February	1623	1598.12

Answer 1

The table with the answers are as shown below:

Month	Income	Expenses	Profit/Loss as Currency	Profit/Loss as pecentage
March	1259.9	1410.45	-150.55	-11.95%
April	1163.98	1499.1	-335.12	-28.79%
May	1533	1370.25	162.75	10.62%
June	1774	1440.8	333.2	18.78%
July	1631	1530.25	100.75	6.18%
August	1658	1490.55	167.45	10.10%
September	1781	1369	412	23.13%
October	1821.54	1420	401.54	22.04%
November	2233.82	1611.81	622.01	27.85%
December	2537.22	1577.63	959.59	37.82%
January	1650	1423.98	226.02	13.70%
February	1623	1598.12	24.88	1.53%
Annual	20666.46	17741.94
Annual Profit (Currency)	2924.52
Annual Profit (Percentage	14.15%

The Excel screen shot is as shown below: