December 18, 2014

Homework Help: Computer (Excel)

Posted by Robert on Thursday, June 21, 2007 at 6:41am.

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



Answer this Question

First Name:
School Subject:

Related Questions

Accounting - Hi, Please would it be possible to advise me on this problem? ...
IT - What skills are needed to perform the business functions of computer ...
Income tax - Patricia professional gambler had following income expenses in her ...
Earth Science - I need help with the following Lab due tonight, 7/30/12, as I ...
accounting - Prepare an income statement cash 16050.00 accounts receivable 1500....
Computer - You interview with a financial services firm on Wall Street and you ...
accounting - Assignment Please prepare the homework problems in the form of a ...
Accounting - I have the following items listed on a balance sheet and income ...
Managerial Accounting - 1) If the Cost were split simply 50-50- than allocated ...
Math - Your large firm is about to change to a customer-centered organization ...