question

If you are unable to see all of the fields on your display, click the ____ to give you more room on the screen to view the object's contents.

answer

Shutter Bar Open/Close Button on the Navigation Pane

question

Every foreign key must ____.

answer

match the field value of a primary key in a related table

question

Which extension identifies a file as a Microsoft Access 2013 database?

answer

.accdb

question

A table's contents are displayed as rows and columns in ____.

answer

Datasheet view

question

In Datasheet View, clicking a record selector ____.

answer

selects an entire row

question

A ____ is a question you ask about data stored in a database.

answer

query

question

The Create tab has options to create all of the following EXCEPT ____.

answer

other databases

question

Martha's database had been working well but it has begun to behave in unexpected ways. What should she do?

answer

Use the Compact ; Repair Database option.

question

The ____ determines what type of values can be entered for a field.

answer

data type

question

A primary key ___.

answer

uniquely identifies each record in a table

question

If a primary key from one table is also defined in a second table to form a relationship, the field is called a ____ in the second table.

answer

foreign key

question

The data type that allows you to indicate the absence or presence of a condition is ____.

answer

Yes/No

question

A field defined as a Yes/No field type will be displayed as ____.

answer

a check box

question

For a special report, Tom wants his donation fields to display in a Currency format that does not display dollar signs, so he will use the ____ format.

answer

Standard

question

The ____ operator will cause a record to be selected only if two or more conditions are satisfied.

answer

And

question

An Excel formula always begins with a(n) ____.

answer

equals sign

question

____ enters text based on patterns it finds in the data.

answer

Flash Fill

question

Tyler notices that the Address column is too wide. He could use that extra space for other columns so he ____.

answer

autofits the column by double-clicking its border

question

Samantha wants to find out how much money she will make on her largest order, which is currently in row E. Cell E4 contains the number of items ordered and cell E5 contains the price per item. An appropriate formula would be ____.

answer

=E4*E5

question

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.

answer

Painter

question

In one of Harold's columns there are too many numbers after the decimal place. It is distracting from the data and he really only needs two numbers after the decimal. How could Harold make the data appear cleaner in the most efficient way?

answer

decrease number of digits displayed by clicking on the command in Numbers group

question

Harold would like to center a title across the top of his data. His data runs across five columns, from column A to column E. One way he could accomplish this is to _____.

answer

type the data in A1 and Merge cells A1:E1

question

Antoinette wants all her worksheets to have the same formatting for text, colors, and graphical effects applied to create a specific look and feel. Antoinette needs to apply a _____.

answer

theme

question

Absolute references are marked with a ____.

answer

$

question

The ____ dialog box provides options for moving charts to another worksheets or creating a new chart sheets.

answer

Move Chart

question

Generally, _____ are given a "washed-out" appearance and are placed behind text or charts on the sheet so that they do not obscure any of the other content on the sheet.

answer

watermarks

question

The ____ is the first slide in a PowerPoint presentation.

answer

Title Slide

question

A commonly used layout is the ____ layout.

answer

Title and Content

question

A ____ is a coordinated set of colors, fonts, backgrounds, and effects.

answer

Theme

question

In PowerPoint terms, ____ a photo means cutting off edges you don't want to include.

answer

cropping

question

____ handles are the small squares that appear in the corners and in the middle of the sides of the border of a selected object.

answer

Sizing

question

____ notes are information you add about slide content to help you remember to bring up specific points during the presentation.

answer

Speaker

question

When you print ____, the presentation is printed with one or more slides on each piece of paper.

answer

Handouts

question

When Ethan first opens PowerPoint, he has two ____ view options: 1) to open an existing presentation or 2) to create a new file.

answer

Backstage

question

Like shapes, you can rotate or ____ pictures using the Rotate handle or the Rotate button.

answer

flip

question

An installed theme can be applied by clicking on a theme in the Themes group on the ____ tab.

answer

Design

question

Use the Animation ____ to copy the animation, effects, and duration applied to one object to another object.

answer

Painter

question

The most commonly used video formats are the MPEG-____ format, the Windows Media Audio/Video format, and the Audio Visual Interleave format.

answer

4

question

After you insert a video, you can modify it by changing ____ options, changing the length of time the video plays, and applying formats and styles to the video.

answer

Playback

question

If a video is too long, or if there are parts you don't want to show during the slide show, you can ____ it.

answer

trim

question

Usually the date and slide number do not need to appear on the ____.

answer

title slide

question

The Office ____ is a temporary storage area on your computer that holds objects such as text or graphics until you need them.

answer

Clipboard

question

To copy selected text, you can use the keyboard command ____.

answer

Ctrl+C

question

A ____ is a coordinated collection of fonts, colors, and other visual effects designed to give a document a cohesive, polished look.

answer

theme

question

The indent buttons on the HOME tab allow you to increase or decrease paragraph indenting in increments of ____ inches.

answer

0.5

question

Charlotte knows that she will be drafting several contracts in the coming weeks, and each letter will need to be printed with specific headings and body text formatting. To save time, Charlotte should apply ____.

answer

styles

question

From the Navigation pane, you can ____ a subordinate heading to the next level up in the heading hierarchy.

answer

promote

question

When you press the Tab key in the last cell in the table, ____.

answer

you add a new row to the bottom of the table

question

Which of the following is not a major tab stop?

answer

justify

question

To format part of a document in an orientation different from the rest of the document, you need to ____.

answer

divide the document into sections

question

The best way for Josephine to organize her data in Microsoft Word would be to use ____.

answer

a table

question

Monica has included a table in her report to give information on 20 key events. Since the table is text-heavy, Monica wants to make it easier to distinguish between the rows. Monica should use the ____ formatting to make her table easier to read.

answer

Banded Rows

question

Monica is editing her report and notices that she has forgotten to insert a footnote on page 4. When Monica inserts the footnote, ____.

answer

Word will automatically renumber all footnotes

question

WordArt is considered a(n) _______ that can be manipulated independently of the text.

answer

object

question

Which of the following is not a wrapping style for graphics?

answer

circle

question

To cut off part of the graphic in an illustration, you would _______ the illustration.

answer

crop

Computer in Ag

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards