Write a VBA function that receives 4 numerical inputs (input1, input2, input3, and input4) and performs the following operations in the stated order:
a. Calculate the average of the numbers.
b. Calculate the square root of a.
c. Multiply b by input1
d. Divide c by "input2 + input3"
e. The function should return the result from d. Use your VBA function to calculate the results based on the following sets of input parameters:
input1 input2 input3 input4 calc'd result
1 2 15 44 ?
2 5 13 87 ?
3 6 54 12 ?
4 9 33 27 ?
5 13 52 62 ?
6 22 36 47 ?
7 11 65 18 ?