Page 290 - Excel Progamming Weekend Crash Course

o540629 PR04.qxd 9/2/03 9:35 AM Page 265

PA
PA R T
R
T

# IV

Saturday Evening

Part Review

1. What’s the main difference between an embedded chart and a chart sheet?
2. How do you control the size and position of a chart sheet?
3. How do you add a new chart sheet to a workbook?
4. How do you specify the data to be plotted in a chart?
5. Suppose that Ch references a chart. How would you italicize the chart’s title?
6. Your workbook contains a chart sheet named “Sales Summary.” What VBA state-
ment would print this chart to the default printer?
7. How would you prevent a chart from being modified by the user?
8. Suppose a worksheet contains several embedded charts that overlap each other.
How would you make sure that a specific chart is not hidden by the others?
9. How is a scatter chart fundamentally different from most other Excel charts?
10. How would you print all chart sheets in a workbook?
11. Suppose you do not want a particular embedded chart to be printed when the
worksheet is printed. How is this accomplished?
12. What are the three components of a user form?
13. How do you specify that a user form is centered on-screen when initially
displayed?
14. How do you close a user form?
15. How do the OptionButton and CheckBox controls differ?
16. How do you create a group of OptionButton controls?
17. Suppose you are editing the visual interface of a user form. What’s the quickest
way to display the code for a control’s default event?
18. You want the user to be able to select a command button by pressing Enter. How is
this done?