Computer (Excel)

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.

Matt

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

Cool. Great job on getting it :)

Matt

excel

  1. 👍 0
  2. 👎 0
  3. 👁 150
asked by Robert

Respond to this Question

First Name

Your Response

Similar Questions

  1. Accounting

    I have almost completed my assignment, but am stuck on this question. I researched my text and other outside sources and can't seem to find the answer. Can anyone provide any guidance on this for me? What are the strengths and

    asked by Jen on February 28, 2010
  2. Auditing

    Would a public accounting firm be held liable to a third party (creditor) who extended money because on reliance of erroneous financial statements? The specific example features a junior member of the accounting firm intentionally

    asked by Horatio on October 24, 2010
  3. business communication

    please help me to revise this paragraph I’m fed up with the mistakes that our current accounting firm makes. I run a small construction company, and I don’t have time to double-check every bookkeeping entry and call the

    asked by JP on February 17, 2017
  4. english

    What is the subject for the following sentence? The first assignment for this class is this quiz. Answer a. first b. assignment c. class d. quiz .

    asked by toney on March 14, 2012
  5. algebra

    Use the five steps for problem solving to answer the following question. Please show all of your work. The average of two quiz scores is 81. If one quiz score is six more than the other quiz score, what are the two quiz scores?

    asked by franklin on October 29, 2010
  6. Accounting

    Hi, I am having trouble figuring out the below question. Can someone please provide some guidance. Thanks! _____________________________________ It’s December 31, 2007 and you are about to close the firm’s books for the year.

    asked by Leslie on February 23, 2009
  7. accounting

    what are some examples of long format reports? When might an accounting department or accounting firm use these reports?

    asked by Anonymous on November 16, 2011
  8. math

    James needs to bring his grade up to a B (80) in reading. What does he need to get on his next quiz? Quiz 1:77 Quiz 2:81 Quiz 3:74 Quiz 4:?

    asked by Sabrina on January 19, 2015
  9. Accounting 1

    Match each of the following characteristics that describe financial accounting, managerial accounting, both financial and managerial accounting, or neither financial nor managerial accounting. A. Financial accounting B. Managerial

    asked by Mia on September 1, 2014
  10. Accounting 1

    Match each of the following characteristics that describe financial accounting, managerial accounting, both financial and managerial accounting, or neither financial nor managerial accounting. A. Financial accounting B. Managerial

    asked by Mia on August 31, 2014

More Similar Questions