Computers Final Exam

A field name can be up to ___ characters.

64

This task pane is used to assign sound and more advanced animation effects to all objects on a slide and to determine the order in which they are displayed.

Animation

_____ are special effects that add action to text and graphics so they move around on the screen during a slide show.

Animations

This data type allows you to include a file of any type within the field.

Attachment

As you increase or decrease the size of a placeholder, this feature automatically resizes the text within the placeholder.

AutoFit

This data type is a unique, sequential number that is automatically incremented by one whenever a new record is added to a table.

AutoNumber

To black out the screen while viewing a slide show, press this key.

B

This Access feature will automatically adjust the column widths of all selected columns, to accommodate the longest entry or column heading in each of the selected columns.

Best Fit

_____________________ refers to the overall lightness or darkness of a picture.

Brightness

Which of the following is not a Shapes category?

Bullets

Where is copied information stored?

Clipboard

In order to select more than one slide at a time in Slide Sorter view, hold down this key and select.

Ctrl

The keyboard shortcut to apply centered alignment is:

Ctrl+E

The keyboard shortcut to use the Replace feature is:

Ctrl+H

The keyboard shortcut to display the Ballpoint Pen pointer is:

Ctrl+P

The Relationships button is located in which ribbon?

Database Tools

This field property automatically fills in a certain value for this field in new records as you add to a table.

Default Value

Which of the following is NOT a step in creating a new database?

Delegate

You can remove an entire record by selecting the record and pressing this key.

Delete

Themes are accessed using which tab?

Design

Which view does not display the data, but allows you to change the field properties?

Design view

In PowerPoint, this is where your slides are displayed as you create them.

Document window

To add text to a Shape, right-click it and choose:

Edit Text

To quickly open or close the Navigation pane, click:

F11

To add tags and other document properties to your file, use the ____ tab.

File

To customize the print settings, fist click on the _____ tab.

File

To open the Print window, choose:

File/Print

To substitute one word for another in a presentation, you would use the __________ feature.

Find and Replace

You need to replace every instance of the word "company" with the word "corporation." Which PowerPoint feature will you use?

Find and Replace

When you have made a custom change to a slide, like altering the font and font size, what will happen when you apply a new theme?

Fonts will be kept; font sizes will be discarded.

In order to navigate to a specific slide during a slide show, choose this option from the shortcut menu.

Go to Slide

What is the term for a non-text element that can be added to a slide?

Graphic

To print several slides on one page, which of the following printed output types would you select?

Handouts

The New Slide button is located on which tab?

Home

The Paste button is found in the Clipboard group of the _____ tab.

Home

The Slides group has options for inserting a new slide and duplicating an existing slide, this feature is on which tab?

Home

To activate Best Fit from the Ribbon, use what tab?

Home

To add a new blank slide to the presentation, click the New Slides button on the _____ tab.

Home

To change the current slide's layout, use what tab?

Home

Which of the following errors will NOT be corrected by the AutoCorrect feature?

I gave the report to rob.

This is not a pointer option while adding freehand annotations to a slide.

I-beam

Footers are added to the Slide Master using which tab?

Insert

Text boxes can be added using what tab?

Insert

You can access the Footers by using which tab?

Insert

Which of the following is NOT one of the available icons in the content placeholder?

Insert Animation

Graphics can be added to a slide through:

Insert/picture

Which of the following is not one of the transition categories?

Interesting

This controls the manner in which items are arranged on a slide.

Layout

Which of the following is not a subset component of themes?

Layouts

As you select a font from the drop-down menu, a _____ of how the selected font will appear is displayed in the document.

Live Preview

Text that is in excess of 255 characters of alphanumeric data can be entered into this data type.

Long Text

Which of the following is NOT a step in developing a new presentation?

Maintain

In the Find function, search can be made case-sensitive by using the option:

Match Case

Which of the following is an example of a valid field name?

Mission# Accomplished

The _____ along the left edge of the work area displays all the objects in the database and is used to open and manage the objects.

Navigation pane

If you want to work on all aspects of your presentation, switch to _____ view, which displays the Slide pane, Outline pane, and Notes pane.

Normal

_____ is a design technique that identifies and eliminates redundancy by applying a set of rules to your tables to confirm that they are structured properly.

Normalization

This defines the format and placement of the slide image, note text, headers, footers, and other elements that are to appear on all speaker notes.

