MOS Excel (specialist) 40% in Function and formulas. WHY?!

[roilorcas]

Hi guys.

Im here looking for a solution of a problem im triying to solve:

in the Mos Excel 2013 im reaching 40% in function and formulas section and i dont know why
And i am wondering: Which one is the best/proper way of using the functions?

 

[Joe4]

Welcome to the Board!

Your question is a bit confusing.
I am guessing you mean "MS Excel" and not "Mos Excel". I believe that "MOS Excel Specialist" is a professional designation, not a program (not sure why you are mentioning it here).

When you say "40%", what exactly are you referring to? Is is the Calculation percentage?
If so, do you have a ton of calculated fields on your file? If so, how many calculations are we talking about (how many cells have formulas in them)?

 

[roilorcas]

Yes, sorry. im talkin about the excel certification exam

In the category "functions" im getting 40% of 100% as a score, so im wondering how is the proper way to use functions to achieve the 100% of teh exam