Question: This is an exercise in using dynamic array functions and composing them. Given a number t , output a column of the first t positive

This is an exercise in using dynamic array functions and composing them. Given a number t , output a
column of the first t positive even numbers starting at 2.
We have high expectations of your program: it must work correctly for any t between 1 and 106. For
t =107 it is allowed to fail. Test your formulas for t =7 and t =10. You may put the output of your
computation in any convenient cell in the grid.
There are several ways to solve this problem. (1) You could write a new Excel function called
E v enN umber s (t )
and call it in a cell where you want the output column. But we will learn this only next week. (2) You
could choose a cell where you keep the input t and name the cell t . You write formula(s), which compute
the output column for t . Approach (2) is the quickest solution but is not easy to use. If you want the
output for a different input in a new cell, you have to copy your formula(s). Approach (1) gives you a
function you can call anywhere on the grid without copying. What to turn in:

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!