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
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