Computer (Excel)

posted by .

This is my assignment (actually a quiz)

You work at an accounting firm and you need to design a spreadsheet for a business customer's income and expenses. The business is divided into four departments: Sales, Marketing, Development, and Executive. Each dept. keeps track of its own financial activity, so you need to compile all of the information together to generate the company's tax information.

The only thing that you have to work with is each department's printed bank records, which include transactions in and out. The bank records include the date, the amount, and a description for each transaction. You must enter all of the records manually, and you must include each department's information in the workbook,as well as the totals for the entire company. You should insert column headers for the date, the amount, and the description columns. Then you need to generate subtotals in the Amount column for each department and the company as a whole.

Create the Exel workbook that you need to use for this assignment. Make up 10 transactions for each department, and enter them into the workbook according to the requirements listed here.

(I will need step-by-step instruction...thanks!)

Start doing it and ask on the part you're stuck on.


I got lucky and finally figured it out on my own. Got an A too!. Thanks for responding to my question,

Cool. Great job on getting it :)



Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. IT

    What skills are needed to perform the business functions of computer operations?
  2. Accounting

    Hi, Please would it be possible to advise me on this problem?
  3. Marketing

    Please check and correct my answers for the following multiple choice questions: 1-For Tesla, a new firm that makes an electric sports car, estimating how many competitors will make electric vehicles and what kinds they will make, …
  4. Business

    Please check my answers: 4) Professional Dental Supply has been successfully selling dental instruments to dentists for the past 20 years, and has developed strong customer relations. When looking for new marketing opportunities, Professional …
  5. Managerial Accounting

    1) If the Cost were split simply 50-50- than allocated expense would be - Advertising Expenses - $ 2.5 M for each business and warehouse expenses - $ 1.5 M for each business 2) As per my view the Advertisement expenses should be allocated …
  6. marketing

    Which of the following statements best describes the modern view of marketing?
  7. Income tax

    Patricia professional gambler had following income expenses in her business: Gambling Winning---- $275000 Expenses Fees paid for illegal information---$18000 travel costs------$8000 office expenses ------ $ 5000 supplies------$3000 …
  8. BTEC Level 3 Business

    I need to find out what information the finance and marketing departments need and use within a business.
  9. Accounting

    Complete the following exercise. Fill in the Excel spreadsheet provided via the link below to provide your answers to parts a and b. Then paste the Excel data into a Word document on which you can also write the answer to part c. Income …
  10. please check my grammar

    AN.15,2016 From: Genecito Jimenez Dear sir/madam, The JIMENEZ INTERNET CAFE has been operating the business started last Oct.15,2015. There are 14 computers for the clients and 1 computer for server with the total of 15 pc's. The total …

More Similar Questions