microsoft excel help

boof222

Well-Known Member
OP
Member
Joined
Jun 26, 2009
Messages
435
Trophies
0
Location
NSW
Website
Visit site
XP
280
Country
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

Well-Known Member
Member
Joined
Nov 9, 2002
Messages
1,223
Trophies
0
Website
Visit site
XP
279
Country
United States
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

Well-Known Member
OP
Member
Joined
Jun 26, 2009
Messages
435
Trophies
0
Location
NSW
Website
Visit site
XP
280
Country
even though im very good at both maths and computers i still dont get it
soz for being a noob
frown.gif


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

Jiggah

Well-Known Member
Member
Joined
Nov 9, 2002
Messages
1,223
Trophies
0
Website
Visit site
XP
279
Country
United States
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

Well-Known Member
OP
Member
Joined
Jun 26, 2009
Messages
435
Trophies
0
Location
NSW
Website
Visit site
XP
280
Country
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
 

Site & Scene News

Popular threads in this forum

General chit-chat
Help Users
    K3Nv2 @ K3Nv2: http://aliexpress.us/item/3256807254080439.html?businessType=ProductDetail&srcSns=sns_Copy&spread...