Notes Master

These pages show a miniature of a slide and the accompanying speaker notes.

Notes pages

The _____ includes space for you to enter notes that apply to the current slide.

Notes pane

You can display each bullet point, text, paragraph, or graphic independently of the other objects on the slide by using this.

Object animations

Adding decorative borders around a graphic, like the metal oval overlay, is accomplished using what feature?

Picture Styles

The tab used to recolor a picture on a slide is:

Picture Tools Format tab

When you insert a graphic, this is automatically displayed.

Picture Tools Format tab

PowerPoint includes many _____, combinations of border, shadow, and shape effects that can be applied in one simple step.

Picture styles

The sample text that suggests the content for the slide is called what?

Placeholder text

To help you remember the important points during a presentation, you can add comments to slides and use ____________________.

Presenter view

Since each Social Security Number is unique per person, it would make a good:

Primary key

What would you choose to view each page of a table displayed in a reduced size in order to check the layout?

Print Preview

This object finds and displays selected data.

Query

All of the information about a person, thing, or place, is contained in this database.

Record

Access databases that contain multiple tables that can be linked to produce combined output from all tables is called a ___________ database.

Relational

The ______ window is used to create and edit relationships.

Relationships

This field property will specify whether or not a value must be entered in a field.

Required

The Spelling Check tool is found under which tab?

Review

The green circle that appears when a shape is selected is called:

Rotate handle

You can enhance the appearance of inserted shapes by applying:

Shape Styles

In PowerPoint, the ready-made drawings of objects such as arrows and hearts are called:

Shapes

Which key should you hold down if you want to maintain proportions while resizing a picture?

Shift

To quickly open the Zoom dialog box for the current field, press:

Shift+F2

The keyboard shortcut to promote a bullet point is:

Shift+Tab

The Shape Height and Shape Width buttons in the _____ group display the current shape's size as you resize.

Size

This defines the format and layout of text and objects on a slide, text and object placeholder sizes, text styles, backgrounds, color themes, effects, and animation.

Slide Master

Moving the mouse while in Slide Show view displays this.

Slide Show toolbar

Which view displays a miniature of each slide to make it easy to reorder slides?

Slide Sorter

You can preview transition effects in this view.

Slide Sorter

_________________ displays a miniature of each slide to make it easy to reorder slides, add special effects such as transitions, and set timing between slides.

Slide Sorter view

In normal view, the large area that displays the current slide is called what?

Slide pane

This displays each slide full screen and in order.

Slide show

Which of the following is not a valid print output?

Slides Only

To move to the next slide in Slide Show, you can press:

Spacebar

This feature locates all misspelled words, duplicate words, and capitalization irregularities as you create and edit a presentation, and proposes possible corrections.

Spell Checker

Which of the following is NOT one of the five area placeholders appearing on the Slide Master?

Summary

In a table, you can move to the next cell by pressing:

Tab

Information in a database is typically stored in this, which consists of vertical columns and horizontal rows.

Table

This object must be created first, before any other types of objects are created, since it is the basic unit of a database.

Table

_____ are combinations of shading colors, borders, and visual effects such as shadows and reflections that can be applied in one simple step.

Table Styles

To insert a new field in Datasheet view, use this tab.

Table Tools Fields

What is the term for a presentation file that contains many predefined settings, which can be used as a pattern to create many similarly outlined presentations?

Template

_____ are predefined set of formatting choices that can be applied to an entire document in one simple step.

Themes

Transitions are accessed under which tab?

Transitions

_____ controls the way that the display changes as you move from one slide to the next during a presentation.

Transitions

What is the quickest method of advancing to a specific slide in Slide Show view?

Type the slide number and then press the Enter key.

You access Slide Master setting under which tab?

View

In Datasheet view, when there is no description for a selected field, Access will display this on the status bar.

View name

This design feature allows use of the most current technology for presenting a slideshow:

Widescreen slides

What is the keyboard shortcut to copy?

[Ctrl]+C

What is the keyboard shortcut to open a file?

[Ctrl]+O

The keyboard shortcut to print is:

[Ctrl]+P

When entering data, you can quickly move to the previous field by pressing:

[Shift]+[Tab]

When entering data into a table, Access indicates the field that is ready to receive data by:

a pink outline.

Which of the following would be appropriate for a field to hold a state abbreviation?

a two character text field

