Multiple choice technology

which of the following is not an excel 2007 function

  1. sumsq

  2. sumx2my2

  3. sumx2py2

  4. sumymy2

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SUMYMY2 is not a valid Excel 2007 function. The real Excel functions are SUMSQ (sum of squares), SUMX2MY2 (sum of x^2 - y^2 differences), and SUMX2PY2 (sum of x^2 + y^2 sums). The pattern suggests a fourth function, but SUMYMY2 doesn't exist.