Question

need help with excel

Answer 1

post your doubts

Answer 2

how do I insert a column between C and D

Answer 3

Hi Tina
Click on the D at the top of the D column, right click on the mouse and choose insert. You should then see another column appear between C & D. Hope this helps. :-)

Answer 4

the only difference I notice is that the info in C shifts to D

Answer 5

Did you click on D or C? When inserting a column between C & D the info in D should move to E. undo and try again. Click on D, insert and the column should appear to the left, moving the info to the right.

Answer 6

a column showed up in F it was A through E

Answer 7

Undo so you are back to your original info. Click on D at the top, you should see that the whole column is highlighted. Does this happen for you?

Answer 8

yes

Answer 9

With the column still highlighted right click on the mouse, do you see the small menu come up on the screen?

Answer 10

yes

Answer 11

Click on insert
What happens?

Answer 12

well theres no info in the box to begin with , the only difference I noticed is the fill color is now in column F when before wasnt i can send attachment

Answer 13

yes please do as this is puzzling me, send it before you do anything.

Answer 14

Ok, well it seems to work ok, the reason F has the fill colour at the top is because the F column is the old E, everything has moved over one column.

Answer 15

ok so that is how it should look

Answer 16

What exactly do you need to achieve, perhaps I can do it for you and explain what I did.

Answer 17

Yes inserting a column inbetween will moved everything over to the right.

Answer 18

ok well i can send you the original file from class and give you the instructions as they are given to me in the book, but i really need to learn to do this i have 10 more weeks for this class and it just gets harder as i go

Answer 19

well send it to me and I can have a look at the bit you are getting stuck on, then you can have it back to continue with.

Answer 20

Sometimes it is just understanding what they are asking you to do.

Answer 21

ok well i messed myself up it was suppose to be a column between B and C so i do the same except highlight C

Answer 22

Yes, lol that woul make more sense.

Answer 23

So are you ok now?

Answer 24

on that one
doing the merge thing again

Answer 25

I have received your spreadsheet, but no instructions.

Answer 26

Either send me the instuctions or explain what you need to do so I can see.

Answer 27

I can see that you have merged the top lines across the columns, but I do not know what they actually asked you to do.

Answer 28

right-justify the text in cells A12 and A25

Answer 29

ok, click on cell A12, go up to your tool bar at the top and look for the justify text buttons, they are the same as you use in Word. find the one that says align text right, click. Do they same for the other cell

Answer 30

oh ok it just puts the text on the right side of the cell

Answer 31

Yes, that is what they mean by right justify the text. Looking at your spreadsheet this would seperate those two totals, expenditure and income, so you can see them clearly away from the other info.

Answer 32

ok and now i have to Indent the text in cells A19:A23

Answer 33

Does it tell you how much to indent them?

Answer 34

it just says indent it doesnt say increase or decrease

Answer 35

I would think they are asking you to move them slightly, click on the cells you need to indent, right click on the mouse and click on format cells.
Click on the Alignment tab.

Answer 36

ok then what

Answer 37

The horizontal alignment should show Left (indent). You should see another Indent box with a drop down list of numbers. Depending on how much you want to indent the info will depend on what number you put here. Try 1, this indents the wording slightly. But you can decide what number works best for you.

Answer 38

Be careful you do not indent it too much or the alignment will change to right and then this will be incorrect. Just check the alignment button on your toolbar sill shows that the cells are left aligned. When you have finished doing this your info should be slightly away from the side of the cell, like you have made them bullet points (without the dots or numbers).

Answer 39

ok, it looks similar to the example worksheet in my text book, now it says move the data in cells B14:B17 to C14:C17

Answer 40

lol, ok, well you should be able to do that yourself, just a bit of cut and paste

Answer 41

Where are you Tina? I just happen to find this web site when looking for something, and saw your help request.

Answer 42

florida u?

Answer 43

London, so it is 7.45am here, and I am just getting ready for my classes for the day.

Answer 44

its 2:45am im up doing homework because I work during the day and get home at 8p so this is the only time i have

Answer 45

now it says In cell C12, sum the income data

Answer 46

=Sum(B7:B11)?

Answer 47

Yes that will do it

