Page 162 - Excel Progamming Weekend Crash Course

i540629 PR02.qxd 9/2/03 9:34 AM Page 137

PA
PA R T
R
T

# II

Saturday Morning

Part Review

1. What does the expression 11 mod 3 evaluate to?
2. If A is True and B is False, what does the expression A Or B evaluate to?
3. Does the comparison expression “Smith”=”smith” evaluate to True or False?
4. Suppose that Obj1 and Obj2 are both object references. How can you determine if
they reference the same object?
5. Do the expressions 4 + 2 * 8 and (4 + 2) * 8 evaluate the same? Please
explain.
6. Will some VBA statements within an If...End If block always be executed?
7. When can you omit the Else part of a Select Case statement?
8. What does the Iif function do?
9. How can you ensure that the statements in a Do...Loop statement will be executed
at least once?
10. When should you use the While...Wend statement?
11. How many Exit For statements can you put in a For...Next loop?
12. How does a function procedure differ from a sub procedure?
13. What’s the limit on the number of lines of code in a procedure?
14. How do you pass an array as an argument to a procedure?
15. How do you specify the value to be returned by a function?
16. Can a local variable in a procedure “remember” its value between calls to the
procedure? If so, how?
17. VBA can recognize dates in common formats such as 12/25/2003. In VBA code,
how do you indicate that such a value is a date?
18. Which VBA function is used to add an interval to a date?
19. Which two functions are used to search for text (to find one string within
another)?