Page 163 - Excel Progamming Weekend Crash Course
P. 163
i540629 PR02.qxd 9/2/03 9:34 AM Page 138
138 Part II — Saturday Morning
20. How do you convert a string so that the first letter of each word is uppercase and
all other letters are lowercase?
21. Do the characters “A” and “a” have the same ASCII values?
22. How would you extract a certain number of characters from the start of a string?
23. Which Excel object do you use to refer to a block of worksheet cells in a VBA
program?
24. Suppose a range references a single worksheet cell. How can you tell if that cell is
empty?
25. What does the Worksheet object’s UsedRange property reference?
26. How do you add a comment to a cell?
27. How many Selection objects can a worksheet have?
28. How do the Range.Activate and Range.Select methods differ?