Answer 48

should give you 241301 in the cell is that what you have?

Answer 49

some i did pay attention to and understand when I watched the tutorial. yes

Answer 50

well at 2.45am I surprised your brain is still working

Answer 51

This is my second year of college im getting use to it., what are you going to school for. Me BA in accounting

Answer 52

Always best to keep learning. I think you get addicted to it in the end, especially if you didn't do that well at school. I am in my second year of teaching and teach adults maths, but I also teach the 14-16 years olds maths, ICT and personal development.

Answer 53

I wasn't great at school but went to college to learn new things when I was made redundant and haven't left college since, now doing my teaching qualification lol

Answer 54

So how are we going with the spreadsheet have you much more to do?

Answer 55

wow, the world really needs good teachers, ones that still care not just about the check. I think you are gonna be great

Answer 56

i had to do the same for C23 so i used =Sum(B19:B23), now it says in cell C25, sum all the expenditures intems

Answer 57

Thats good, it should be starting to take shape now.

Answer 58

sorry did you say C23, or B23?

Answer 59

so do I use C23

Answer 60

sorry C23

Answer 61

Yes, actually looking at it it looks like all the expenditure total will go in the C column, so you are correct, carry on :-)

Answer 62

do I use =Sum(C12:C24)?

Answer 63

Do you still have expenditure of 3000 in the B column or did that move to the C column?

Answer 64

no it is in column C

Answer 65

i can send you an updated worksheet

Answer 66

Yes, that would be good let me see if it matches mine

Answer 67

A23, this alignment is not right, unless they have asked you to change it. I think it should be aligned the same as A22, so click on A22, click on the format paint button on your toolbar(the one that looks like a paint brush) and then click on A23, that should change it to look the same

Answer 68

C22, this infor should be in C23

Answer 69

yes i am sorry, it said indent A23 again

Answer 70

ok i fixed C22, i drug the info into C23

Answer 71

Total income, did they ask you to put this in the C column, as I had it in B12 not C12, but you may not have told me that.

Answer 72

As I would have thought the income was in column B and the expenditure was in column C, as this will make a difference to how you create your formula for the totals

Answer 73

it says "In cell C25, sum all the expenditures items".

Answer 74

What about the total Income items B12 or C12

Answer 75

in C12 sum the income data
in C23 sum the maintenance expenditure data

Answer 76

my sheet should show everything I have done up until this point

Answer 77

ok, that is fine then.
So you now need to do a sum of the expenditure. remember you must not include C12 in this as this is income. so C14 to C24

Answer 78

=Sum(C14:C24)

Answer 79

Yes, should total 197017

Answer 80

ok thats what i got now it says
In cell C27, enter a formula to calculate the ending cash balance. (Hint:=C12-C25)

Answer 81

I am still a bit concerned about cell C23, as this alignment is showing centred, not left aligned with an indent. Click on the cell and left align and increase the indent to 2 then it will still show as left aligned on the tool bar, not centred.

Answer 82

so its =Sum(C12-C25)

Answer 83

Yes that would be right, should give you 44284

Answer 84

well just =C12-C25 no Sum required

Answer 85

=C12-C25 in cell C27

Answer 86

Column C says align text right

Answer 87

ok, so if you click on the C at the top of the column to highlight the column, right align like you have before. It doesn't acutally do anything you can see with the numbers in the column, but you will see that the right align button on the toolbard is showing, this is what the tutor will look for.

Answer 88

Did you sort out cell C23?

Answer 89

I think that the fill at the top of column F should not be there, unless you have been asked to put anything in column F?

Answer 90

yes the right align text is highlighted
now it says Income items is projected to increase by 6 percent over the previous year. Enter a formula in cell D7 to calculate the increase in cash on hand. (Hint: =B7*1.06) Copy this formula down column D to the other income items. Enter the appropriate function into cell E12 to calculate the 2008 total income value

Answer 91

Is there much more to do, you really need to go to bed, you will be falling asleep at work tomorrow.

Answer 92

this is gonna be my last for the night I am tired and I actually off tomorrow but thanks for the concern

Answer 93

ok, follow the instructions, and you should get a Sum total in E12 of 255779