Using Excel prepare a spreadsh
Using Excel prepare a spreadsheet to show the profit and lossfigure for the last financial year. The profit and loss should beshown 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 acrossyour spreadsheet.
Select the best page orientation for your spreadsheet.
Adjust the column width and row height to suit the layout youhave selected.
Create a formula to calculate the profit / loss as a currencyfor each month.
Create a formula to calculate the profit / loss as a percentagefor 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 wholeyear.
Setup an appropriate header for this spreadsheet.
Setup a page number for this spreadsheet and place it in thefooter.
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:
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:
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"
