microsoft excel help

Discussion in 'Computer Programming, Emulation, and Game Modding' started by boof222, Oct 21, 2009.

Oct 21, 2009

microsoft excel help by boof222 at 9:27 AM (750 Views / 0 Likes) 6 replies

  1. boof222
    OP

    Member boof222 GBAtemp Fan

    Joined:
    Jun 26, 2009
    Messages:
    435
    Location:
    NSW
    Country:
    Australia
    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
     
  2. Jiggah

    Member Jiggah GBAtemp Maniac

    Joined:
    Nov 9, 2002
    Messages:
    1,223
    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.
     
  3. boof222
    OP

    Member boof222 GBAtemp Fan

    Joined:
    Jun 26, 2009
    Messages:
    435
    Location:
    NSW
    Country:
    Australia
    even though im very good at both maths and computers i still dont get it
    soz for being a noob [​IMG]

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

    Member Jiggah GBAtemp Maniac

    Joined:
    Nov 9, 2002
    Messages:
    1,223
    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.
     
  5. boof222
    OP

    Member boof222 GBAtemp Fan

    Joined:
    Jun 26, 2009
    Messages:
    435
    Location:
    NSW
    Country:
    Australia
    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
     
  6. Jiggah

    Member Jiggah GBAtemp Maniac

    Joined:
    Nov 9, 2002
    Messages:
    1,223
    Country:
    United States
    Post your formula for the first cell. You only need to absolute reference the $30.00, and not any other cell.
     
  7. boof222
    OP

    Member boof222 GBAtemp Fan

    Joined:
    Jun 26, 2009
    Messages:
    435
    Location:
    NSW
    Country:
    Australia
    dont worry now i figured it out thnx
     

Share This Page