Results 1 to 12 of 12
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    How well do you know Excel?

    Here is a quick quiz that will test (and score) your "genius" knowledge on Excel. <img src=/S/trophy.gif border=0 alt=trophy width=15 height=15>

    OK...gimmi the test...lets see if I can ace it!!!
    Regards,
    Rudi

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Brantford, Ontario, Canada
    Posts
    2,391
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How well do you know Excel?

    8 out of 10.

    I didn't know number <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">1. Fill Handle. I said 'Fill'.</span hide>

    OR ... number <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">9. Format Painter. I said 'Clipboard'</span hide>

    I'm arguing my answer for my first mistake as correct!
    Christopher Baldrey

  3. #3
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: How well do you know Excel?

    I also got 9 out of 10.

    I gave the same answer as Chris to #1

    StuartR

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: How well do you know Excel?

    9 out of 10 also.

    For no 2 I wanted to use <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold"> Paste Transpose</span hide>
    Regards
    John



  5. #5
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: How well do you know Excel?

    That's what I would have used for #2 if it had been a choice.

    StuartR

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How well do you know Excel?

    8/10

    I also muffed #1 and said <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Data Series</span hide>

    For #9 I said <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Paste Special</span hide> which is also a correct method I believe.

    Alan

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How well do you know Excel?

    I think questions 1 & 2 are bad questions:

    For question 1 I answered Fill Series which I think is correct. I do not think that Fill Handle is correct since it could also result in Fill Copy which would not do what was asked.

    For question e I answered "None of the above" since Paste/Special/Transpose was not a choice and I think Pivot Table is not the best tool to do what was asked, even if it can accomplish the desired result it is to complicated for the asked question.

    I got all the rest correct.
    Legare Coleman

  8. #8
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How well do you know Excel?

    I'm with you Chris!
    Regards
    Don

  9. #9
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How well do you know Excel?

    I also feel tha #6 " Add $ before the cell reference " was incorrect as this will provide only a partially absolute reference--the row will still be relative.
    Regards
    Don

  10. #10
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Brantford, Ontario, Canada
    Posts
    2,391
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How well do you know Excel?

    We all know too much. Wouldn't it be a drag if for the quiz author if we gave him/her a list of the 'actual answers' ??
    Christopher Baldrey

  11. #11
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How well do you know Excel?

    I got 9/10 when I tried it. As with the arguments being raised...I will give myself #1 as I answered <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Auto Fill</span hide> since that is how I have come to know it.

    It seems like were are ALL guru's on Excel <img src=/S/grin.gif border=0 alt=grin width=15 height=15> OR the quiz was too easy...although not judging by the scores of all the others who attempted the quiz.

    BIG <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> to the lounge!
    Regards,
    Rudi

  12. #12
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How well do you know Excel?

    I think that the time would be better spent assisting those who ask
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •