Question: Example L . 1 . 1 . Let's use Excel to build the sequence with first term a 0 = 4 and common difference d

Example L.1.1. Let's use Excel to build the sequence with first term a0=4 and common difference d=3.
(1) Be sure you have your Lab 1 Excel Template open to the "Example L.1.1.-2." tab.
(2) We will put our index in column A. After entering the first few indices (e.g.,0,1,2 in A2,3, and 4), highlight these cells then move your cursor to the bottom right corner of the highlighted boxes until your cursor becomes a black plus. Dragging down will cause Excel to autocomplete. Drag down until you reach an index of 20.
(3) Next, let's create our sequence in column B. We start by putting 4 in B2(i.e., the n=0 term). Since we get to the next term in the sequence by adding 3 to the previous, in B3, we put "=B2+3". The "=" indicates to Excel that you are writing a formula and our formula instructs Excel to add 3 to the entry in B2.
(4) To complete the sequence, highlight B3 and, as when filling in Column A, drag down from with the black plus until you get to term 20. If you've done things correctly, you should have an arithmetic sequence ending at 64 in cell B22.
 Example L.1.1. Let's use Excel to build the sequence with first

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!