Question
Demonstrate your Excel skills by completing the following: You have been asked to prepare a spreadsheet to show the profit and loss figure for the
Demonstrate your Excel skills by completing the following: You have been asked to 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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started