Do the following in excel VBE:

1. Write the code for calculation of sum of all even numbers from a to b given by user. Repeat it for odd numbers, and numbers which give remainder 0, 1, and 2 when divided by 3. Use mod command.

2. Write the code to display values of x (in column A) and sin(x) (in col- umn B) on interval [a, b] with step s = (b a)/n using DO WHILE loop. The specific values of a, b, n should be entered by InputBox command.