Results are out! Find what you need...fast. Get quick advice or join the chat
Hey! Sign in to get help with your study questionsNew here? Join for free to post

Absolute Cell Referencing?

Announcements Posted on
Applying to Uni? Let Universities come to you. Click here to get your perfect place 20-10-2014
    • Thread Starter
    • 0 followers
    Offline

    ReputationRep:
    Hi, today I had my GCSE ICT exam with CCEA and I had two questions on absolute cell referencing. These were two of the three questions that I had trouble answering so I just want to know if I even got close.

    Question One
    What is an absolute cell reference?

    Answer
    A cell reference that does not change after a formula has been calculated.


    Question Two
    Write the absolute cell references for:
    F13 ____
    F19 ____

    Answer
    $F$13
    $F$19


    Do you reckon I could score any marks on either of these questions? I was hoping for an A* but we'll see. I hadn't really a clue what absolute cell referencing was but I remembered something about my teacher mentioning the words "staying the same" during that class so I just sort of guessed. I also remember reading "$m$4" in that class which sort of lead me to the other answers.

    Thanks.
    • 43 followers
    Offline

    ReputationRep:
    (Original post by overskrill)
    Hi, today I had my GCSE ICT exam with CCEA and I had two questions on absolute cell referencing. These were two of the three questions that I had trouble answering so I just want to know if I even got close.

    Question One
    What is an absolute cell reference?

    Answer
    A cell reference that does not change after a formula has been calculated.


    Question Two
    Write the absolute cell references for:
    F13 ____
    F19 ____

    Answer
    $F$13
    $F$19


    Do you reckon I could score any marks on either of these questions? I was hoping for an A* but we'll see. I hadn't really a clue what absolute cell referencing was but I remembered something about my teacher mentioning the words "staying the same" during that class so I just sort of guessed. I also remember reading "$m$4" in that class which sort of lead me to the other answers.

    Thanks.
    The second part is correct with those dollar signs.
    The first part is not quite right.
    It's a cell reference that doesn't change after the cell has been copied or moved.
    • Thread Starter
    • 0 followers
    Offline

    ReputationRep:
    I'm pretty sure it was a two mark question, do you think there's any chance I could get one mark for it or not at all? Altogether I'm not too bothered because I don't need that high of a mark to get a good grade, but it would make up for another question which I definitely got wrong.

    Possibly for the "A cell reference that doesn't change..."
    • 0 followers
    Offline

    ReputationRep:
    (Original post by overskrill)
    I'm pretty sure it was a two mark question, do you think there's any chance I could get one mark for it or not at all? Altogether I'm not too bothered because I don't need that high of a mark to get a good grade, but it would make up for another question which I definitely got wrong.

    Possibly for the "A cell reference that doesn't change..."
    What did you think about that exam in general anyway? I thought it was extremely simple! I think that's the only part I slipped up on - the absolute cell references. I think I got the first bit but not the second bit.
    • Thread Starter
    • 0 followers
    Offline

    ReputationRep:
    (Original post by JDee)
    What did you think about that exam in general anyway? I thought it was extremely simple! I think that's the only part I slipped up on - the absolute cell references. I think I got the first bit but not the second bit.
    Yeah overall I thought it was easy, quite a few people I asked thought it was okay, too.
    • 43 followers
    Offline

    ReputationRep:
    You would need to consult the mark scheme to see if you would get the mark for the definition.
    My own view would be that the answer that it doesn't change "after a formula has been calculated" is not 100% correct and can't get the one mark available. But that's just my view!
    Someone else may be of the opinion that the "doesn't change" bit is enough to get the mark.
    • 1 follower
    Offline

    ReputationRep:
    CCEA mark scheme answer for this question on previous years was:

    An absolute cell reference is a cell reference which does not change [1] when moved or duplicated/copied [1]

    I thought it was a good test also. What did you guys get in your controlled assessment?
    • Thread Starter
    • 0 followers
    Offline

    ReputationRep:
    I think I got 58% out of the 60 available on the controlled assessment. I probably could have achieved higher but I didn't want either of my teachers to help me for some reason..
    • 1 follower
    Offline

    ReputationRep:
    Yeah that is what I am sitting on too. Teacher said in or around 87% should get you an A* overall which is about 130/180 for us in that test
    • Thread Starter
    • 0 followers
    Offline

    ReputationRep:
    Hm, that's not too bad. I counted it and I was pretty sure I got at least around 140-155 marks, not including the questions that I wasn't entirely sure about.

    Pretty confident about it now.

Reply

Submit reply

Register

Thanks for posting! You just need to create an account in order to submit the post
  1. this can't be left blank
    that username has been taken, please choose another Forgotten your password?
  2. this can't be left blank
    this email is already registered. Forgotten your password?
  3. this can't be left blank

    6 characters or longer with both numbers and letters is safer

  4. this can't be left empty
    your full birthday is required
  1. By joining you agree to our Ts and Cs, privacy policy and site rules

  2. Slide to join now Processing…

Updated: June 2, 2012
New on TSR

Submitting your UCAS application

How long did it take for yours to be processed?

Article updates
Reputation gems:
You get these gems as you gain rep from other members for making good contributions and giving helpful advice.