Module Eight: Review Questions

1. What type of form is best if you have column headings that can work as field labels?
   1. Worksheet with Form Controls
   2. VBA UserForms
   3. Data Forms
   4. None of the above
2. What are five different types of form controls?
3. Which type of control allows you to display a list of one or more items available as a choice?
   1. List box
   2. Option
   3. Check box
   4. None of the above
4. All ActiveX controls require VBA code.
   1. True
   2. False
5. What command do you use to convert a worksheet of data to a form?
6. What key allows you to move from field to field while in a data form?
   1. TAB
   2. ENTER

7. Match each type of wildcard in a data form search to the search it performs.

   1. ?

8. Allows you to find wildcard characters

9. Replaces a single character

10. Replaces any number of characters

    1. *
    2. ~

11. You can insert form controls without showing the Developer tab first.

    1. True
    2. False
12. What does the Input range field do on the Format Control dialog box?