Calculate the total for all the cells

Assignment Help Accounting Basics

Reference no: EM13818017

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: EM13818017

Questions Cloud

The wage elasticity of labor supply for men aged : The wage elasticity of labor supply for men aged 18-25 is measured to be 0.3. Within this group, the average weekly wage of the high school graduates is 2/3 the amount of college graduates. Assume that wage elasticity and all other individual charact..

Application on influence of the courts : Application on Influence of the Courts

Determine the target wacc for apix printing : We can determine the target WACC for Apix Printing Inc., given these assumptions," she says as she hands you a piece of paper that says the following:

What is the rationale presented for the change : What is the rationale presented for the change? What are the internal and external pressures considered in the change? To what extent are single versus multiple rationales utilized?

Calculate the total for all the cells : Use the SUM function to calculate the total for all the cells. Use the Freeze option to freeze the top panes.

How tocreate a threepoint estimate for the resulting budget. : You need to determine the costs of this mailing (internal and external). You also need to determine the resource requirements and identify any conflicts. In preparation for the meeting, create a worksheet (in Excel or another spreadsheet tool) that y..

Identify pressures that have caused ethical and legal issues : Discuss the corporate ethical issues of providing questionable products to other markets. Identify the pressures that have caused the ethical and legal issues in this scenario to arise.

Diminishing marginal returns to studying sets : Chris is preparing for a comprehensive course exam by reading a textbook with chapters of equal length and difficulty. The number of chapters she can comprehend and master when studying is: (1) hour one: 1.5 chapters; (2) hour two: 2.0 chapters; (3) ..

User Account

All Pages