+ Reply to Thread
Results 1 to 7 of 7

Answers to MOS Guide?

  1. #1
    Registered User
    Join Date
    01-14-2009
    Location
    Fa, CA
    MS-Off Ver
    Excel 2013
    Posts
    53

    Answers to MOS Guide?

    Are the answers available for the Excel MOS Excel Expert Expert Exam Study Guide practice questions?

  2. #2
    Registered User
    Join Date
    08-18-2015
    Location
    Zurich, Switzerland
    MS-Off Ver
    2013
    Posts
    7

    Re: Answers to MOS Guide?

    Neither did I find them. Which ones do you need? I recently worked myself through the book.

    By the way, I cannot recommend to study with the official study guide since it does not adequately cover the questions asked on the exams.
    Check also the reviews on amazon - this book is unfortunately a waste of money.
    Last edited by Lol123; 08-18-2015 at 04:48 PM.

  3. #3
    Registered User
    Join Date
    01-14-2009
    Location
    Fa, CA
    MS-Off Ver
    Excel 2013
    Posts
    53

    Re: Answers to MOS Guide?

    Mostly I think I get most of it but still not at all sure of what I need to know for the test.

    I have a set of videos by Kirt Kershaw "Video Trainer Excel 2013" and a Groupon deal for Microsoft Office which is only basic. I do have some programming experience in some scripting languages.

    Can you clue me in please? I would really appreciate it.

    The only question so far I think now that I am on round two through that book is regarding Chapter 3 ExcelExpert_3-1b workbook regarding Interest and Security formulas. I have never really done any work in those areas. Maybe I just need to stare at it longer.

    Edit: Actually, I am not sure exactly what they want on any of those questions ExcelExpert_3-1a of ExcelExpert_3-1b

    Thank you!
    Last edited by endly; 08-19-2015 at 08:15 AM.

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Answers to MOS Guide?

    Has anyone tried the MOS (Any of the 3 Level) exam yet?
    Cheers!
    Deep Dave

  5. #5
    Registered User
    Join Date
    08-18-2015
    Location
    Zurich, Switzerland
    MS-Off Ver
    2013
    Posts
    7

    Re: Answers to MOS Guide?

    Really, forget the book. I trained with GMetrix and passed today.
    They have three trial exams for the first part that come very close to the level of Microsoft’s exams.
    I suggest to additionally exercise:
    - Custom Conditional Formatting
    - Creating Charts that include a series (column B) but only when column D is characterized as “staatsma” or something like that.*
    *Unfortunately, I do not remember the exact wording of the task nor did I know what to do. I did the test twice and both times, they asked this kind of question.
    If you have everything else 100% correct, you’ll pass with exactly 700 points =)

  6. #6
    Registered User
    Join Date
    01-14-2009
    Location
    Fa, CA
    MS-Off Ver
    Excel 2013
    Posts
    53

    Re: Answers to MOS Guide?

    Congratulations!

    Thank you! The GMetrix is a great tip. I am using it now. I am paying serious attention to your advice.

    Thank you and again, congratulations!

  7. #7
    Registered User
    Join Date
    08-18-2015
    Location
    Zurich, Switzerland
    MS-Off Ver
    2013
    Posts
    7

    Re: Answers to MOS Guide?

    Thank you, endly. Yesterday, I passed the second part. Since I have the feeling that Microsoft’s MOS Exams are a huge rip-off, I’m more than happy to share my experiences so you pass the first time =)

    For the second part, I strongly recommend to train with GMetrix again.
    Additionally, know the custom formatting codes (http://www.ozgrid.com/Excel/CustomFormats.htm) and know the functions like „isblank“,
    „isnontext“ etc.

    By the way, since you are from the US, you can buy an exam voucher with retake for 120$ (http://shop.certiport.com/product-p/12000485.htm)

    Good luck!
    Last edited by Lol123; 09-01-2015 at 04:41 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count the number of matches in a row of one word answers with a row of correct answers
    By flammer4 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2012, 01:17 PM
  2. Substitution! Please guide
    By hedonistic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2011, 10:44 AM
  3. VBA Guide or resource
    By Aussiexile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 01:59 AM
  4. staffing guide
    By Dryclean in forum Excel General
    Replies: 7
    Last Post: 12-07-2008, 06:32 PM
  5. Please Guide Me , I Need Some Help ?
    By khanjee in forum Excel General
    Replies: 1
    Last Post: 03-20-2007, 05:37 AM
  6. Excel Guide
    By Rossella in forum Excel General
    Replies: 2
    Last Post: 01-18-2006, 05:25 AM
  7. [SOLVED] Guide:help
    By TONY in forum Excel General
    Replies: 4
    Last Post: 11-18-2005, 10:15 AM
  8. [SOLVED] Friends: Please guide me
    By PRASAD RAO SEERA in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-09-2005, 07:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1