Question

please someone who really knows what they are doing in excel please help me. Please if you dont know then dont respond.

Answer 1

all I am suppose to do for the rest of this assignment is the 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 2

i know exel pretty well i will try to help could you mabey type what you need in a list form so i understand a little bit more than i can work it out

Answer 3

like
1.
2.
3.
4.
that kinda thing like a check list

Answer 4

yes

Answer 5

i know i can create what you need but explaining how i did it ill try my best

Answer 6

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

Answer 7

okay is this formula somthing in exel or somthing like 2+2

Answer 8

I'm also doing it, wait for some time

Answer 9

in excel

Answer 10

ok

Answer 11

i attached the worksheet

Answer 12

when i add the formula in does it go on witch spread sheet

Answer 13

im sorry if theres any frustration im just trying to figure out a lil more as i do it

Answer 14

july-dec in H6

Answer 15

then I have to copy the formula down the column

Answer 16

do you want that formula to add on too number that you will place there for those monthly avg.?

Answer 17

yes

Answer 18

okay i understand :)

Answer 19

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 20

Tina check this one

Answer 21

with sample data

Answer 22

did you check it??

Answer 23

it looks good but how did you do it

Answer 24

however that one doesnt add to the total

Answer 25

type numbers into the blanks it adds to it

Answer 26

let's say for annual total, we want to sum total of Jan to jun total + july-dec
in the excel sheet there was already the sum of july to dec by the formula sum(B6:G6)
we need to add jan to jun total with it, so write the formula in H6
as ''=sum(B6:G6)+ ____''
after writing + sign , go to the fist sheet and click H6 there
you'll get a formula as =SUM(B6:G6)+'January-June Sales'!H6
when you copy this formula for the lower cells,it'll automatically change to the respective cell numbers.
to find average just put in I6"=H6/12"
then copy this in the whole column.

Answer 27

this one will add to the jan- july total

Answer 28

did you get it tina??

Answer 29

sorry, it took me so long:(

Answer 30

i can not open that file for some reason

Answer 31

which file

Answer 32

kamuela's file is not opening

Answer 33

no

Answer 34

please ash write the the formulas for me

Answer 35

kamuela your file can not be opened

Answer 36

please ash write the the formulas for me
here

Answer 37

im exhausted and going to bed its 4:30am
and i still have a whole other worksheet to do plus a quiz all due sunday by 11:59p

Answer 38

Total"=SUM(B6:G6)+'January-June Sales'!H6"
Average"=H6/12"

Answer 39

perfect ty

Answer 40

type the total under total Annual
and then copy in all the cells
type the average under annual average
and then copy in all cells

Answer 41

now you sleep kid