QUESTION 3 PRACTICALS MICROSOFT EXCEL / SPREEDSHEET 3.1 a) Open a workbook on Excel and Create the type of the spreadsheet save it as '2024 Budget Statistics." Jan Feb March April May June July Aug Sep Oct Nov Dec Sales 20000 Cost of sales Gross Income Profit/Loss Expenditure Salary 8000 Rent 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 Water & Electricity Fibre Internet Total Expenses 3.1.1 Merge and center "Expenditure" Using formulas calculate the following. a. Sales increase monthly by 15% b. Cost of Sale is 5.5% of Sales. C. Calculate Gross income. d. Salary will increase on the 10th Month by 6% e. Water and Electricity 5% of the salary will decrease by 2.5% in June. f. Fiber Internet 5% of the salary will increase in July by 4% and will decrease by September by 2%. g. Calculate the Total Expenses h. Calculate the profit/the loss. 3.1.2 Create Chart based on the sales from January to Dec namely '2024 SALES'. 3.1.3 Insert the header using your Name, Surname, ITS number. THE END!!!!
QUESTION 3 PRACTICALS MICROSOFT EXCEL / SPREEDSHEET 3.1 a) Open a workbook on Excel and Create the type of the spreadsheet save it as '2024 Budget Statistics." Jan Feb March April May June July Aug Sep Oct Nov Dec Sales 20000 Cost of sales Gross Income Profit/Loss Expenditure Salary 8000 Rent 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 Water & Electricity Fibre Internet Total Expenses 3.1.1 Merge and center "Expenditure" Using formulas calculate the following. a. Sales increase monthly by 15% b. Cost of Sale is 5.5% of Sales. C. Calculate Gross income. d. Salary will increase on the 10th Month by 6% e. Water and Electricity 5% of the salary will decrease by 2.5% in June. f. Fiber Internet 5% of the salary will increase in July by 4% and will decrease by September by 2%. g. Calculate the Total Expenses h. Calculate the profit/the loss. 3.1.2 Create Chart based on the sales from January to Dec namely '2024 SALES'. 3.1.3 Insert the header using your Name, Surname, ITS number. THE END!!!!
Chapter10: Financial Statements And Reports
Section: Chapter Questions
Problem 3.3C
Related questions
Question
![QUESTION 3 PRACTICALS MICROSOFT EXCEL / SPREEDSHEET
3.1 a) Open a workbook on Excel and Create the type of the spreadsheet save it as '2024 Budget Statistics."
Jan
Feb March April May June July Aug Sep
Oct
Nov
Dec
Sales
20000
Cost of sales
Gross Income
Profit/Loss
Expenditure
Salary
8000
Rent
1500
1500
1500
1500
1500 1500 1500
1500
1500
1500 1500
1500
Water & Electricity
Fibre Internet
Total Expenses
3.1.1 Merge and center "Expenditure"
Using formulas calculate the following.
a. Sales increase monthly by 15%
b. Cost of Sale is 5.5% of Sales.
C. Calculate Gross income.
d. Salary will increase on the 10th Month by 6%
e. Water and Electricity 5% of the salary will decrease by 2.5% in June.
f.
Fiber Internet 5% of the salary will increase in July by 4% and will decrease by September by 2%.
g. Calculate the Total Expenses
h. Calculate the profit/the loss.
3.1.2 Create Chart based on the sales from January to Dec namely '2024 SALES'.
3.1.3 Insert the header using your Name, Surname, ITS number.
THE END!!!!](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Faab5760f-bc6e-434a-8cd6-76fc264a59f0%2F6adba3a5-0440-4a0b-ba48-c744667794ad%2Fx647fhn_processed.jpeg&w=3840&q=75)
Transcribed Image Text:QUESTION 3 PRACTICALS MICROSOFT EXCEL / SPREEDSHEET
3.1 a) Open a workbook on Excel and Create the type of the spreadsheet save it as '2024 Budget Statistics."
Jan
Feb March April May June July Aug Sep
Oct
Nov
Dec
Sales
20000
Cost of sales
Gross Income
Profit/Loss
Expenditure
Salary
8000
Rent
1500
1500
1500
1500
1500 1500 1500
1500
1500
1500 1500
1500
Water & Electricity
Fibre Internet
Total Expenses
3.1.1 Merge and center "Expenditure"
Using formulas calculate the following.
a. Sales increase monthly by 15%
b. Cost of Sale is 5.5% of Sales.
C. Calculate Gross income.
d. Salary will increase on the 10th Month by 6%
e. Water and Electricity 5% of the salary will decrease by 2.5% in June.
f.
Fiber Internet 5% of the salary will increase in July by 4% and will decrease by September by 2%.
g. Calculate the Total Expenses
h. Calculate the profit/the loss.
3.1.2 Create Chart based on the sales from January to Dec namely '2024 SALES'.
3.1.3 Insert the header using your Name, Surname, ITS number.
THE END!!!!
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you