Design formulas or use the autosum function

Assignment Help Computer Engineering

Reference no: EM1336814

You do not need to put in personal information or actual values if you do not wish, but you must include some data for each of the various categories and income and expense line items.

Content and Format Requirements
1. This spreadsheet should be divided into categories such as Income and Expenses. Within each of these categories there should be several line items. For example, under Expenses you might have items such as: Utilities, Auto, Rent/Mortgage, and so on.
2. For each line item, create a year's history by month. Identify each month by month and year such as "July 2005."
3. Create formulas or use the AutoSum function to calculate totals for line item categories and for each month.
4. Create Formulas or use the AutoSum function to have Excel compute the Total Annual Income and the Total Annual Expenses.
5. Name the worksheet tab "Budget Details."
6. On the second worksheet in the Excel workbook, include the Total Annual Expenses and Total Annual Income using cells from the Budget Details worksheet.
7. Create a formula to have Excel compute Annual Savings based on the values in those cells.
8. Include titles to identify all values.
9. Name the tab of the second worksheet "Annual Totals."
10. Save the worksheet.

Reference no: EM1336814

Questions Cloud

Sec enforcement : What is the most recent litigation brought by SEC against public firm or against the accounting firm? What is the most recent Staff Accounting Bulletin which provides guidance to profession? What was the guidance given?

External opportunities for apple computer : The external opportunities for Apple computer explain your answer.

Explain business help- activity based costing : Explain Business help- Activity Based Costing and What are some of the key elements of activity-based costing

Three theories of dividends : You determine the capital structure of your company; therefore you should compare the two theories of capital structure and determine what mix of capital structure your company.

Design formulas or use the autosum function : You do not require to put in personal information or actual values if you do not wish, but you must include some data for each of the various categories and income and expense line items.

Social problem where free marketplace are not allowed : social problem where free marketplace are not allowed to function and describe how free market features could be introduced to help alleviate the problem.

How can apple gain market share and surpass its competition : How can Apple gain market share and surpass its competition like Dell and HP in the computer segment?

Explain about activity based costing vs traditional costing : Explain about Activity based costing vs traditional costing and What can an organization learn from the process of applying ABC costing

Capital structure and eps : How can a corporation adjust their capital structure to enhance their EPS (Earnings per share)? Find out an example of a corporation that recently reproted their EPS.

User Account

All Pages