Homework Help is Here – Start Your Trial Now!
Business
Accounting
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!!!!

Quickbooks Online Accounting
Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter10: Financial Statements And Reports
Section: Chapter Questions
Problem 3.3C
See similar textbooks
icon
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!!!!
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
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
SEE MORE TEXTBOOKS