Question ii

Total $=15\%$

Standard items $[3\mathrm{.}0\%]$; Algorithm for inputs and error handling $[3\mathrm{.}0\%]$; Algorithm for determining if there is at least one odd number in the dataset and if there is no odd number $[9\%]$;

On Answer Sheet Qii, develop the algorithm for a Function $($called OddNumber$)$ that will determine if there is at least one odd number in an array of random integers names IntegerDataset$(....).$ The Function's only input, via a worksheet cell, will be the number of random integers $($NumberofIntegers$)$ in the array. Thereafter, the Function will receive from the user, via input boxes, the value for each random integer in the array. If there is at least one odd number in the array, the Function will output: "There is at least one odd number in this dataset". Alternatively, the Function will output: "There is no odd number in this dataset".

Note: If you employ other variables, ensure their names can be easily understood.

Test:

NumberofIntegers $=6$

IntegerDataset$($NumberofIntegers$)=24,4,2,23,56,76$

The output from Function OddNumber$($NumberofIntegers$)=$ There is at least one odd number in this dataset

Question iii

$]=[15\%$

Standard items $[2\%],$ VBA code $[13\%]$

On Answer Sheet Qiii, complete the VBA code that will undertake the task described in Question ii$.$

Hint:

To determine if an integer is an odd number, you may use the VBA Built$-$in Function: Mod

Mod returns the remainder after a Number has been divided by the Divisor. I

For example:

$12$ is an even number because $12$ Mod $2$ returns $0$ i$.$e$.12$ is evenly divisible by $2(6$ times$)$ with a remainder of $0.$

$13$ is an odd number because $13$ Mod $2$ returns $1$ i$.$e$.13$ divided by $2=6$ times with a remainder of $1.$