Excel Test

  • Creator
    Topic
  • October 24, 2010 at 7:06 pm #158939
    tiffiwiffi1
    Participant

    I have a meeting with a staffing firm. I will be required to take an excel test. I am in the learning process with excel functions? Does any of you know what I can expect to see on the exam and how can I prepare for it? Thanks so much!!!

    follow me on the cpa road

Viewing 6 replies - 1 through 6 (of 6 total)
  • Author
    Replies
  • October 24, 2010 at 8:28 pm #255252
    whitesoxfancpa
    Participant

    I've had to take a couple Excel tests before and in my experience, they're pretty basic. Anything you'd learn in a beginner's course from Best Buy should be more than enough. I'd recommend getting one if you are not experienced with Excel.

    AUD 96 FAR 95 REG 94 BEC 88

    October 24, 2010 at 8:41 pm #255253
    tiffiwiffi1
    Participant

    Whitesoxfancpa,

    Thanks for your reply. I have excel for dummies workbook. Should I be studying out of Microsoft excel 2003, 2007 or 2010? Did you have to do any v lookups or pivot tables? Thanks again!!!

    follow me on the cpa road

    October 24, 2010 at 8:46 pm #255254
    whitesoxfancpa
    Participant

    I'm not sure which edition to study. I don't know that it'll make a huge difference. I did not have to do pivot tables or v lookups. That was just my experience, though. Yours could be different so don't hold me to this!

    The tests I had to take were pretty short, maybe 20 minutes each. They were simple commands. “In Cell D6, enter a formula to add the numbers in Cells D1 through D5,” for example. So you'd type “=sum(D1:D5)” in Cell D6.

    Sorry I can't be of more help! Good luck! I'm sure your Excel for Dummies book will be more than enough.

    AUD 96 FAR 95 REG 94 BEC 88

    October 24, 2010 at 8:54 pm #255255
    tiffiwiffi1
    Participant

    Thanks for all of your advice!! I really appreciate it. Congrats to all of your success on passing 3 sections of the cpa exam with high marks!!! That's awesome!!!

    follow me on the cpa road

    October 24, 2010 at 9:25 pm #255256
    potatogun
    Participant

    2003 or 2007 is more likely. However the basic functions are going to be fairly similar as long as you know what they are called in the menus.

    Vlookups and pivot tables are key for down the line but I wouldn't assume a entry level position would demand a candidate knowing how to use them.

    FAR 92 - AUD 91 - REG 94 - BEC 86

    October 24, 2010 at 9:47 pm #255257
    tiffiwiffi1
    Participant

    Potato gun,

    Thanks for responding. What basic functions should i know? I currently have 3 years A/P experience but dont have on the job excel experience…

    follow me on the cpa road

  • Author
    Replies
Viewing 6 replies - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.