Computer in Ag
56 test answers
Unlock all answers in this set
Unlock answers 56question
In Datasheet View, clicking a record selector ____.
answer
selects an entire row
Unlock the answer
question
A ____ is a question you ask about data stored in a database.
answer
query
Unlock the answer
question
The Create tab has options to create all of the following EXCEPT ____.
answer
other databases
Unlock the answer
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.
Unlock the answer
question
The ____ determines what type of values can be entered for a field.
answer
data type
Unlock the answer
question
A primary key ___.
answer
uniquely identifies each record in a table
Unlock the answer
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
Unlock the answer
question
The data type that allows you to indicate the absence or presence of a condition is ____.
answer
Yes/No
Unlock the answer
question
A field defined as a Yes/No field type will be displayed as ____.
answer
a check box
Unlock the answer
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
Unlock the answer
question
The ____ operator will cause a record to be selected only if two or more conditions are satisfied.
answer
And
Unlock the answer
question
An Excel formula always begins with a(n) ____.
answer
equals sign
Unlock the answer
question
____ enters text based on patterns it finds in the data.
answer
Flash Fill
Unlock the answer
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
Unlock the answer
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
Unlock the answer
question
One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.
answer
Painter
Unlock the answer
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
Unlock the answer
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
Unlock the answer
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
Unlock the answer
question
Absolute references are marked with a ____.
answer
$
Unlock the answer
question
The ____ dialog box provides options for moving charts to another worksheets or creating a new chart sheets.
answer
Move Chart
Unlock the answer
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
Unlock the answer
question
The ____ is the first slide in a PowerPoint presentation.
answer
Title Slide
Unlock the answer
question
A commonly used layout is the ____ layout.
answer
Title and Content
Unlock the answer
question
A ____ is a coordinated set of colors, fonts, backgrounds, and effects.
answer
Theme
Unlock the answer
question
In PowerPoint terms, ____ a photo means cutting off edges you don't want to include.
answer
cropping
Unlock the answer
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
Unlock the answer
question
____ notes are information you add about slide content to help you remember to bring up specific points during the presentation.
answer
Speaker
Unlock the answer
question
When you print ____, the presentation is printed with one or more slides on each piece of paper.
answer
Handouts
Unlock the answer
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
Unlock the answer
question
Like shapes, you can rotate or ____ pictures using the Rotate handle or the Rotate button.
answer
flip
Unlock the answer
question
An installed theme can be applied by clicking on a theme in the Themes group on the ____ tab.
answer
Design
Unlock the answer
question
Use the Animation ____ to copy the animation, effects, and duration applied to one object to another object.
answer
Painter
Unlock the answer
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
Unlock the answer
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
Unlock the answer
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
Unlock the answer
question
Usually the date and slide number do not need to appear on the ____.
answer
title slide
Unlock the answer
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
Unlock the answer
question
To copy selected text, you can use the keyboard command ____.
answer
Ctrl+C
Unlock the answer
question
A ____ is a coordinated collection of fonts, colors, and other visual effects designed to give a document a cohesive, polished look.
answer
theme
Unlock the answer
question
The indent buttons on the HOME tab allow you to increase or decrease paragraph indenting in increments of ____ inches.
answer
0.5
Unlock the answer
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
Unlock the answer
question
From the Navigation pane, you can ____ a subordinate heading to the next level up in the heading hierarchy.
answer
promote
Unlock the answer
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
Unlock the answer
question
Which of the following is not a major tab stop?
answer
justify
Unlock the answer
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
Unlock the answer
question
The best way for Josephine to organize her data in Microsoft Word would be to use ____.
answer
a table
Unlock the answer
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
Unlock the answer
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
Unlock the answer
question
WordArt is considered a(n) _______ that can be manipulated independently of the text.
answer
object
Unlock the answer
question
Which of the following is not a wrapping style for graphics?
answer
circle
Unlock the answer
question
To cut off part of the graphic in an illustration, you would _______ the illustration.
answer
crop
Unlock the answer
