Visual Basic for Applications (VBA)

VBA.1 Explain how VBA can be used in business for making decisons.
Visual basics for applications can be used in business for making decisions by it's aid in organizing and ease of performing repetitive tasks. Decision making will be made easier to modify and edit worksheets.

VBA.2 Define and explain the diference between a subroutine and a function.
A subroutine is a macro you can write any code in between.
A function is what produces the solution.

VBA.3 Record a simple Macro.
1. Go to Start>Programs>Microsoft office>Microsoft Excel to open the application. Then, go to Start>New to open a new spreadsheet.  Go to Tools>Macro>Security, and a pop up window named “Security” will appear. Select the Medium option under the Security Level tab and click OK to continue.Go to Tools>Macro>Record New Macro.