Changing the column width will change the:

amount of data that is displayed

To resize a column, drag the ____ of the column.

boundary line

Records stored inside the database file are sorted in this order.

by primary key field

This is created by the intersection of a row and column, in which you can enter data or other information.

cell

To see how transitions will look when the slide show is running,

click on each slide in the slide sorter view

In Slide Show view, the easiest way to see the next slide is to:

click the mouse button.

When a primary key uses more than one field, it is called what?

composite key

Trimming or removing the vertical or horizontal edges of a picture is called _____.

cropping

The available field properties are based on the data type of the _____.

current field

To prevent a proper name from being flagged as misspelled, add it to the:

custom dictionary

Words that you want the Spelling Checker to recognize that do not appear in the main dictionary can be added to the:

custom dictionary.

A foreign key and the primary key of the referenced table must have matching:

data types

Making a bullet point a subordinate topic to another bullet point is called:

demoting

To add an attachment to an attachment field,

double-click the Attachment field cell.

An object can be moved anywhere on a slide by:

dragging the selection.

Which of the following graphic types can be created within PowerPoint?

drawing objects

The smallest unit of information about a record in a database is called a:

field

Although optional, this item makes the table easier to understand and update.

field description

You can quickly add fields to a table using the _____, which includes a field name, a data type, and other settings that control the appearance and behavior of the field.

field model

The maximum number of characters in a field is set using this property.

field size

Which of the following is not an example of a PowerPoint object?

file

Enhancing the appearance of the slide to make it more readable or attractive is called:

formatting

Using a color progression makes a slide more interesting; this is called ______ effect.

gradient

If you want to provide copies of your presentation to the audience showing multiple slides on a page, you would print __________________.

handouts

In a datasheet, field names are displayed in the _____.

header row

To display the slide master, one can do this.

hold down Shift and click Normal view

Which of the following is NOT a valid method of creating a table?

importing from PowerPoint

Which of the following is not a valid vertical alignment?

justified

You can change the horizontal placement of an entry in a placeholder or a table cell by using one of the four horizontal alignment settings: left, center, right, and ______________.

justified

Which page orientation prints along the length of the paper?

landscape

In a datasheet, it is desirable to adjust the column width so that the column is slightly:

larger than the column heading or longest field contents, whichever is longer.

In the Relationship window, a join in which referential integrity is enforced is displayed as a:

line with thick ends.

The best way to apply changes to every slide in your presentation is to ______________.

modify the theme slide master

The Sales Person table contains one record for each sales person. The related Client table contains one record for each client. A particular sales person is assigned to several clients records but each of the clients only have one sales person. This is an example of a ________ relationship.

one-to-many

In Slide Sorter view, how is the selected slide indicated?

orange border

Records that do not contain matching primary key record in the associated table are called:

orphaned

A scanned photograph is what type of object that can be added to a database table?

picture

The step in the development of a presentation that focuses on determining the length of your speech, the audience, the layout of the room, and the type of audiovisual equipment available is _________________.

planning

Font size is measured in:

points

To ensure relationships between tables are valid and that related data is not accidentally changed or deleted, the rules of ______ should be created.

referential integrity

A _____ establishes the association between common fields in two tables.

relationship

In Datasheet view, the square to the left of each row is the:

select record button

The dashed-line border of the _____ indicates that you can enter, delete, select, and format the object inside the placeholder.

selection

The boxes that can be used to adjust the size of the placeholder are called:

sizing handles

The zoom controls are located where?

status bar

If you want to display information in columns and rows, you would create a ____________.

table

A _________________ is a file containing predefined settings that can be used as a pattern to create many common types of presentations.

template

What is the term for a ready-to-use database that includes the data structure for the selected type of database?

template

Bold, italics, underline, shadow and color are examples of:

text effects.

When you add new records in a datasheet, the records are displayed in what order?

the order in which they were entered

On the Available Templates and Themes window, the templates are represented as what?

thumbnails

The first slide in your presentation is what?

title slide

In PowerPoint, Dissolve and Wipe Right are types of:

transitions

You can quickly highlight all the text of a bullet point by _____ it.

triple clicking

In the datasheet view, one can navigate to the current field in the previous record by pressing the:

up arrow

PowerPoint identifies misspelled words with a _____.

wavy red line

Attachments are opened using what program?

whatever program is associated with the attachment type