MOS Excel Epert exam taken

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hi,

Recently sat the Excel Expert exam and just failed. Must admit did not study as much as I should have done (cocky feeling having spent several years using excel!). Found the questions quite difficult compared to the on-line timed and none timed practice exam. Something I would like clarifying is whether I had a Vlookup or Hlookup question. The range that was named was a table across two rows, so I took it that it was a Hlookup reference(?).

Well I've learnt my lesson and will now dedicate much time to revision for the resit. I know that if you study well then the exam is readily passible.
I'd like to ask whether anyone has used study material other than the college booklet given out?

Cheers,

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

I used the MS press books when I did the 2000 exams, the 2003 one are here: http://www.microsoft.com/mspress/books/5605.asp

 

Bad luck matey.
I would learn from that and the next time come out with a pass.
Good luck

 

That Damn exam has become my bloody Jonah... Sat the word expert and flew through it sat the excel and failed sat it again and failed.... Bloody pain in the A***.

 

bad luck..but yes your correct HLookup is for rows...V is for columns.

 

Hi SQLearner,

I would recommend using CBT to study for the exams. It gives you a lot more hands-on practice.

I passed the exams using books, CBT was not available, and looking at the stuff available these days makes me mad at all the time I had to sit there flicking through pages and reading instructions.

Keimos

 

I would hazard a guess that SQLearner doesn't hang around here anymore Keimos - 5 posts since joining a year ago.. Hmm. :hhhmmm

 

Hi Baba O'Riley,

Whoops, only looked at the first part of the date, not the year.

Keimos

 

Not to worry, the information's there for others at least.

 

ha, well some of us do still hang around like stalkers, just watching.

Check my last post!!!! 19-Feb 2005