Page 147 - Excel Workbook for Dummies

14_798452 ch09.qxp 3/13/06 7:52 PM Page 130
130 Part II: Using Formulas and Functions

3. Position the cell cursor in cell G8 and construct a formula with the SUMSQ func-
tion that sums the squares of the value in cell B2 with that in cell D2.
Excel returns a total of 52 to cell G8.
4. Verify the calculated result returned by the SUMSQ formula in cell G8 by con-
structing the following simple formulas in the designated cells that replicate its
computation:
• Formula in cell D8 that squares the value in B2
• Formula in cell E8 that squares the value in D2

• Formula in cell F8 that adds the value in D8 to that in E8
To square a value in a cell, insert the cell reference followed by the caret (^)
operator and 2 (for example, =B2^2 to square the value in B2).
The calculated total returned to cell F8 should now match the one in cell G8 next
door.
5. Position the cell cursor in cell G10 and construct a formula with the SUMSQ func-
tion that sums the squares of the first array in the cell range B2:B3 with that in
the second array in the cell range D2:D3.
Excel returns a sum of 86 to cell G10.
6. Verify the calculated result returned by the SUMSQ formula in cell G10 by con-
structing the following simple formulas in the designated cells that replicate its
computation:
• Formula in cell B10 that squares the value in B2
• Formula in cell C10 that squares the value in B3
• Formula in cell D10 that squares the value in D2
• Formula in cell E10 that squares the value in D3
• Formula in cell F10 that sums the values in cell range B10:E10
The calculated total returned to cell F10 should now match the one in cell G10.
7. Position the cell cursor in cell G12 and construct a formula with the SUMX2MY2
function that calculates the difference between the squares of the first array in
the cell range B2:B3 and that in the second array in the cell range D2:D3.
Excel returns a sum of -4 to cell G12.
8. Verify the calculated result returned by the SUMX2MY2 formula in cell G10 by
constructing the following simple formulas in the designated cells that replicate
its computation:
• Formula in cell B12 that squares the value in B2
• Formula in cell C12 that squares the value in B3
• Formula in cell D12 that squares the value in D2
• Formula in cell E12 that squares the value in D3
• Formula in cell F12 that subtracts the sum of B12 plus C12 from the sum of
D12 plus E12
When constructing the formula in cell F12 that subtracts the sum of B12 and C12
from the sum of D12 plus E12, be sure to enclose the values to be summed
(B12+C12) and (D12+E12) in parentheses.
The calculated total returned to cell F12 should now match the one in cell G12.