Question

Please someone HELP ME, someone in this room has to know how to use EXCEL

Answer 1

Cookie time?

Answer 2

I know a few things. What do you want to know?

Answer 3

In J6, enter a formula to compute the total full-day care in the first and second six-month periods.

Answer 4

Doggy Daycare

Answer 5

ok that
is easy

Answer 6

i am almost done except the last few parts

Answer 7

J6 on the second page?

Answer 8

yes

Answer 9

must copy formula down the rows to find YTD totals

Answer 10

r u there?

Answer 11

hmm, i haven't figured out how to select data from the other page,
sorry but im still figuring out how to do that

Answer 12

k i can wait been at this almost 3 hrs already

Answer 13

=sum(b6...+g6)

Answer 14

that doesnt look right, please type the formula in exact form

Answer 15

breakthrough

Answer 16

sum(B6:G6)

Answer 17

=H6+'Jan-Jun '!H6

Answer 18

ok so all I need to do is copy and paste and change the H6 to whatever row i am on

Answer 19

just put in =sum(B6,G6)

Answer 20

it also says to use Goal seek to calculate the number of full-day dogs needed to increase the Net Income for December to $10,000

Answer 21

Did you get the sum function to work?

Answer 22

no it gave me the wrong answer

Answer 23

then try =sum(B6:G6)

Answer 24

I think that works.

Answer 25

G6 becomes 420

Answer 26

It returns 4295

Answer 27

thanks anyway UnkleRhaukus is correct. with his formula, the answers add up to what is on my sample sheet

Answer 28

What is the correct result?

Answer 29

430*

Answer 30

=H6+'Jan-Jun '!H6

4,486