Exam 2
_______ are a great way to add accompanying text to each slide in the album and provide explanation for the photos when no presenter is present.
Captions
________ animation occurs after the object has displayed on the slide. It can be useful to draw attention to a specific object on a busy slide by adding motion or highlights.
Emphasis
_________ animation is very popular for introducing bulleted text one bullet at a time, which prevents viewers from advancing their attention beyond the current topic.
Entrance
True or False- A SmartArt graphic is not a professional-quality diagram that visually illustrates text using a variety of shapes.
False
_________ can contain different types of content, including text, graphics, tables, charts, and videos.
Placeholders
__________ occurs when data is repeated several times in a database. Redundant data is bad, because it wastes space and increases the likelihood of errors and inconsistencies
Redundancy
The most popular Excel function in the Math category is undoubtedly the ____ function.
SUM
A ______ _____ uses a type of function called an aggregate function to sum the data in a query result set.
Totals query
True or False- A slide zoom allows users to navigate freely between slides in any order without interrupting the flow of the presentation. They're a good option for shorter presentations without lots of sections but slide zooms can be used for lots of different presentation scenarios.
True
True or False- A split form can be created by clicking More Forms from Create tab, and then choosing Split Form. A split form displays two views of the data simultaneously — a Form view and a Datasheet view.
True
True or False- Access reports organize and present data in a reader-friendly, visually appealing format by using data from any queries or tables in the database.
True
True or False- Charts are particularly useful for simplifying complex sets of data to expose the shape of the data- numerical patterns, trends, and other significant activity. What charts lack in terms of precision they overcome with broader insight and quicker comprehension
True
True or False- In relational database terms, a relationship is a situation where multiple tables can contain related data that is linked by a common field. A relationship consists of a parent table and a child table.
True
True or False- Layout view allows users to edit the report design while it contains live data. Considered the most intuitive view to use for report modification, this view can be used for nearly all potential changes to a report in Access.
True
True or False- Multi-field sorting requires the use of primary, secondary and potentially, tertiary sorting fields. Using Access' Query Design View, fields can be arranged in any order in the QBE grid to accommodate the desired order.
True
True or False- PowerPoint's photo album allows users to load a bunch of digital photos into a single file, one photo per slide, formatted consistently, with a variety of formatting options.
True
True or False- Queries can be something simple, like list all names in a table, or something a little more complex, like list all products that are priced over certain amount.
True
True or False- Slide transitions are the visual and audio effects that occur when the presentation moves from one slide to the next while in slide show view. By default, no transitions exist in a newly created presentation.
True
True or False- Templates are a popular starting point for creating new presentations, in part because they save time, and maintain consistency.
True
True or False- The Design tab allows the user to modify the color, fonts or theme of the form. A logo, title and/or date/time field can also be added to the form.
True
True or False- The IF function is one of the most popular and useful functions in Excel. It can be used to make a decision based on a comparison.
True
True or False- The Report Wizard provides more flexibility than by simply using the Report button. The Report Wizard guides usersthrough a series of questions and then generates a report based on these answers.
True
True or False- The TODAY and NOW functions are very similar since both return the current system date. However, the NOW function also returns the current system time.
True
True or False- The Title and Content slide layout is both the default and the overwhelming most popular slide layout for most slides in a presentation. This is the root cause of why so many PowerPoint presentations bore their audiences with mundane amounts of text.
True
True or False- The most common purpose for a presentation is to inform an audience by providing facts and figures. Informational presentations often include slides with tables, charts, graphics and text.
True
True or False- The most common reason to print a PowerPoint file is to produce handouts, but this objective demands further consideration.
True
True or False- The numerator is the dividend and is the value before the forward slash (/). The denominator is the divisor and is the value after the forward slash (/).
True
True or False- The real power of a relational database, like Access, lies in its ability to quickly and easily retrieve and analyze data by running a query.
True
True or False- Two ways to maintain consistency in a PowerPoint presentation is to use templates or slide masters.
True
True or False- Validation rules are popular for numeric and date entries and are formed with one or more relational operators and/or logical operators.
True
True or False- ________ animation occurs after the object has displayed on the slide. It can be useful to draw attention to a specific object on a busy slide by adding motion or highlights.
True
True or false- A slide zoom allows users to navigate freely between slides in any order without interrupting the flow of the presentation. They're a good option for shorter presentations without lots of sections but slide zooms can be used for lots of different presentation scenarios.
True
True or falso- The most common purpose for a presentation is to inform an audience by providing facts and figures. Informational presentations often include slides with tables, charts, graphics and text.
True
A cell reference that does not change when copied is called an _________ _____ ___________ (sometimes called a fixed cell reference).
absolute cell reference
The _________ is the area behind the text and graphics on a slide.
background
A _________ query does not always populate all the fields in the result set because the tables used in the query do not always contain valuesfor every possible data point.
crosstab
A ____ _____ is the sequence of values that Excel uses to plot in a chart.
data series
A __________ is a collection of related data that is organized so that it can be easily access, managed and updated.
database
A ______ _____ is a named combination of formats that comprise of colors, fonts, backgrounds, and other effects.
design theme
Displaying records based on specified criteria is called _______.
filtering
A ____ object is typically used for entering new records into a table or edit/deleting/display existing records in a table.
form
The _____ _____ work great when color is not effective, such as when printing to black & white laser printers.
icon sets
A _________ ______ retrieves information in an interactive manner by prompting the end user to supply criteria before the query is run.
parameter query
A _______ ___ consists of one or more fields that uniquely identify each record that you store in the table.
primary key
A ______ object retrieves specific data from other database objects and then displays only the data that the user specifies.
query
A select query with criteria that matches a range of values is called a _______ ____.
range query
A _____ ______ is the template that applies to all slides in a presentation.
slide master
Arranging data in a specified order is called_______.
sorting
A _____ _________ is a reference to avalue that does not change
static reference
A _______ _____ is a landing page where users can see the pieces of their presentation summarized into one slide.
summary zoom
