You want to create a public macro named Payment.  In the space below, type the appropriate code to create this public macro that will include the following steps:  (14 points Provide a comment with the date the macro was created Select Cell G6 using absolute referencing Display a dialog box that asks the user to Enter Vendor Number.  Give the dialog box the title Vendor, and place the user’s response in the current active cell. Select the cell that is one cell below the current active cell using relative referencing. Display a dialog box that asks the user to Enter Payment Amount.  Give the dialog box the title Payment, and place the user’s response in the current active cell.  Write the code so this dialog box will repeat while the amount entered in the current cell is greater than 1000. Select the cell that is one cell below the current active cell using relative referencing.

In the line of code Selection.ClearContents, ClearContents is a method.

Type the appropriate code to create an If…Then statement that will close the workbook if the value in the current active cell is Error.  (3.5 points)

User-defined functions should be written in ThisWorkbook in Visual Basic Editor.

What is the purpose of the With…End With code structure?

Visual Basic Editor is embedded in Excel and is used to store and manage all macros created in Excel.

You want to create a function in Excel to allow you to quickly calculate the speed of a sound wave.  The formula used to calculate this is as follows: Speed = Distance / Time In the space provided below, type the lines of code that are needed to create a user-defined function called Speed to calculate this formula.  Assume the distance and time will be entered as numerical values with or without decimals.  (6 points)     

You want to create a private macro that will run when the user opens the workbook.  In the space provided below, type the lines of code needed to create this macro from beginning to end:  (14 points) Select the cell named Turkey using the Name Box Display a dialog box that asks Are you traveling for Thanksgiving?  Give the dialog box the title Travel and include a Yes button and a No button in the dialog box. If the user clicks on the No button, select Cell A1. If the user clicks on the Yes button, display a dialog box that simply says Safe Travels!

Fines are an example of intermediate sanctions. 

What are the two type of deterrence?