Computer Literacy Final Flashcards

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
Q

Query Design View presents the fields you can use for a query in small windows called field ____.

A

lists

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

Access saves ____ automatically as you move from record to record.

A

data

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

Use the ____ command to save the current object with a new name.

A

Save As

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

To move a field in the query design grid, click its ____, and then drag it left or right.

A

field selector

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

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

A

filter

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

The wildcard character that stands for any group of characters is the ____.

A

asterisk (*)

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

The Form Wizard prompts you for information it needs to create a form, such as the ____ for the form.

A

All of the above

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

Which of the following is NOT a form view?

A

Data

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

Which form creation tool can you use to create a form from scratch in Form Design View?

A

Form Design

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

Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?

A

Form Wizard

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

Referential integrity prevents the creation of ____ records.

A

orphan

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

____ records are those on the many side of a relationship that do not have a match on the one side.

A

orphan

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

____ View lets you make some design changes to a form while you are browsing the data

A

layout

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

The Align button in the Sizing & Ordering group is available on the ____ tab

A

Arrange

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

Which control displays a list of possible data entries from which the user can choose?

A

List Box

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

Which control is used to create a three-dimensional aspect to a form?

A

tab control

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

Which of the following is NOT a common report embellishment?

A

command buttons

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

Which report view’s primary purpose is to quickly review the report without page breaks?

A

Report View

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

Which report view’s primary purpose is to review each page of the entire report as it will appear if printed?

A

Print Preview

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

Which report view’s primary purpose is to allow you to modify report controls while reviewing live data?

A

Layout View

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

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

A

upper-left

46
Q

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 ____.

A

ruler

47
Q

The Page Header section prints ____.

A

at the top of every page (but below the Report Header on the first page)

48
Q

The Page Footer section prints ____.

A

at the bottom of every page

49
Q

Which command can you use to move a control from one section to another on a report?

A

Cut

50
Q

Which command is used to copy a control from one report section to another?

A

Copy

51
Q

In Microsoft Office 2013, the program that is used to make calculations with data is ____.

A

Excel

52
Q

By integrating information created in Word, Excel, and Access, the information ____.

A

works together

53
Q

You can enter data into an Access ____.

A

database

54
Q

You use the ____ command in Access to import data from an outside source.

A

Get External Data

55
Q

You can import data into Access from ____.

A

another Access database

56
Q

During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.

A

data types

57
Q

You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.

A

current

58
Q

Excel contains ____ tools not available in Access.

A

calculation

59
Q

You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.

A

append

60
Q

A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.

A

data

61
Q

Which of the following items can you import into a presentation?

A

All of the above

62
Q

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.

A

story

63
Q

Which of the following is an exception to copyright protection?

A

fair use

64
Q

The default view that PowerPoint opens in is called ____ view.

A

Normal

65
Q

The ____ organizes all of PowerPoint’s primary commands.

A

Ribbon

66
Q

On the Ribbon, each set of primary commands is identified by a(n) ____.

A

tab

67
Q

The Zoom slider is located on the ____.

A

status bar

68
Q

After you enter text in a placeholder, the placeholder becomes a text ____.

A

object

69
Q

The blinking vertical line that indicates where your text will appear when you type is called the ____.

A

insertion point

70
Q

When you are typing in a text placeholder, which feature decreases the font size in order to fit the text in the placeholder?

A

AutoFit Options button

71
Q

Which key do you press to create a new bullet?

A

Enter

72
Q

Other than the Slide pane, where can you enter slide text?

A

Outline view

73
Q

The ____ toolbar is convenient to use for formatting text when the HOME tab is closed.

A

Mini

74
Q

The Font Color gallery includes Theme Colors and the ____ Colors.

A

Standard

75
Q

To select an unselected text object, press [____], click the text object, and then release [____].

A

Shift

76
Q

As you move the pointer over font names in the font list, the text on the slide displays a ____ of the different font choices.

A

Live Preview

77
Q

The Font Color button is on the ____ tab.

A

Home

78
Q

A SmartArt graphic consists of two parts: the SmartArt graphic itself and a(n) ____ pane.

A

Text

79
Q

The Convert to SmartArt Graphic button is in the ____ group.

A

Paragraph

80
Q

The Align commands are in the ____ group.

A

Arrange

81
Q

The ____ button resets slide placeholders to their default position, size, and text formatting.

A

Reset

82
Q

In PowerPoint, you can insert documents saved in all of the following formats EXCEPT ____.

A

.dot

83
Q

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 ____.

A

Attachment

84
Q

All of the following are graphics file formats EXCEPT ____.

A

HTML

85
Q

Right-click a slide in the Thumbnails pane and then click ____ to create an exact copy of a slide.

A

Duplicate Slide

86
Q

PowerPoint uses ____ to create numerical charts.

A

Excel

87
Q

Cells in the first or top row of a chart are ____ names and provide further information about the data

A

legend

88
Q

Every chart has a corresponding ____ that contains the numerical data displayed by the chart.

A

worksheet

89
Q

When you insert a slide from another presentation, the new slide has the design style and formatting of the ____ presentation.

A

destination

90
Q

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.

A

[Ctrl]

91
Q

To open the Insert Picture dialog box, click the ____ tab on the Ribbon and then click the Pictures button in the Images group.

A

Insert

92
Q

All of the following are placeholders you can add EXCEPT ____.

A

background

93
Q

In Presenter view, the next slide in the presentation appears in the ____ corner of the screen.

A

upper-right

94
Q

____ view is a special view that you typically use when showing a presentation through two monitors.

A

Presenter

95
Q

When ____ is selected under Advance Slide in the Timing group, you have to click to manually advance slides during a slide show

A

On Mouse Click

96
Q

Entrance and Exit are ____.

A

animation categories

97
Q

Animation tags identify the ____ in which objects are animated during slide show.

A

order

98
Q

Document properties include ____.

A

Both B and C

99
Q

Use ____ colors for slide background and text to make the text readable.

A

contrasting

100
Q

As a general rule, use no more than ____ fonts in a presentation and vary the font size

A

two

101
Q

If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object’s source file

A

Link

102
Q

You can use [ ____ ][Tab] to promote headings in Outline view.

A

Shift

103
Q

Which of the following indicates the number of slides contained in a presentation?

A

Status Bar

104
Q

You use linking when you want the linked information in the destination file to update when you change the ____ file.

A

source

105
Q

You can use source program tools to edit a(n) ____ object within a destination file.

A

embedded

106
Q

To embed an object in a PowerPoint presentation, you use the ____ command in the Text group on the INSERT tab.

A

Object

107
Q

A(n) ____ object in a PowerPoint file becomes a part of the PowerPoint file.

A

embedded

108
Q

To edit an embedded object, you ____ it.

A

double-click

109
Q

When you ____ an object to a PowerPoint slide, the object is still stored in the source file in the source program.

A

link

110
Q

When you import slides into PowerPoint, you need to reset the ____ of the slides to conform to the PowerPoint slide design you have applied.

A

layout