Ask your own question, for FREE!
Computer Science 7 Online
OpenStudy (anonymous):

@thomaster

OpenStudy (anonymous):

Alright so here's the thing let me show you

OpenStudy (anonymous):

I don't really need help I just need reassurance that im doing this right

OpenStudy (anonymous):

hold on

OpenStudy (anonymous):

here's the directions

OpenStudy (anonymous):

OpenStudy (anonymous):

OpenStudy (anonymous):

and thats what I did

OpenStudy (anonymous):

so am I just supposed to multiply to get the savings?

OpenStudy (anonymous):

It doesn't provide me with any savings numbers

thomaster (thomaster):

I can only see part of the assignment. I understand you have to use the spreadsheet to sum the expenses up?

OpenStudy (anonymous):

Yes

thomaster (thomaster):

So how did you do that?

OpenStudy (anonymous):

OpenStudy (anonymous):

I didn't sum them up yet I just put them in the spread sheet

OpenStudy (anonymous):

I just sumed up the expenses for each month

thomaster (thomaster):

how? with a calculator?

OpenStudy (anonymous):

Yes....

thomaster (thomaster):

I think the purpose of the assignment is to let excel calculate everything. So for expenses in October, you could put the following in the formula bar. =150+50+60+40+30 That would result in 330 without losing the original sum.

thomaster (thomaster):

You still there? @Mr.Ick

thomaster (thomaster):

For the next part you will have to put your bank balance in a random cell. Then click D3 and type = in the formula bar. Then click the cell where you've put the current savings balance. Then type +(B3-C3) What will happen: the formula will first calculate what's between parenthesis. B3-C3 for october will be 550-330 = 220. 220 is what's remaining in October. Then it will add that remaining money to the savings balance. 5600+220 = 5820. That will be displayed in the savings column.

OpenStudy (anonymous):

Thanks we'll I guess I got it wrong then

thomaster (thomaster):

It's not very complicated, you just have to understand how the easy formulas in excel work. I'll draw it to make it more clear.

thomaster (thomaster):

|dw:1397685042871:dw|

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!