Help with Word and Excel Tests

Discussion in 'Off The Beaten Track' started by FiveRinger, Mar 8, 2012.

  1. FiveRinger

    FiveRinger Well-Known Member

    3,908
    712
    113
    I have to take a Word and Excel tests for a job that I applied for. It's been years since I've done this type of assessment and was kind of surprised at having to do one now. Anyway, long story short, does anyone know if there are websites that have good tutorials and assessments that I can practice on? I am pretty good with both programs, but when testing, you never know what they're going to ask and from what I remember, they can be tricky. Thanks in advance for your help! :)
     
  2. FigureSpins

    FigureSpins New Member

    2,062
    200
    0
    www.lynda.com is good. www.dice.com has a consultant cram board where they can learn enough to get past the tech interview.
     
    FiveRinger and (deleted member) like this.
  3. agalisgv

    agalisgv Well-Known Member

    24,051
    4,430
    113
    Don't know any websites, but best of luck on the job!!!
     
  4. Aussie Willy

    Aussie Willy Well-Known Member

    18,145
    2,174
    113
    When I was doing temp work I went to so many agencies that used so many different types of tests for both Word and Excell. Biggest pain these days is trying to come to grips with Office 2010. Why do they have to try and make everything so "user friendly"? Doesn't help when you are so used to the older versions.

    Good luck with it all and hope you get the job.
     
  5. UMBS Go Blue

    UMBS Go Blue KWEEN 2016! YES WE KWAN!

    13,618
    5,259
    113
    Here's what seems to be a good tutorial on how to strategize for an Excel modeling and business planning exercise:
    http://www.youtube.com/watch?v=NJfvkFDxus0

    This guy has a number of Excel videos up at his channel (wstss):
    http://www.youtube.com/watch?v=k7a94-5auVo

    Unless I'm selecting multiple non-adjacent cells, or large ranges of cells, I try to avoid using the mouse if at all possible on Excel, except for certain functions for which I've built a customized toolbar. Here's a list of Excel shortcuts; there are probably many more lists out there.
    http://www.exceltip.com/st/The_Best_Shortcut_Keys_in_Microsoft_Excel/1.html

    The shortcuts I use the most include Ctrl-C, Ctrl-X, Ctrl-V, Ctrl-Z, Ctrl-Y, Ctrl-1, Alt-E-S-V, Alt-E-S-T, Ctrl-[arrow], and, of course, F9 (assuming autocalc is turned off).
     
    Last edited: Mar 9, 2012
    FiveRinger and (deleted member) like this.
  6. JILEN

    JILEN New Member

    2,886
    270
    0
    What i hate about those tests are the short time limit. You are asked to do this and that and before you can figure it out it's time to move on to the next. Last one I took where I have to link formulas in multiple worksheets and sort data and produce three kinds of graph at the end drove me crazy. Bottom line I told them then that my score does not reflect my overall excel skills.

    I also remember some sample test I took on line but I have to buy them if I can only remember the link...


    Go get them Fiveringer!
     
  7. FiveRinger

    FiveRinger Well-Known Member

    3,908
    712
    113
    I just wanted to thank everyone for their input......I took my tests this morning and passed with flying colors. Thanks to everyone!!!


    ETA: It helped a lot that I was given the choice of which versions of Microsoft I wanted to use....2003, 07 or 2010.
     
  8. UMBS Go Blue

    UMBS Go Blue KWEEN 2016! YES WE KWAN!

    13,618
    5,259
    113
    :cheer2: :respec: :cheer2:
     
  9. agalisgv

    agalisgv Well-Known Member

    24,051
    4,430
    113
    Congrats, and good luck with the job!!!
     
  10. JILEN

    JILEN New Member

    2,886
    270
    0
    Congrats!!!!
     
  11. Aussie Willy

    Aussie Willy Well-Known Member

    18,145
    2,174
    113
    Well done on the tests :)