A company is considering a project that would require an investment of $343,000 and would last for 8 years. The incremental annual revenues and expenses generated by the project during those 8 years would be as follows: Sales $ 227,000 Variable expenses 52,000 Contribution margin 175,000 Fixed expenses:   Salaries 27,000 Rents 41,000 Depreciation 40,000 Total fixed expenses 108,000 Net operating income $ 67,000 The scrap value of the project’s assets at the end of the project would be $23,000. The cash inflows occur evenly throughout the year. The payback period of the project is closest to:

Type the appropriate code to create an If…Then statement that will display a simple message box with the message prompt Time to Reorder if the value in Cell H7 is less than 5.  (3.5 points)

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)

The Project Explorer Window is displayed on the right side of Visual Basic Editor.

You should define a variable when creating an Input Box to store the user’s response.

Type the appropriate line of code to move from Cell D3 to Cell C6 using relative referencing.  (2 points)

What is the purpose of assigning a button to a macro?

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

What are the two type of deterrence? 

The criminal justice system is cooperative process where the two parties work together to find the truth.