Question

need help with excel anyone available

Answer 1

what do you need?

Answer 2

adjust the references in the formulas of rows 12 and 13 by adding the sheet reference

Answer 3

Don't really understand what for, but here is an example for cell B12:
=('Jul-Dec'!B6*'Jul-Dec'!$B$32)+('Jul-Dec'!B7*'Jul-Dec'!$B$33)
Then you can copy paste the entire row. Was that your question?

Answer 4

The same for row 13. Got it?

Answer 5

thats what the instructions tell me to do

Answer 6

do you know how to access the watch window?

Answer 7

Nevertheless, with excel you don't need to worry about that, because in the case you need the content of the cells for a computation, at the moment of typing in the formula using the mouse to pick the cells, automatically the sheet reference is included. PS: Haven't even heard of the "watch window", sorry.

Answer 8

i havent either but its in the assignment

Answer 9

Watch window: http://office.microsoft.com/en-us/excel-help/watch-a-formula-and-its-result-by-using-the-watch-window-HP010066260.aspx

Answer 10

easy to use, try it

Answer 11

gotta go Tina-ann, Good Luck with the assignment!

Answer 12

so copying that formula to the next cell would be =('Jul-Dec'!C6*'Jul-Dec'!$B$32)+('Jul-Dec'!$B$33)?

Answer 13

nop, it should be =('Jul-Dec'!C6*'Jul-Dec'!$B$32)+('Jul-Dec'!C7*'Jul-Dec'!$B$33).
A very safe way to work with formulas in excel is using the mouse. right click, "copy" and "paste" in the next cell or drag it or highlight the cells where you want to copy the formula and ctrl+v. (At least until you get the grasp of it, use the mouse as much as you can so excel does all the references for you)

Answer 14

You were missing the C7 in the second parentheses

Answer 15

ty

Answer 16

what about the average column