In excel, my data is populated from Cell `B1`

to `B10`

in Excel. I want to obtain the sum of the squares from `B1`

to `B10`

.

I could use a simple function `POW(B1,2)+POW(B2,2)......+POW(B10,2)`

. But this is too cumbersome to write and error prone.

Is there a shortcut function that is similar to `SUM(B1:B10)`

?