only original work accepted, i.e. no macro recordings accepted

computer science


Test 1: only original work accepted, i.e. no macro recordings accepted 

1. Create a macro that adds the even numbers between 2 and 76 

2. Create a function that finds the standard deviaton of three user defined inputs and prints it to the immediate window 

3. Create a sub that fills in the range a1:b2 with the word "January" and then copies "January" to a range called NewRange (which is d1:e2) 

4. Create a sub that asks for the user's salary and then returns how much tax they should pay.

5. Write a code offering the user 10% discount if order is <10, 20% discount if order is 10 to 20 and 30% discount if order is 20 or greater. Do this both as an IF and SELECT/CASE statement. 

6. The Function ReverseText, (in the macro called Reverse_Text), doesn't work properly, fix it so it does. 

7. Write a procedure that clears the contents of cells f3, g5, and h8 of sheet2, 

Related Questions in computer science category

The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.