iCheck™ Series Microsoft® Office 2007 Real World Applications

Lesson 3: Enter and Organize Data

Self Checks

Self Checks provide you with multiple choice questions you can use to review the main ideas of the lesson.

1
A good way to enter records into a large table is to use a ____.
A)report
B)form
C)query
D)filter
2
This Find command ____.
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/574827/U3L3Q2.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (54.0K)</a>
A)will only find the word "bread" if it is in lowercase letters
B)will delete any occurrences of the word "bread"
C)specifies that the field cannot contain any numbers
D)can use a wildcard character to search for sidfferent forms of the same word
3
Which of the following creates a simple form?
A)Create>Tables>Form
B)Create>Forms>Form
C)Home>Records>Form
D)Home>Records>New
4
A split form ____
A)always contains at least one subform
B)must be created using the Form wizard
C)is another name for a multiple item form
D)contains both a datasheet and a form
5
To set the order in which fields on a form will be accessed when the user presses the Tab key, choose ____.
A)Arrange>Control>Layout>Tab Order
B)Arrange>Control>Layout>Snap to Grid
C)Create>Forms>Tabs
D)Create>Forms>Multiple Items
6
Identify an example of a control on this screen.
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/574827/U3L3Q6.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (182.0K)</a>
A)A
B)B
C)C
D)D
7
In order to align the controls on a form, you must be in ____ View.
A)Form
B)Layout
C)Design
D)Datasheet
8
A business document that presents a company's yearly financial information with summary information such as quarterly totals is an example of a ____.
A)form
B)report
C)datasheet
D)subform
9
Which command lets you organize a report first by purchaser and then alphabetically by product within each purchaser's group?
A)Format>Controls>Add Existing Fields
B)Format>Grouping & Totals>Totals
C)Format>Grouping & Totals>Group & Sort
D)Home>Sort & Filter>Advanced
10
Identify the item that is NOT an example of an aggregate function.
A)Count
B)Min
C)Avg
D)PMT
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe

Please read our Terms of Use and Privacy Notice before you explore our Web site. To report a technical problem with this Web site, please contact the Web Producer.