1. What's one difference you've noticed between MATLAB and VBA syntax? What is one similarity?
2. You need to change a series of non-adjacent cells so that they have a new font. Which of the following would work best?
-
a) Recorded Macro
-
b) User defined function
-
c) User written macro
3. You want to select a range of cells and convert the temperatures they store from Celsius to Kelvin. Which of the following would work best?
-
a) Recorded Macro
-
b) User defined function
-
c) User written macro
4. You want to find the sum of the square roots of a range of cells. Which of the following would work best?
-
a) Recorded Macro
-
b) User defined function
-
c) User written macro
5. What is the difference between pass-by-reference and pass-by-value?
a) They are the same.
b) Pass-by-value passes the cell address, pass-by-reference passes the value in the cell.
c) Pass-by-value passes the value stored in the cell, pass-by-reference passes the cell address.
6. Which does VBA use by default?
a) Pass-by-reference.
b) Pass-by-value.
c) The parameter types are the same, there is no default.