To Purchase
this Complete Test Bank with Answers Click the link Below
https://tbzuiqe.com/product/enhanced-computer-concepts-and-microsoft-office-2013-illustrated-1st-edition-by-by-june-jamrich-parsons-test-bank/
If face any problem or
Further information contact us At tbzuiqe@gmail.com
Sample Test
|
Access_2013_Unit_C_Using_Forms
1. Forms can be used to enter and edit data.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 54
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.042 – Describe form terminology and
views
|
|
|
2. A form allows you
to arrange the fields of a record in any layout so a database user can
quickly and easily find, enter, edit, and analyze data.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 54
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.042 – Describe form terminology and
views
|
|
|
3. Each item on a form
is called a control.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 54
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.042 – Describe form terminology and
views
|
|
|
4. In the accompanying
figure, the first tool in the list creates a form from scratch in Form Design
View.
|
ANSWER:
|
False
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.043 – Create a split form
|
|
|
5. If you want to
apply the same formatting enhancement to multiple controls, select them at
the same time to make the same change to both.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 58
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.044 – Format controls in Layout View
|
|
|
6. You can add fields
to a form in either Layout View or Design View.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 60
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.045 – Add fields to a form
|
|
|
7. Deleting a field
from a form does not delete it from the underlying table or have any effect
on the data contained in the field.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 60
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.045 – Add fields to a form
|
|
|
8. Bound controls
exist only to describe or enhance the appearance of the form.
|
ANSWER:
|
False
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 61
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.046 – Define bound and unbound
controls
|
|
|
9. A tab control is an
unbound control.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 61
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.046 – Define bound and unbound
controls
|
|
|
10. On a form, text
box controls display data from an underlying record source.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 63
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
11. You can press an
arrow key to move a selected control.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 64
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.048 – Move controls on a form
|
|
|
12. It would make
sense to set the Tab Stop property of a text box that will not be used for
data entry to No.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 66
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.049 – Modify tab order properties
|
|
|
13. The Spacing
feature represents the space between controls.
|
ANSWER:
|
False
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 67
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.049 – Modify tab order properties
|
|
|
14. A background image
is an image that fills the entire form or report, appearing “behind” the
other controls.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 69
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.050 – Insert an image on a form
|
|
|
15. The Form Wizard
prompts you for information it needs to create a form, such as the ____ for
the form.
|
|
a.
|
fields
|
b.
|
title
|
|
|
c.
|
layout
|
d.
|
All of the above.
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 54
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.051 – Create a form with the Form
Wizard
|
|
|
16. Which of the
following is NOT a form view?
|
|
a.
|
Data
|
b.
|
Form
|
|
|
c.
|
Layout
|
d.
|
Design
|
|
ANSWER:
|
a
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 55
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.042 – Describe form terminology and
views
|
|
|
17. Which form
creation tool can you use to create a form from scratch in Form Design View?
|
|
a.
|
Form
|
b.
|
Blank Form
|
|
|
c.
|
Form Design
|
d.
|
Form Wizard
|
|
ANSWER:
|
c
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.052 – Enter and edit data in a form
|
|
|
18. Which form
creation tool can you use to create a form by answering a series of questions
provided by dialog boxes?
|
|
a.
|
Form Wizard
|
b.
|
More Forms
|
|
|
c.
|
Split Form
|
d.
|
Navigation
|
|
ANSWER:
|
a
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.052 – Enter and edit data in a form
|
|
|
19. Which form
creation tool can you use to build a form based on Multiple Items, Datasheet,
or Split Form, for example?
|
|
a.
|
Form Design
|
b.
|
Blank Form
|
|
|
c.
|
More Forms
|
d.
|
Form Wizard
|
|
ANSWER:
|
c
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.043 – Create a split form
|
|
|
20. In the
accompanying figure, the ____ tool will create a form with one click, based
on the selected table or query.
|
|
a.
|
first
|
b.
|
second
|
|
|
c.
|
third
|
d.
|
fifth
|
|
ANSWER:
|
a
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.052 – Enter and edit data in a form
|
|
|
21. In the
accompanying figure, the ____ tool will create a form from scratch in Form
Layout View.
|
|
a.
|
first
|
b.
|
second
|
|
|
c.
|
third
|
d.
|
fourth
|
|
ANSWER:
|
c
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.052 – Enter and edit data in a form
|
|
|
22. In the
accompanying figure, the ____ tool will allow you to create a form by
answering a series of questions provided by the Form Wizard dialog boxes.
|
|
a.
|
second
|
b.
|
third
|
|
|
c.
|
fourth
|
d.
|
fifth
|
|
ANSWER:
|
c
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.052 – Enter and edit data in a form
|
|
|
23. In the accompanying
figure, the ____ tool is used to navigate or move between different areas of
the database.
|
|
a.
|
first
|
b.
|
second
|
|
|
c.
|
third
|
d.
|
fifth
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.052 – Enter and edit data in a form
|
|
|
24. Referential
integrity prevents the creation of ____ records.
|
|
a.
|
indexed
|
b.
|
split
|
|
|
c.
|
unlicensed
|
d.
|
orphan
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.052 – Enter and edit data in a form
|
|
|
25. ____ records are
those on the many side of a relationship that do not have a match on the one
side.
|
|
a.
|
indexed
|
b.
|
split
|
|
|
c.
|
unlicensed
|
d.
|
orphan
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.052 – Enter and edit data in a form
|
|
|
26. ____ View lets you
make some design changes to a form while you are browsing the data.
|
|
a.
|
Layout
|
b.
|
Design
|
|
|
c.
|
Browse
|
d.
|
Data
|
|
ANSWER:
|
a
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 58
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.053 – Resize controls in Layout View
|
|
|
27. The Align button
in the Sizing & Ordering group is available on the ____ tab.
|
|
a.
|
ARRANGE
|
b.
|
OPTIONS
|
|
|
c.
|
HOME
|
d.
|
FORMAT
|
|
ANSWER:
|
a
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 60
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.054 – Align controls
|
|
|
28. Which of the
following is NOT a bound control?
|
|
a.
|
Text box
|
b.
|
Combo box
|
|
|
c.
|
List box
|
d.
|
Label
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 61
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.046 – Define bound and unbound
controls
|
|
|
29. Which control
displays a list of possible data entries from which the user can choose?
|
|
a.
|
Label
|
b.
|
Text box
|
|
|
c.
|
List box
|
d.
|
Tab control
|
|
ANSWER:
|
c
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 63
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
30. Which control is
used to create a three-dimensional aspect to a form?
|
|
a.
|
Command button
|
b.
|
Toggle button
|
|
|
c.
|
Rectangle control
|
d.
|
Tab control
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 63
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
31. Which control
provides an easy way to initiate a command or run a macro?
|
|
a.
|
Check box
|
b.
|
Toggle button
|
|
|
c.
|
Command button
|
d.
|
Image control
|
|
ANSWER:
|
c
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 63
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
32. Which control is
both a list box and a text box control?
|
|
a.
|
Bound image control
|
b.
|
Unbound image control
|
|
|
c.
|
Combo box
|
d.
|
Option group
|
|
ANSWER:
|
c
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 63
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
33. Which of the
following would most likely be used to display a Yes/No field on a form?
|
|
a.
|
Check box
|
b.
|
Command button
|
|
|
c.
|
Combo box
|
d.
|
Label
|
|
ANSWER:
|
a
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 63
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
34. Which control,
when it appears pressed, displays “yes” information?
|
|
a.
|
Bound image control
|
b.
|
Combo box
|
|
|
c.
|
Tab control
|
d.
|
Toggle button
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 63
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
35. Which control is
used to provide consistent descriptive text as you navigate from record to
record?
|
|
a.
|
Text box
|
b.
|
Combo box
|
|
|
c.
|
List box
|
d.
|
Label
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 63
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
36. Expressions must
start with what character?
|
|
a.
|
[ left square bracket
|
b.
|
= equal sign
|
|
|
c.
|
( left parenthesis
|
d.
|
: colon
|
|
ANSWER:
|
b
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 64
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.055 – Build calculations on a form
|
|
|
37. When referencing
field names within an expression, surround the field name with ____.
|
|
a.
|
[square brackets]
|
b.
|
{curly brackets}
|
|
|
c.
|
(parentheses)
|
d.
|
“quotation marks”
|
|
ANSWER:
|
a
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 64
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.055 – Build calculations on a form
|
|
|
38. ____ refers to the
space between the outer edge of the control and the data displayed inside the
control.
|
|
a.
|
Spacing
|
b.
|
Reference
|
|
|
c.
|
Padding
|
d.
|
Margin
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 67
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.049 – Modify tab order properties
|
|
|
39. You can press ____
to move the focus through the controls of the form.
|
|
a.
|
[Page Down]
|
b.
|
[Tab]
|
|
|
c.
|
[F5]
|
d.
|
[F12]
|
|
ANSWER:
|
b
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 66
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.049 – Modify tab order properties
|
|
|
40. When an image or
control is selected in Design View, you can use ____, which are small squares
at the corners of the selection box, to resize the image.
|
|
a.
|
label indices
|
b.
|
sizing handles
|
|
|
c.
|
combo boxes
|
d.
|
command squares
|
|
ANSWER:
|
b
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 68
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.050 – Insert an image on a form
|
|
|
41. Controls placed in
the ____ form section print only once at the top of the printout.
|
|
a.
|
Form Header
|
b.
|
Detail
|
|
|
c.
|
Form First
|
d.
|
Form Top
|
|
ANSWER:
|
a
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 68
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.056 – Modify form sections
|
|
|
42. You can insert a
logo on a form using the ____ button in the Controls group.
|
|
a.
|
Graphic Art
|
b.
|
Art
|
|
|
c.
|
Graphic Image
|
d.
|
Insert Image
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 68
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.050 – Insert an image on a form
|
|
|
43. Which of the
following would NOT be considered a graphic image?
|
|
a.
|
Picture
|
b.
|
Logo
|
|
|
c.
|
Text
|
d.
|
Clip art
|
|
ANSWER:
|
c
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 68
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.050 – Insert an image on a form
|
|
|
44. Controls placed in
this form section print once for every record.
|
|
a.
|
Form Records
|
b.
|
Form Header
|
|
|
c.
|
Form Footer
|
d.
|
Detail
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 68
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.057 – Print a selected record
|
|
|
45. ____________________
box controls are used to display as well as enter, edit, find, sort, and
filter data on a form.
|
ANSWER:
|
Text
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 54
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.042 – Describe form terminology and
views
|
|
|
46. On a form,
____________________ View is used to enter, edit, and delete data.
|
ANSWER:
|
Form
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 55
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.042 – Describe form terminology and
views
|
|
|
47. On a form,
____________________ View is used to modify controls and does not display
data.
|
ANSWER:
|
Design
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 55
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.042 – Describe form terminology and
views
|
|
|
48. On a form,
____________________ View can be used to move and modify controls while
viewing live data.
|
ANSWER:
|
Layout
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 55
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.042 – Describe form terminology and
views
|
|
|
49. In a(n)
____________________ form, the upper pane shows the fields of one record
while the lower pane maintains a datasheet view of the first few records.
|
ANSWER:
|
split
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.043 – Create a split form
|
|
|
50. Use the
____________________ Form tool to create a form from scratch in Form Layout
View.
|
ANSWER:
|
Blank
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.043 – Create a split form
|
|
|
51. The
____________________ Sheet of a control is a comprehensive listing of all
characteristics that you can modify for that control.
|
ANSWER:
|
Property
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 62
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
52. The
____________________ List lists the database tables and the fields they
contain.
|
ANSWER:
|
Field
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 60
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.045 – Add fields to a form
|
|
|
53. When you modify
controls, you change their ____________________, or characteristics.
|
ANSWER:
|
properties
property
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 62
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
54. Controls placed in
the Form ____________________ print only once at the end of the last page of
the printout.
|
ANSWER:
|
Footer
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 68
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.057 – Print a selected record
|
|
|
55. Differentiate
between bound and unbound controls.
|
ANSWER:
|
Controls are either bound or unbound. Bound
controls display values from a field such as text boxes and combo boxes.
Unbound controls do not display data; unbound controls describe data or
enhance the appearance of the form. Labels are the most common type of
unbound control, but other types include lines, images, tabs, and command
buttons. Another way to distinguish bound from unbound controls is to
observe the form as you move from record to record. Because bound controls
display data, their contents change as you move through the records,
displaying the entry in the field of the current record. Unbound controls such
as labels and lines do not change as you move through the records in a
form.
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 61
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.046 – Define bound and unbound
controls
|
|
TOPICS:
|
Critical Thinking
|
|
|
56. Discuss the difference
between tab order and tab stop.
|
ANSWER:
|
Tab order is the order the focus moves as you press
[Tab] in Form View.
Tab stop refers to whether you can tab into a control when entering or
editing data; in other words, whether the control can receive the focus.
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 66
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.049 – Modify tab order properties
|
|
TOPICS:
|
Critical Thinking
|
|
|
57. Discuss layout
positioning. Include the following terms in your response: margin, padding,
and anchoring.
|
ANSWER:
|
If the controls on a form are organized in a
layout, you can quickly modify that layout by modifying the margins,
padding, and anchoring options of the layout. Each of these features is
found in the Position group on the ARRANGE tab in Form Design View. Margin
refers to the space between the outer edge of the control and the data
displayed inside the control. Padding is the space between the controls.
Anchoring allows you to tie controls together so you can work with them as
a group.
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 67
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.049 – Modify tab order properties
|
|
TOPICS:
|
Critical Thinking
|
|
|
58. Click in the text
box of the field you want to sort after clicking a sort
button. _________________________
|
ANSWER:
|
False – before
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 54
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.058 – Sort data in a form
|
|
|
59. The lower pane of
a split form displays a(n) datasheet view. _________________________
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 56
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.043 – Create a split form
|
|
|
60. The Size/Space
button is in the Alignment group on the ARRANGE tab. _________________________
|
ANSWER:
|
False – Sizing & Ordering
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 60
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.059 – Resize controls
|
|
|
61. When you add a new
field to a form, two controls are usually created: a(n) caption and
a text box. _________________________
|
ANSWER:
|
False – label
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 60
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.045 – Add fields to a form
|
|
|
62. The connection
between the text box and field is defined by the Control Source
property. _________________________
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 64
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.055 – Build calculations on a form
|
|
|
63. The Navigation tab
on the Property Sheet allows you to change the tab stop or tab order
properties. _________________________
|
ANSWER:
|
False – Other
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 66
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.049 – Modify tab order properties
|
|
|
Case 3-1
You are just starting to create a new form and have begun to realize that
there are a variety of mouse pointer shapes in use. In order to make creating
the form easier, you decide to familiarize yourself with a few of them.
|
|
64. Which of the
following is the default mouse pointer in Layout View?
|
ANSWER:
|
C
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 58
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.053 – Resize controls in Layout View
|
|
TOPICS:
|
Critical Thinking
|
|
|
65. Which of the
following displays when you point to any unselected control on the form?
|
ANSWER:
|
C
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 58
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.053 – Resize controls in Layout View
|
|
TOPICS:
|
Critical Thinking
|
|
|
66. Which of the
following appears when you point to the upper-left corner or edge of a
selected control in Form Design View or the middle of the control in Form
Layout View?
|
ANSWER:
|
A
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 58
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.053 – Resize controls in Layout View
|
|
TOPICS:
|
Critical Thinking
|
|
|
67. Which of the
following appears when you point to one of the sizing handles (except the
large one in the upper-left corner in Form Design View)?
|
a.
|
|
c.
|
|
|
b.
|
|
d.
|
None of the above.
|
|
ANSWER:
|
B
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Access 58
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.053 – Resize controls in Layout View
|
|
TOPICS:
|
Critical Thinking
|
|
|
Match each term below with
the statement that best defines it.
|
a.
|
Command button
|
|
b.
|
Label
|
|
c.
|
Option button
|
|
d.
|
List box
|
|
e.
|
Tab control
|
|
f.
|
Combo box
|
|
g.
|
Toggle button
|
|
h.
|
Line
|
|
REFERENCES:
|
Access 63
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.047 – Modify control properties
|
|
|
68. Displays choices
for a field
|
|
69. Creates a
three-dimensional aspect on a form
|
|
70. Best choice to
display a field such as Veteran that has only two options, Yes or No
|
|
71. Provides
consistent descriptive text as you navigate records
|
|
72. Used to visually
separate information on a form
|
|
73. Used to provide a
list of possible data entries
|
|
75. Used to provide a
list of options for a field plus the ability for the user to enter a new
value
|
|
Excel_2013_Unit_A_Getting_Started_With_Excel_2013
1. In an electronic spreadsheet, you need to manually
recalculate when you change the entries.
|
ANSWER:
|
False
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 2
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.089 – Describe the uses of Excel
|
|
|
2. An Excel 2013
workbook has the file extension .xml.
|
ANSWER:
|
False
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 2
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.089 – Describe the uses of Excel
|
|
|
3. Charts are updated
automatically in Excel whenever data changes.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 2
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.089 – Describe the uses of Excel
|
|
|
4. To open an Excel
file, click Open Other Workbooks on the navigation bar, click Computer, and
then click Browse to open the Open dialog box.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 4
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.090 – Open and save an Excel file
|
|
|
5. You are in Edit
mode any time you are entering or changing the contents of a cell.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 8
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.091 – Build formulas with the AutoSum
button
|
|
|
6. Arguments are
Excel’s built-in formulas.
|
ANSWER:
|
False
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 8
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.091 – Build formulas with the AutoSum
button
|
|
|
7. You use formulas in
Excel to perform calculations such as adding, multiplying, and averaging.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 12
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.092 – Enter a formula
|
|
|
8. A named range can
begin with a letter or number.
|
ANSWER:
|
False
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 12
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.093 – Use cell references to create a
formula
|
|
|
9. You can use a named
range instead of a cell address in a formula.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 12
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.093 – Use cell references to create a
formula
|
|
|
10. You can change
header and footer information using the Margins Design tab that opens on the
Ribbon when a header or footer is active.
|
ANSWER:
|
False
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 14
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.094 – Create a header/footer
|
|
|
11. Printing gridlines
makes data easier to read.
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 16
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.095 – Hide/view gridlines when
printing
|
|
|
12. Excel includes
a(n) Scenario Manager where you can name and save different
what-if versions of your worksheet. ____________________
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 2
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.089 – Describe the uses of Excel
|
|
|
13. Labels are
numbers, formulas, and functions that can be used in calculations. _____________________
|
ANSWER:
|
False – Values
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 8
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.091 – Build formulas with the AutoSum
button
|
|
|
14. Reference operators
compare values for the purpose of true/false results. _____________________
|
ANSWER:
|
False – Comparison
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 12
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.092 – Enter a formula
|
|
|
15. One of the ways to
change your view of the worksheet window is by using the VIEW tab on
the Ribbon. ______________________
|
ANSWER:
|
True
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 14
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.096 – Change worksheet views
|
|
|
16. When the paper
orientation is portrait, the contents will print across the
length of the page instead of across the width. _______________________
|
ANSWER:
|
False – landscape
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 16
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.097 – Change the page orientation
|
|
|
17. An electronic ____
is an application you use to perform numeric calculations and to analyze and
present numeric data.
|
|
a.
|
database
|
b.
|
spreadsheet
|
|
|
c.
|
dataform
|
d.
|
project
|
|
ANSWER:
|
b
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 2
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.089 – Describe the uses of Excel
|
|
|
18. In Excel, the
electronic spreadsheet you work in is called a ____.
|
|
a.
|
tablet
|
b.
|
databook
|
|
|
c.
|
numericsheet
|
d.
|
worksheet
|
|
ANSWER:
|
d
|
|
POINTS:
|
1
|
|
REFERENCES:
|
Excel 2
|
|
LEARNING OBJECTIVES:
|
ENHC.PARS.16.098 – Define key spreadsheet terms
|
|
Comments
Post a Comment