Question 1 Create a column named "series 1"that has all integers from 1 to 200

(something look like that: 1, 2, 3, 4,..,198,199,200)

Sum the whole series up

Question 2 Create a column named "series 2" that has all ODD integers from 1 to 399

The numbers in this column are: 1, 3,5, 7.....399

Sum these numbers up

Question 3 Create a column named "series 3"

The numbers in this column equal to the number in "series 2" above multiply by 1.5

Sum these numbers up

Question 4 Create a column named "series 4"

The numbers in this column equal to the number in "series 2" minus 2.5

Sum these numbers up

Question 5 Create a column named "square"

Square

In this series, report the square of all integers from 1 to 50

1

like the one in the right hand side

4

Sum these square number up.

9

...

Hint Square function in Excel is:

2500

if you type: "=3^2", Excel will give you the value of 3 square and it equal to 9

Or you simply take the number and multiply by itself.

You can create other column if necessary in order to get the square series

Answer rating: 100% (QA)

Here are the answers to each question Question 1 Create a column named series 1 with integers from 1 ... View the full answer