Microsoft Excel 2007/2010 Exam Q&A pt 1

Microsoft Excel 2007/2010 Exam Q&A pt 1

Click on the link to download file practice file http://simpletek.ca/files/ Pt 2: https://www.youtube.com/watch?v=SBnBO-BFrx0 A quick recap of important Q&A …

25 Responses to Microsoft Excel 2007/2010 Exam Q&A pt 1

  1. NsJ says:

    it seems like most of these are beginner

  2. Kay's Ways says:

    I’ve been at my job for 14 years but don’t use Excel too often. I have an
    Excel test for a new position tomorrow and this video was super helpful.
    Thanks for this info, I feel wayyy more confident now for tomorrow. 

  3. Waseem Ilyas says:

    thanks first of all, can I ask you one question, any one can answer. I
    created a form (thanks to your videos) to enter guest arriving and leaving.
    there is one field dateArrival and other is DateLeaving third one is
    Duration or Stay. now i made form with name phone number vehicle number
    Duration Arrvialdate and Dateleaving = ArrivingDate + Duration . all other
    fields updated in main table just this one remain empty unless i run update
    query can y ou help me

  4. NsJ says:

    Appreciate these videos! I have just one question. Do your tutorials
    include questions from the “Microsoft Excel 2010 – Power User” assessment?

  5. Nicole Myers says:

    @25.27: to remove ONE country column you would click the “Column Labels”
    tab and leave whichever selection you wish to be viewed. Just in case
    anyone was wondering. 

  6. Malissa H says:

    It’s blurry..can’t see this!

  7. canadate123 says:

    Would this video and part 2 be enough for the “prove It” employment test ?

  8. TDiva22 says:

    Watched this yesterday. Took the test today and got a 87% 26 out of 30
    correct. Thank you. Now I have to prepare for the “super user” test. 

  9. Kavya Thota says:

    There were 4 “Paul”s in the Countif portion. It returned a number 3. Is
    that because it only takes JUST Paul and not the last name?

  10. Desiré Martinez says:

    Thank You so much Amir!! I passed all my tests and got offered the job! You
    are a life saver! Best Wishes to you.

  11. Stacy Mathis says:

    Hi, how can I find the practice files?

  12. Shani Price says:

    This was very helpful now I feel pretty good taking my Excel test.
    Thanks-A-Million

  13. El Poser says:

    Your videos are great! Really helped me with my proveit placement tests. Do
    you have any on Quickbooks, or can you recommend any? That is my next
    proveit exam.

  14. Farah Adam says:

    i was asked to edit the column so that all SSN show the last 4 digits only,
    how is that done?

  15. Kristen Bruce says:

    I got a 95% on the Excel 2010 – Whole Test! I watched part 1 and 2 twice.
    The second time I used the practice file! I took some notes on the harder
    items. The global average is 68% and I’m in the 90th percentile thanks to
    you! The recruiter called me within minutes of completing the test to
    schedule an appointment to meet me and for me to meet some other people as
    well. He said that scores like mine hardly ever happen! Thank you thank you
    thank you!

  16. deepak sharma says:

    Hey Amir, thanks for this video, your tuit was very helpful, I cleared
    excel 2010 test with good scores !!

  17. Tres Nueve says:

    THANK YOU FOR THIS

  18. Marisa L says:

    Thank you sooo much! I definitely wouldn’t have been able to do this
    without your tutorial. I scored an 83% on the proveit normal user excel
    test! I didn’t really have any prior knowledge to excel before watching
    your videos. :) 

  19. Porsche ligon says:

    thank so much 

  20. Okanehira says:

    Thank you, this was extremely helpful.

  21. Uodiyala Diyala says:

    Thanks in advance
    http://www.uodiyala.edu.iq

  22. laci dizzle says:

    I have taken a ProveIt test and this covers everything I need. Thankfully
    they gave me the chance to retake it. A lot of it is review, but I haven’t
    used it in so long I just froze! lol Thank you so so much for this!

  23. Ruth Lambert says:

    Vere good explanation,Thank you

  24. Audra Jackson says:

    These are all so helpful. Thank you so much.

  25. NADEEM ABBSAI says:

    THANKS BROTHER………. You are The BEST.

Leave a Reply

Your email address will not be published. Required fields are marked *