Question

I really desperately need help on my Excel homework will someone please help?

Answer 1

I can help!

Answer 2

ok these are the steps to finish the worksheet i have attached: 1. In cell H6, enter a formula that adds the total from Jan through Jun with the monthly figures from Jul through Dec. 2. Copy the formula down the column. 3. Change the average formula to average the 12 months. 4. Clear the formula from the cells that reference blanks cells. 5. Clear the conditional formatting from all cells in Jul through Dec sales sheet. 6.Check formulas by entering (and removing) some sample data. 7.Change the label in H4 to Annual Total and I4 to Annual AVG. 8.Best fit both columns.

Answer 3

i just need the formulas really but last night when I asked they didnt seem to understand what I was asking

Answer 4

sorry also this is for the July-Dec sheet

Answer 5

do you need to get data from both worksheets?

Answer 6

this is only for july-dec? which gets data from both worksheets?

Answer 7

but july-dec worksheet is empty

Answer 8

its suppose to be, it goes in sections the first step to this section was to delete the contents only in cells B6:G16 and B20:G22.

Answer 9

so what i need to do? it's very unclear

Answer 10

In cell H6, enter a formula that adds the total from Jan through Jun with the monthly figures from Jul through Dec.

Answer 11

in jul-dec worksheet only?

Answer 12

if you have the time I we can start from the beginning maybe I missed something or did it wrong this is my second week of class I was doing really good up until this point

Answer 13

sry yes July-Dec only

Answer 14

='January-June Sales'!H6+SUM(B6:G6)

but july-dec is empty so it wont add anything...

Answer 15

i dont think it is suppose to I think its for future numbers so that the cell is already formatted

Answer 16

please dont go anywhere brb

Answer 17

ok im back
now how about Change the average formula to average the 12 months. on the same sheet

Answer 18

=H6/12
but again july-dec empty and this doesn't make sense lol

Answer 19

if you have the time I we can start from the beginning maybe I missed something or did it wrong this is my second week of class I was doing really good up until this point

Answer 20

idk if it's very big

Answer 21

not really

Answer 22

1. use autofill to complete the month headings

Answer 23

2. add a blank row below row 15 for brownies

Answer 24

ok u have done this

Answer 25

3. edit the formula in B17 to include B16 and copy it across the row through column G.

Answer 26

u have done this too

Answer 27

4. Increase the cost of goods by 12 % for each month to account for the added goods needed to make the brownies

Answer 28

5. enter the formulas to calculate the Total and Average values in row 6. Copy the functions down the columns through row 25. clear the formulas from all cells that reference blank cells, except row 16.

Answer 29

u have done this

Answer 30

6. freeze the window with the titles in column A and above row 5 frozen so you can scroll to see the Income Values in row 25 while working on the brownie sales next

Answer 31

did u freeze it? im not sure what it means

Answer 32

I wasnt able to this course is for Excel 2007 and all I have is Excel 2010 starter. I had to write the info down so I didnt have to scroll back and forth.
7. Assuming other cookie sales remain the same, you want to know how much brownie sales would be necessary to generate a monthly net income of $2,000. Use goal seek to answer these questions and calculate the brownie sales figures.(Hint: Net Income is displayed in row 25.) Wasnt able to use goal seek it is not available for starter edition.

Answer 33

u probably should do it anyway

Answer 34

u may use paper and pen for goal seeking :D

Answer 35

the freeze is just so you can look at the numbers with out having to scroll back and forth. I did.
8. unfreeze window. (I skipped)
9. Using conditional formatting, create a cell rule that will highlight those cookies that have total sales greater than $3,000. Use highlight color of your choice.

Answer 36

ah then it's ok

Answer 37

im not sure how to do highlighting but you have done it, right?

Answer 38

(Yes It is highlighted) 10. You will soon be working on the sales figures for the second six months and want to set up a second sheet to hold this information when it is available. Copy the entire worksheet from Sheet1to sheet2, retaining the original column widths. Increase row height of 3 to 35.25 points. Change the month headings using Autofill for the second six months (JUL to DEC).

Answer 39

which rows height it asks to increase?

Answer 40

row 3

Answer 41

it was already 35.25 in first sheet

Answer 42

yeah.
11. Rename sheet 1 to January-June Sales. Rename sheet2 to July-December Sales. Add tab colors of your choice. Delete extra sheet in the workbook.

Answer 43

you have done this

Answer 44

(Now we are were we started) 12. In the July-December Sales sheet, delete the contents only in cells B6:G16 and B20:G22. In cell H6, enter a formula that adds the total from Jan through Jun with the monthly figures from Jul through Dec. Copy the formula down the column. Change the average formula to average the 12 months. Clear the formula from the cells that reference blanks cells. Clear the conditional formatting from all cells in Jul through Dec sales sheet. Check formulas by entering (and removing) some sample data. Change the label in H4 to Annual Total and I4 to Annual AVG. Best fit both columns.

Answer 45

Are you still with me?

Answer 46

ok so as i said ='January-June Sales'!H6+SUM(B6:G6)
or u can also do =SUM('January-June Sales'!B6:G6)+SUM(B6:G6)
and for average =H6/12 or =AVERAGE('January-June Sales'!B6:G6,B6:G6)

Answer 47

'sheetname'! can access another sheet

Answer 48

ok so I did do everything right? and I used your formulas

Answer 49

yeah

Answer 50

good, now it says to add a custom header with name and date left-aligned to both sheets. Use the Find and Replace command to change "bars" to "Bars" in both sheets.

Answer 51

have you done it?

Answer 52

the header yes working on the Find and replace

Answer 53

click ctrl+f and there will be replace

Answer 54

ok done on rows 14 & 15

Answer 55

it wont let me do it on the second sheet have to do it manually

Answer 56

click options and you can choose to do on all sheets

Answer 57

options and within choose workbook

Answer 58

ok now it says to add workbook documentation?

Answer 59

this the last step

Answer 60

do you know how to do it?

Answer 61

no

Answer 62

i don't know either but i found this
http://wiki.answers.com/Q/How_do_you_create_a_documentation_sheet_in_Excel
lol

Answer 63

maybe it asks just to fill data in second sheet?

Answer 64

no its documenting the worksheet i think it does it for you

Answer 65

i think it's not function because i can't find anything on google or maybe it's called somehow different

Answer 66

its in the print menu they mean to add your name as author and title the document

Answer 67

Thank you so much for all your help, are you going to be on later I have one last worksheet to do but have to do my afternoon jog, that assignment has 3 stars so its suppose to be harder

Answer 68

im not sure