And I still have concerns about section 8 practice exam question #3

I cannot make clear about the mean that you are asking for the second column:

There is no way that for 2nd column to come up with a mean value of -258.55...it's plausible if it was referring to the 3rd (after removing NAN column one) or 4th column (if nan column one is not removed).