Computer Literacy Final Flashcards

(110 cards)

1
Q

You can copy ____ and numbers between Word and Excel.

A

Text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Microsoft Office programs are designed to work together through a process called ____.

A

Integration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Microsoft Office provides ____ integration methods.

A

Three

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

When you want to copy an object without a data connection to the source file, you should use the ____ integration method.

A

Pasting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

If a text value in a Word document is automatically updated after a corresponding text value is updated in an Excel source document, you can determine that the text value in Word is ____ the source document.

A

Linked to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

If a text value in a Word document is automatically updated after a corresponding text value is updated in an Excel source document, you can determine that the text value in Word is ____ the source document.

A

Embed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

If you need to remove all items appearing in the Clipboard task pane, click ____.

A

Clear All

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

When you use the Copy and Paste commands, by default an object copied from one program to another program retains the ____ of the original object.

A

Formatting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Suppose you have placed the following items to the Clipboard in the following order: a photograph, a text value, a column chart, and a table. If the items were copied in the order listed, the ____ would be at the bottom of the list.

A

Photograph

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

In Excel, the Clipboard task pane opens ____ the worksheet window.

A

To the left of

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Microsoft Access can best be described as ____ software

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which is NOT true about Access?

A

Reporting is limited to 20 saved reports

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Tables, queries, and forms are examples of Access ____.

A

Objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which of the following is NOT available to you as you start Access?

A

recalibrating an existing database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which Access object provides an easy-to-use data entry screen?

A

form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which is NOT a feature of Access reports?

A

easy-to-use data entry screen

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Which Access object contains all of the raw data within the database?

A

table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

____ View provides the most options for defining fields.

A

table design

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Which of the following is NOT a data type?

A

Formula

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Which data type stores only one of two values?

A

Yes/No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

SQL stands for ____.

A

Structured Query Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

A query datasheet is sometimes called a ____ of the data.

A

logical view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

A

freeze

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.

A

criteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Query Design View presents the fields you can use for a query in small windows called field ____.
lists
26
Access saves ____ automatically as you move from record to record.
data
27
Use the ____ command to save the current object with a new name.
Save As
28
To move a field in the query design grid, click its ____, and then drag it left or right.
field selector
29
A(n) ____ is a temporary view of the data that is removed when you close the datasheet.
filter
30
The wildcard character that stands for any group of characters is the ____.
asterisk (*)
31
The Form Wizard prompts you for information it needs to create a form, such as the ____ for the form.
All of the above
32
Which of the following is NOT a form view?
Data
33
Which form creation tool can you use to create a form from scratch in Form Design View?
Form Design
34
Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?
Form Wizard
35
Referential integrity prevents the creation of ____ records.
orphan
36
____ records are those on the many side of a relationship that do not have a match on the one side.
orphan
37
____ View lets you make some design changes to a form while you are browsing the data
layout
38
The Align button in the Sizing & Ordering group is available on the ____ tab
Arrange
39
Which control displays a list of possible data entries from which the user can choose?
List Box
40
Which control is used to create a three-dimensional aspect to a form?
tab control
41
Which of the following is NOT a common report embellishment?
command buttons
42
Which report view’s primary purpose is to quickly review the report without page breaks?
Report View
43
Which report view’s primary purpose is to review each page of the entire report as it will appear if printed?
Print Preview
44
Which report view’s primary purpose is to allow you to modify report controls while reviewing live data?
Layout View
45
If a report is too wide, you will see a green error indicator in the ____ corner of the report.
upper-left
46
For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal ____.
ruler
47
The Page Header section prints ____.
at the top of every page (but below the Report Header on the first page)
48
The Page Footer section prints ____.
at the bottom of every page
49
Which command can you use to move a control from one section to another on a report?
Cut
50
Which command is used to copy a control from one report section to another?
Copy
51
In Microsoft Office 2013, the program that is used to make calculations with data is ____.
Excel
52
By integrating information created in Word, Excel, and Access, the information ____.
works together
53
You can enter data into an Access ____.
database
54
You use the ____ command in Access to import data from an outside source.
Get External Data
55
You can import data into Access from ____.
another Access database
56
During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.
data types
57
You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.
current
58
Excel contains ____ tools not available in Access.
calculation
59
You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.
append
60
A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.
data
61
Which of the following items can you import into a presentation?
All of the above
62
A presentation with a clear message that reads like a ____ and is illustrated with appropriate visual aids will have the greatest impact on your audience.
story
63
Which of the following is an exception to copyright protection?
fair use
64
The default view that PowerPoint opens in is called ____ view.
Normal
65
The ____ organizes all of PowerPoint’s primary commands.
Ribbon
66
On the Ribbon, each set of primary commands is identified by a(n) ____.
tab
67
The Zoom slider is located on the ____.
status bar
68
After you enter text in a placeholder, the placeholder becomes a text ____.
object
69
The blinking vertical line that indicates where your text will appear when you type is called the ____.
insertion point
70
When you are typing in a text placeholder, which feature decreases the font size in order to fit the text in the placeholder?
AutoFit Options button
71
Which key do you press to create a new bullet?
Enter
72
Other than the Slide pane, where can you enter slide text?
Outline view
73
The ____ toolbar is convenient to use for formatting text when the HOME tab is closed.
Mini
74
The Font Color gallery includes Theme Colors and the ____ Colors.
Standard
75
To select an unselected text object, press [____], click the text object, and then release [____].
Shift
76
As you move the pointer over font names in the font list, the text on the slide displays a ____ of the different font choices.
Live Preview
77
The Font Color button is on the ____ tab.
Home
78
A SmartArt graphic consists of two parts: the SmartArt graphic itself and a(n) ____ pane.
Text
79
The Convert to SmartArt Graphic button is in the ____ group.
Paragraph
80
The Align commands are in the ____ group.
Arrange
81
The ____ button resets slide placeholders to their default position, size, and text formatting.
Reset
82
In PowerPoint, you can insert documents saved in all of the following formats EXCEPT ____.
.dot
83
Although your e-mail program allows you to attach files, you can send a presentation using Outlook from within PowerPoint. Click the FILE tab, click Share, click E-mail in the center pane, then click Send as ____.
Attachment
84
All of the following are graphics file formats EXCEPT ____.
HTML
85
Right-click a slide in the Thumbnails pane and then click ____ to create an exact copy of a slide.
Duplicate Slide
86
PowerPoint uses ____ to create numerical charts.
Excel
87
Cells in the first or top row of a chart are ____ names and provide further information about the data
legend
88
Every chart has a corresponding ____ that contains the numerical data displayed by the chart.
worksheet
89
When you insert a slide from another presentation, the new slide has the design style and formatting of the ____ presentation.
destination
90
To copy noncontiguous slides, open Slide Sorter view, click the first slide thumbnail, press and hold ____, click each additional slide thumbnail, release the key, and then click the Copy button.
[Ctrl]
91
To open the Insert Picture dialog box, click the ____ tab on the Ribbon and then click the Pictures button in the Images group.
Insert
92
All of the following are placeholders you can add EXCEPT ____.
background
93
In Presenter view, the next slide in the presentation appears in the ____ corner of the screen.
upper-right
94
____ view is a special view that you typically use when showing a presentation through two monitors.
Presenter
95
When ____ is selected under Advance Slide in the Timing group, you have to click to manually advance slides during a slide show
On Mouse Click
96
Entrance and Exit are ____.
animation categories
97
Animation tags identify the ____ in which objects are animated during slide show.
order
98
Document properties include ____.
Both B and C
99
Use ____ colors for slide background and text to make the text readable.
contrasting
100
As a general rule, use no more than ____ fonts in a presentation and vary the font size
two
101
If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object’s source file
Link
102
You can use [ ____ ][Tab] to promote headings in Outline view.
Shift
103
Which of the following indicates the number of slides contained in a presentation?
Status Bar
104
You use linking when you want the linked information in the destination file to update when you change the ____ file.
source
105
You can use source program tools to edit a(n) ____ object within a destination file.
embedded
106
To embed an object in a PowerPoint presentation, you use the ____ command in the Text group on the INSERT tab.
Object
107
A(n) ____ object in a PowerPoint file becomes a part of the PowerPoint file.
embedded
108
To edit an embedded object, you ____ it.
double-click
109
When you ____ an object to a PowerPoint slide, the object is still stored in the source file in the source program.
link
110
When you import slides into PowerPoint, you need to reset the ____ of the slides to conform to the PowerPoint slide design you have applied.
layout