ISM 120 Final Exam Review
Using a custom animation effect, how do you make text appear on a slide letter by letter?
Apply an entrance effect, and then set it to By letter in the Effect Options dialog box.
The Apply Design Template command is used to
Change the background and fonts of the entire presentation
Which one of the following is not a common type of chart in Excel?
Comparison chart
A query can be viewed as a question you ask a ____.
Database
What data type would you choose for a field where examples of entries are March 3, 2008 and September 4, 2007?
Date/Time
If you sort data in order of decreasing value such as Z-A, or 10-1, what type of sort are you using?
Descending
The view that is used to modify objects is called
Design View
Databases are useful only if they are ___________.
Detailed
During a slide show, pressing the Esc key will
End the slide show.
Databases typically store their data in one big table.
False
If you sort a database's information chronologically, then you are sorting letters and symbols.
False
One disadvantage of computerized databases is that they limit your ability to arrange information.
False
The data source of data in a query must be tables.
False
There are several different types of charts and graphs in Excel. The most common are Pie, Column, Line, Bar, Regression, and Scatter charts.
False
To apply a design template to all your slides, you need to select all the slide thumbnails on the Slides tab before you apply the template.
False
To design the layout for your slides, the best way is to create layouts for slides, handouts, and notes using the Master Layout dialog box in slide master view.
False
Each column in a database table is a:
Field
In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________.
Field
These provide a way to display only records in a table that match a certain criteria; these cannot be saved.
Filters
This database object is often a more convenient way to enter and view records than a table.
Form
When discussing the importance of data accuracy, we often say GIGO. What does GIGO stand for?
Garbage in, garbage out.
What does a filter do?
Hide records from view
This database object is a question you ask the database. These can be saved.
Query
All of the data about one person or item makes up a:
Record
This database object display data in a custom format. They are often easier to read than tables.
Report
The use of a password can help preserve a database's _____________.
Security
To make one section of slides in your presentation use a different design template from the other slides, what do you do?
Select the slide thumbnails in that section, and apply a different design template.
You can re-arrange slides in
Sorter View
What does SQL stand for?
Structured Query Language
This database object is arranged in rows and columns and looks similar to an Excel worksheet.
Table
What data type should you choose for a field that will contain words?
Text
A database is a collection of related information, but a database management system is a type of software program.
True
A field's data type determines what kind of information can be stored there.
True
A query can include fields from more than one table.
True
For a good presentation, it is recommended to use fewer, more effective words rather than complete sentences.
True
Speaker notes are notes added to PowerPoint presentation slides as a reference for the presenter. Notes pane is an area of a PowerPoint slide that is hidden during the presentation reserving for notes for the speaker.
True
The Toolbox has tools that you can use to modify forms and reports.
True
To design the layout for your slides, an efficient way is that to select a layout from the Slide Layout task plane and apply to your slides.
True
Which of the following cannot be placed on a single slide?
Two different color schemes
Which one of the following is not recommended for presentation?
Using complete sentences/paragraphs to present complete ideas
Access is a ______ program.
database management
Generally, your audience come to your presentation for one of the following reasons except:
reading your PowerPoint slides.
To delete the slide currently displayed in the Slide pane,
select the Delete Slide command.
In Excel, to alternate row colors, you will use:
the Conditional Formatting feature in the Home tab.
In Excel, if you want to add data bars into cells to compare the values, you will use:
the Conditional Formatting in the Home tab.
Generally, your audience come to your presentation for one of the following reasons except:
watching elaborate Powerpoint animations.
