Math Student Help

Using double entry accounting, how would we record stolen goods on a financial position worksheet? For example, if $1000 worth of goods is stolen, how would I record that? Thanks in advance!

Stolen goods just become part of the Cost of Goods Sold account (after all, it’s pretty much the same as if a physical inventory count reveals that inventory is $1,000 less than the amount shown on the books). The entry is:

Debit "Cost of Goods Sold’ $1,000 [expense account]
Credit ‘Merchandise Inventory’ $1,000

This entry serves to reduce the amount carried on the books regarding inventory, and also serves to reduce net income because COGS is an expense account.

I found a wedding planning worksheet that was great. Now I just need a worksheet to help me plan my wedding social. I have never planned a social before and was hoping to see a list of things to do, to help a little bit! Thanks in advance!!
Search for reception check list and you should be able to find what you need

I am creating a productivity sheet that calculates an average number of units per time. I want to copy that result to another worksheet. Help?

To copy a cell between worksheets of workbooks:

If the content of the cell does not have a formula, then copy and paste as usual.

If the content of the cell you want to copy has a formula then to copy the cell between worksheets/workbooks you need to create a link between the cells (use a formula to indicate: this cell is equal to that cell):
• Select the cell that you want to contain the link, type the equal sign (=)
• Select the source worksheet, then select the source cell
• Press enter

If you want to have on the destination cell the value and not a link between the cells, then after you finish doing the steps above:
• Select the destination cell and right click and select copy
• Select the destination cell and right click and select PASTE SPECIAL
• From the options select VALUES and click OK
In this way you copy the cell value and eliminate the link between the cells

Hope this help

Excel: Is it possible to create a pivot table using source data from more than one worksheet at once?
I cannot find the Wizard on Excel 2007- Was that removed?

Yes you can create pivot using multiple Worksheets. But this function is not as flexible as you create pivot table using single sheet.
Sturcture of all the tables must remain same to take the advantage of this feature.
use keyboard short keys to aproach if you are using 2007 version otherwise the multiple table merging option may not be visile to you.

Press Alt + D followed by P

Select third option "Multiple Consolidation Ranges"
Click Next
Select "Select a Single Page Field for me"
Click Next

Now Select First range and Click on ADD
Add
and Select & Add as many ranges you want to consolidate.

Click Next/Finish

Now a Pivot is created using default fields.
Remeber Only First column values will be treated as row label
and First Column Values will be treated as Columns.

you can drag Column values before and after only column values and can change the way of calculation for the column labels.

As I have already stated you that this is not much flexible function but still very useful. you can experience it yourself while using it.

http://xlxpart.blogspot.com

I created a PivotTable and PivotChart on Excel. The next step I need to do is rename the worksheet I created to SummaryData.

double click on the name tab at the bottom of the worksheet it will highlight. Just type the new worksheet name and a carriage return and it will be renamed.

I have some data e-mailed to me on one workbook on 3 different worksheets. This is my first time using Excel so I have no clue what I’m doing. I have 3 columns on each that I need to copy to one new worksheet, but the values aren’t manually entered, they are by formula, so I get a reference error if I just try to copy them. How can I get the data all onto one worksheet?

You have two choices.

1) Copy, then Paste special-> Values. This will copy over the values and remove the formulas (permanently). Paste special can be found on the Edit menu in Excel 2003.

2) Change the formulas on the new w/sheet to reflect the new position of the data. You can often change one cell, then drag it down and across. For instance if your cell says =Sheet1!A1, remove the Sheet1! so it says =A1, then drag the formula down and/or across. But this only works if all your formulas have the same format. Otherwise it’s a tedious manual task.

I created a worksheet that has specific margins in landscape orientation, after I add a new worksheet, I cut the correct worksheet and paste it into the new worksheet. When I hit print preview, everything is off.

After you have setup your base sheet, right click the sheet tab and select ‘Move or Copy’.

When the Move of Copy window appears, check the ‘Create a copy’ check box and select where you wish it to be added to the workbook.

An identical copy will be inserted.

I used to be able to press the up, down, left, and right arrows in order to navigate individual cells in an Microsoft Excel worksheet. Now, however, the arrow keys merely move my view of the worksheet; the highlighted cell remains static.

Any ideas? Thanks.

You probably accidentally hit the "Scroll Lock" key on you keyboard. Try turning it off.

I used to know years ago, but haven’t had to use excel in quite a while. I’m having to create an excel worksheet to keep track of basic inventory. The first column lists the card number of a set with 140 cards, for example. I am wanting to set up the spreadsheet to where it’ll automatically number the rows in that column with the correct card number. Please, help?
adding like 1 plus 1 from one row to the next without having to manually type in the card # in each row in the same column

Sure you can simply drag a formula down.

Try this for example, I think it is what you mean, and you can then use it on yours.

Type 1 in A1
Type this formula in A2 "=A1+1"

Then select A2, and look for the small square in the bottom right corner of the selected cell. Click on this and drag downwards for as many rows as you need.

(you could just put 1 in A1, 2 in A2, select both then drag this down, that would work as well)

o you creat borders in a worksheet using cell A8:M12. Please help need this ans asap.thank you
actually is a spread sheet. Create a border around the data entry portion of this spreadsheet. This is done by selecting cells A8:M12. Put a border around the outside of this area only. ? how do you get to the borders. Help asap

Think of a book. A book has multiple chapters. A workbook has mulitple spreadsheets.

As for the borders, try this:

1. Use the mouse to hightlight all the cells betwee A8:M12.

2. Click the Format menu, then Cells.

3. Click the Border tab then Outside to only put a border around A8:M12.

Mike Honeycutt