Question
Question 1 Create a column named series 1that has all integers from 1 to 200 (something look like that: 1, 2, 3, 4,..,198,199,200) Sum the
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Here are the answers to each question Question 1 Create a column named series 1 with integers from 1 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started