68.1k views
2 votes
In VBA, write a code that does as follows: The first worksheet ("Ex. 1") has a list of 50 numbers. Write a program that will read them into an array, then will calculate and output the following: - How many of the numbers are even (output in E2) - How many of the numbers are greater than 300 (output in E3) - The average of the numbers (output in E4) - In column B, output next to each number, the difference between that number and the average (can be positive or negative)

1 Answer

1 vote

The answer & explanation for this question is given in the attachment below.

In VBA, write a code that does as follows: The first worksheet ("Ex. 1") has-example-1
User Dapa
by
6.8k points