Use the sum function to calculate the total for all the cell

Assignment Help Finance Basics

Reference no: EM13909504

Need help with a question, here are the requirements

Create a business budget sheet using Microsoft^® Excel^®. In the budget sheet do the following:

Create a label called "Income" and add your monthly business income in the next cell: $42000.
Add a label called "Rent" and enter the amount in the next cell: -$2000.
Add a label called "Product Spending" and enter the amount in the next cell: -$20000.
Add a label called "Gas" and add the amount in the next cell: -$250.
Add a label called "Car Payment" and add the amount in the next cell: -$500.
Add a label called "Electric" and add the amount in the next cell: -$600.
Add a label called "Insurance" and add the amount in the next cell: -$500.

Use the SUM function to calculate the total for all the cells.

Use the Freeze option to freeze the top panes.

Create a pie chart for your business income and spending.

Reference no: EM13909504

Questions Cloud

Describe the legislative act : Describe the legislative act and analyze how it has influenced the U.S. health care system.

What are some of the mncs corporate characteristics : What are some of the MNCs corporate characteristics influencing its capital structure decisions?

Discussion on the value of the firm : Discussion on the Value of the Firm - Subscribe Hide Description Please discuss the following: 1) Why the goal of Maximization of the Value of the Firm important for Corporations? 2) How would the firms go about achieving this goal?

Determine the firm''s cost of capital : Given the following information interest rate 8% tax rate 30%

Use the sum function to calculate the total for all the cell : Create a business budget sheet using Microsoft® Excel®. In the budget sheet do the following: Create a label called "Income" and add your monthly business income in the next cell: $42000. Add a label called "Rent" and enter the amount in the next..

Calculate the cost of ending inventory : Calculate the cost of ending inventory and the cost of goods sold under each of the following methods: First-in, first-out. Last-in, first-out. Weighted average.

The computer workstation furniture manufacturing : The computer workstation furniture manufacturing that Adria Lopez started is progressing well.

Describe e-learning as a training method : Describe e-learning as a training method. Describe the potential barriers of e-learning readiness.

Information about accessing the blackboard grading rubric : Country Analysis: Essay Utilizing CSU Online Library, research the business and country selected in Unit I. Then, go tohttps://www.cia.gov/library/publications/the-world-factbook for additional research of facts and data. Prepare a word document of t..

User Account

All Pages