Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
51 Cards in this Set
- Front
- Back
Templates begin on the _______ |
Slide master |
|
A absolute cell reference is denoted by a: |
Dollar sign $$$ |
|
The inputs used by an Excel function are called: |
Arguments
|
|
A _______ is a form created from one table but it has a Form view and a Datasheet view in the same window. |
Split form |
|
______ is the error message you get when you attempt to use a cell that has been deleted as a function argument |
#REF! |
|
Three primary charting objectives are: |
data exploration argumentation hypothesis testing |
|
To show changes over time you would use a: |
Line chart |
|
To place an object such as a circle or square into a chart, you click the ________ in the _______ group on the __________ tab |
Shapes Illustrations Insert |
|
The text suggests for each hour of presentation, you allow _______ of planning time |
four hours |
|
Data is stored in Excel in ______ and ______ |
Rows Columns |
|
In a presentation a ______ would be used to show comparison of the parts to the whole |
pie chart |
|
PowerPoint's default view is the ______ view |
Normal |
|
During a presentation, pressing ______ will advance to the next slide. |
spacebar |
|
______ are small lines at the end of the letters |
serifs |
|
the recommended minimum font size for text in the body of a slide is ______ |
18 points |
|
To select multiple shapes press and hold ______ while clicking each shape |
Shift |
|
______ is text that has been enriched by color, outlines, shadows, or special effects |
Word Art |
|
______ are defined as the visual and audio elements that occur as the slides change |
transitions |
|
While working on a slide show, consider your ______ as you add audio to your presentation |
audience |
|
______ are short notes explaining your thoughts |
comments |
|
While practicing a presentation the people you enlist to watch can make you aware of ______ and ______ ______ |
verbal and non-verbal distractions |
|
Pictures, tables, charts, and sound clips are examples of ______ that can be selected and manipulated independently |
objects
|
|
the related data values used in creating a chart are called ______ |
data series |
|
a ______ is a field that uniquely identifies the record |
primary key field |
|
the file into which you insert an object is called the ______ |
destination file |
|
to link a chart, you select the ______ option in the Paste Special dialog box |
Paste Link |
|
An object is automatically updated when the destination file is closed and then opened, unless you turn off ______ in the Links option |
automatic updates |
|
Both ______ and ______ can be used to collect, store, and sort data |
Excel Access |
|
Column headings in Excel become ______ when imported into Access |
field names |
|
In a well-designed database, a ______ is selected for every table |
primary key |
|
an ______ is a hierarchical representation of paragraphs that are recognized by Word by nonprinting, end-of-paragraph marks |
outline |
|
the ______ allows you to show the lower levels of an outline after they've collapsed |
expand button |
|
PowerPoint can only make slides from a Word document if the document is ______ |
closed |
|
If a security warning appears when you open a database, and you trust the contents, you should click the ______ button |
Enable Content |
|
You are reading a report that shows Company A generated $2000 last week This would be ______ |
information |
|
______ are facts about people, events, things, or ideas |
data |
|
When you open a database, Access displays the ______ on the left side |
Navigation Pane |
|
Access is different from Excel because Access allows ______ |
multiple tables with relationships between the tables |
|
an ______ is an alternative to using a space in a named range |
underscore |
|
______ define the kind of data that can be entered into a field, like numbers, text, and dates |
data types |
|
when creating presentations, remember the KISS concept: |
Keep It Short and Simple |
|
______ give more information on how the data is stored, entered, and processed |
field properties |
|
Data stored as an ______ file cannot be imported into a table in Access |
Adobe PDF |
|
______ is a feature that can change the column width of the data to match the widest data entered in that field |
Auto Fit |
|
______ prior to the presentation gives you a feel for how you might be able to move and engage the audience during the speech |
Walking around the room |
|
In a query, you can select any records that have no value in a field using the ______ criteria. |
Is Null |
|
When you create a form from two tables that have a one-to-many relationship, the first table selected becomes the ______ and the second table you select becomes the ______ |
main form subform |
|
______ begin on the slide master |
Templates |
|
A split form is a form created from one table, but it has ______ a ______ in the same window |
Form view Datasheet view |
|
______ are examples of objects that can be selected and manipulated |
Pictures, tables, charts, sound clips |
|
______ in Excel becomes field names when imported into Access |
Column headings |