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

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.

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

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.

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

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