iCheck™ Series Microsoft® Office 2010

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
An 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/007661395x/903632/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"> (58.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 different 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 ____ in the Form Design Design Tools contextual tab.
A)Design>Tools>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/007661395x/903632/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"> (166.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.