i think it depends what your company uses say excel for.
i know little about charts,dont use them dont need them,but can get by but any test ive taken with excel i fail miserably on that section.
similarily, loads of the on line tests check to see if you know how to use all the short cuts not the fact you know how to get them the longer way.