1.) Write a VBA program using the flowsheet right!

1. Practicing exercises for Test 1 1.) Write a VBA program using the flowsheet right! (Declare k as Integer, y and m as Double!) Let be the output of the program the given table: 2.) Write the column heads, the first column and the cells B2, E1, E2, E3, F1, F2, F3 in an Excel Worksheet. Thereafter fill in the columns B and C „pulling down” the following formulae: b3=b2+(a3-a2)*2*cos(3*a3) c2= f$1*a2^2+f$2*a2+f$3 Create a diagram from the data of columns A, B and C, as it is given on the figure below. Write the square of differences of the corresponding cells of columns B and C using cell references into column D, and in the Cell D13 write the sum of the values above it . Minimize the value of the Cell D13 using Solver by changing the values of the first three rows in column F. Create a report sheet by Solver. 3. Given is the function f(k)=3/(k2+5k+6) . Write a VBA program that evaluates the sum given here: Use InputBox to read the values of m and p, where p means the value of k, where the program starts to write the value of Sum, too. The variables m, p and k are Integer, Sum is Double, f is as Function defined. If the Input data are m=5 and p=3, the program should write the table right