Computer Literacy Final Flashcards
You can copy ____ and numbers between Word and Excel.
Text
Microsoft Office programs are designed to work together through a process called ____.
Integration
Microsoft Office provides ____ integration methods.
Three
When you want to copy an object without a data connection to the source file, you should use the ____ integration method.
Pasting
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.
Linked to
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.
Embed
If you need to remove all items appearing in the Clipboard task pane, click ____.
Clear All
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.
Formatting
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.
Photograph
In Excel, the Clipboard task pane opens ____ the worksheet window.
To the left of
Microsoft Access can best be described as ____ software
Database
Which is NOT true about Access?
Reporting is limited to 20 saved reports
Tables, queries, and forms are examples of Access ____.
Objects
Which of the following is NOT available to you as you start Access?
recalibrating an existing database
Which Access object provides an easy-to-use data entry screen?
form
Which is NOT a feature of Access reports?
easy-to-use data entry screen
Which Access object contains all of the raw data within the database?
table
____ View provides the most options for defining fields.
table design
Which of the following is NOT a data type?
Formula
Which data type stores only one of two values?
Yes/No
SQL stands for ____.
Structured Query Language
A query datasheet is sometimes called a ____ of the data.
logical view
In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.
freeze
You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.
criteria
Query Design View presents the fields you can use for a query in small windows called field ____.
lists
Access saves ____ automatically as you move from record to record.
data
Use the ____ command to save the current object with a new name.
Save As
To move a field in the query design grid, click its ____, and then drag it left or right.
field selector
A(n) ____ is a temporary view of the data that is removed when you close the datasheet.
filter
The wildcard character that stands for any group of characters is the ____.
asterisk (*)
The Form Wizard prompts you for information it needs to create a form, such as the ____ for the form.
All of the above
Which of the following is NOT a form view?
Data
Which form creation tool can you use to create a form from scratch in Form Design View?
Form Design
Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?
Form Wizard
Referential integrity prevents the creation of ____ records.
orphan
____ records are those on the many side of a relationship that do not have a match on the one side.
orphan
____ View lets you make some design changes to a form while you are browsing the data
layout
The Align button in the Sizing & Ordering group is available on the ____ tab
Arrange
Which control displays a list of possible data entries from which the user can choose?
List Box
Which control is used to create a three-dimensional aspect to a form?
tab control
Which of the following is NOT a common report embellishment?
command buttons
Which report view’s primary purpose is to quickly review the report without page breaks?
Report View
Which report view’s primary purpose is to review each page of the entire report as it will appear if printed?
Print Preview
Which report view’s primary purpose is to allow you to modify report controls while reviewing live data?
Layout View
If a report is too wide, you will see a green error indicator in the ____ corner of the report.
upper-left
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
The Page Header section prints ____.
at the top of every page (but below the Report Header on the first page)
The Page Footer section prints ____.
at the bottom of every page
Which command can you use to move a control from one section to another on a report?
Cut
Which command is used to copy a control from one report section to another?
Copy
In Microsoft Office 2013, the program that is used to make calculations with data is ____.
Excel
By integrating information created in Word, Excel, and Access, the information ____.
works together
You can enter data into an Access ____.
database
You use the ____ command in Access to import data from an outside source.
Get External Data
You can import data into Access from ____.
another Access database
During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.
data types
You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.
current
Excel contains ____ tools not available in Access.
calculation
You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.
append
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
Which of the following items can you import into a presentation?
All of the above
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
Which of the following is an exception to copyright protection?
fair use
The default view that PowerPoint opens in is called ____ view.
Normal
The ____ organizes all of PowerPoint’s primary commands.
Ribbon
On the Ribbon, each set of primary commands is identified by a(n) ____.
tab
The Zoom slider is located on the ____.
status bar
After you enter text in a placeholder, the placeholder becomes a text ____.
object
The blinking vertical line that indicates where your text will appear when you type is called the ____.
insertion point
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
Which key do you press to create a new bullet?
Enter
Other than the Slide pane, where can you enter slide text?
Outline view
The ____ toolbar is convenient to use for formatting text when the HOME tab is closed.
Mini
The Font Color gallery includes Theme Colors and the ____ Colors.
Standard
To select an unselected text object, press [____], click the text object, and then release [____].
Shift
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
The Font Color button is on the ____ tab.
Home
A SmartArt graphic consists of two parts: the SmartArt graphic itself and a(n) ____ pane.
Text
The Convert to SmartArt Graphic button is in the ____ group.
Paragraph
The Align commands are in the ____ group.
Arrange
The ____ button resets slide placeholders to their default position, size, and text formatting.
Reset
In PowerPoint, you can insert documents saved in all of the following formats EXCEPT ____.
.dot
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
All of the following are graphics file formats EXCEPT ____.
HTML
Right-click a slide in the Thumbnails pane and then click ____ to create an exact copy of a slide.
Duplicate Slide
PowerPoint uses ____ to create numerical charts.
Excel
Cells in the first or top row of a chart are ____ names and provide further information about the data
legend
Every chart has a corresponding ____ that contains the numerical data displayed by the chart.
worksheet
When you insert a slide from another presentation, the new slide has the design style and formatting of the ____ presentation.
destination
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]
To open the Insert Picture dialog box, click the ____ tab on the Ribbon and then click the Pictures button in the Images group.
Insert
All of the following are placeholders you can add EXCEPT ____.
background
In Presenter view, the next slide in the presentation appears in the ____ corner of the screen.
upper-right
____ view is a special view that you typically use when showing a presentation through two monitors.
Presenter
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
Entrance and Exit are ____.
animation categories
Animation tags identify the ____ in which objects are animated during slide show.
order
Document properties include ____.
Both B and C
Use ____ colors for slide background and text to make the text readable.
contrasting
As a general rule, use no more than ____ fonts in a presentation and vary the font size
two
If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object’s source file
Link
You can use [ ____ ][Tab] to promote headings in Outline view.
Shift
Which of the following indicates the number of slides contained in a presentation?
Status Bar
You use linking when you want the linked information in the destination file to update when you change the ____ file.
source
You can use source program tools to edit a(n) ____ object within a destination file.
embedded
To embed an object in a PowerPoint presentation, you use the ____ command in the Text group on the INSERT tab.
Object
A(n) ____ object in a PowerPoint file becomes a part of the PowerPoint file.
embedded
To edit an embedded object, you ____ it.
double-click
When you ____ an object to a PowerPoint slide, the object is still stored in the source file in the source program.
link
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