OPERATE A SPREADSHEET APPLICATION

INSTRUCTION:

1. Create a worksheet exactly as shown in the example as well as its formats under the filename of “MyExcel”.
2. Rename the worksheet as Sales Revenue Report.
3. The amount of Furniture has a constant value of 13,500 in every month.
4. The amount of Garments increases 2% in every month.
5. The amount of Kitchenware doubles the value on the next month.
6. The Sales discount will be 12% of the sum of Furniture, Garments and Kitchenware in each month.
7. Gross sales will be the sum of Furniture, garments and Kitchenware deducted by sales discount.
8. In the expenses, copy the values as shown in the example.
9. Compute for the total expenses which are the sum of the expenses of each month.
10. The Gross profit of a month will be gross sales deducted by the total expenses.
11. The cumulative profit (loss) of a month will be the gross profit of the month plus the cumulative profit of the previous month.
12. If the accumulative profit is less than zero (0), the font color will change into red.
13. Compute for the total or the sum of Furniture, Garments, Kitchenware, sales discount, gross sales, the expenses, total expenses and the gross profit.
14. The headers on the first month up to the last month should have a yellow color and the total should be blue with double underlined at the bottom using borders.
15. Put a Light Turquoise fill color on the totals cells.
16. Create a bar chart for the Furniture, Garments and Kitchenware from the first month up to the last month and put it on another sheet.

Note:

The values of Furniture, Garments and Kitchenware from the first up to the last month must display on the chart.

Sample:

Click the image to zoom...