Suppose you want to write a procedure that takes three numbers, num1, num2, and num3; and returns their sum, product, and average. It is best to use a Function procedure for this task.

Related MCQs

• Suppose a variable is passed by reference to a parameter of a Sub procedure, and the parameter has its value changed inside the Sub procedure. What will the value of the variable be after the Sub procedure has executed?
• Suppose a variable is passed by value to a parameter of a Sub procedure, and the parameter has its value changed inside the Sub procedure. What will the value of the variable be after the Sub procedure has executed?
• The ______________ of a Sub procedure are vehicles for passing numbers and strings to the Sub procedure.
• What happens to a variable declared locally inside a Sub procedure after the procedure terminates?
• Both the input and output of a Function procedure can consist of several values.
• Variables appearing in the header of a Function procedure are called ____________.
• Suppose that the selector in a Select Case block is the string variable myVar. Which of the following is NOT a valid Case clause?
• Suppose the variable myName is declared in a Dim statement in two different Sub procedures. Which statement is true?
• Function procedures can invoke other Function procedures.
• Option Explicit requires you to declare every variable before its use.