PROBLEM 2 (due Oct 21, 10 points)


Create the following worksheet.

First create the following table of numbers:

Column A starting with row 2 should contain the numbers 1, 2, ..., 30.
Column B should contain the numbers 1^2, 2^2, ..., 30^2.
Column C should contain the numbers 1^3, 2^3, ..., 30^3.
Column D should contain the numbers 1^4, 2^4, ..., 30^4.
Column E should contain the numbers 1^5, 2^5, ..., 30^5.

You can perform this task without a lot of typing.

Then in row 32, you need to compute the sum of all the numbers lying above, so that A32 contains the sum of all numbers from A2 to A31, and B32 contains the sum of all numbers from B2 to B31, etc.

Then in column F, you need to compute the sum of all numbers lying to its left, so that F2 contains the sum of all numbers from A2 to E2, and F3 contains the sum of all numbers from A3 to E3, etc.

Finally, cell F32 should contain the total sum of all the numbers in the table (not including the partial sums).