microsoft excel help

[boof222]

ok im doing this excel spreadsheet thing for math/computers and im stuck at these two questions

write a spread sheet as shown to list the days 1 to 14

A B C D E F G H I J K L M N O
1 Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14
2 Money $1 $2 $4 $8

in row 2 start with $1 in day 1 and write a formula in C2 that will double the amount for each succesive day.

and

copy the spreadsheet and enter and enter $30.00 in cell C1

A B C
1 Cost of ticket $30.00
2 Number of
3 Tickets Cost
4 1
5
6
7
8
9
...
18 15

write a formula in A5 and use the fill down command to complete the number of tickets from 1 to 15.

in the cost column write a formula in B4 that will give the cost of a ticket multiplied by the number of tickets
HINT: use an absolute cell reference for the cost of 1 ticket

i have done every other question and we didnt even learn this any help would be appreciated

 

[Jiggah]

Absolute cell reference means you put $ with the cell number.

So, instead of say b4, you'd type it as $b$4. This allows you to do the fill command, which is basically dragging to fill in the rest of the cells with the same equation, without it changing on you.

The first one is basic math. Powers of 2.

 

[boof222]

even though im very good at both maths and computers i still dont get it
soz for being a noob

EDIT: i can get the cost of one ticket but thats it when i fill down it just fills down the answer

 

[Jiggah]

You're just putting in $30.00. You need to put in an actual formula.

What is the cost of 2 tickets? 3 tickets?

How did you find out those costs? Once you find the formula, you should be able to apply it to the single ticket and then fill in the rest. The formula is elementary mathematics.

 

[boof222]

no i did the formula
but when i press fill down it just fills down $30.00

EDIT: and as you can see the educational system is alot different in aus

 

[Jiggah]

Post your formula for the first cell. You only need to absolute reference the $30.00, and not any other cell.

 

[boof222]

dont worry now i figured it out thnx