Match between columns Premises: user exception editing restriction formatting restriction Mark as Final IRM

The Answer of user is allowed to apply approved styles is...

Match between columns Premises: nudge master color theme RGB HSL

The Answer of move an object in small increments and is...

Match between columns Premises: handout master Edit Master notes master slide master multiple masters

The Answer of designate location of placeholders and objects on is...

Match between columns Premises: Database function DMIN DMAX DAVERAGE DSUM

The Answer of Identifies the lowest value in a database is...

Match between columns Premises: Loan amortization IPMT PPMT CUMIPMT CUMPRINC

The Answer of Calculates the cumulative interest throughout a loan is...

Exam 7: Infographics: Hands On Exercise Videos

Match the following terms to their meanings:

user exception

user is allowed to apply approved styles in the document

editing restriction

user can add comments to the document but cannot make other changes

formatting restriction

is only allowed for one user per document

Correct Answer:

Verified

user exception

editing restriction

formatting restriction

Mark as Final

IRM

(Matching)

4.9/5

(83)

Question 41

When using a multiseries chart,a ________ helps to identify the data series by assigning a format or color to each data series and displaying the information along with the data series name.

(Multiple Choice)

4.8/5

(78)

Question 42

Match the following terms with their descriptions:

nudge

move an object in small increments

master

controls the layout, background, and color combinations of a presentation

color theme

numeric system for identifying a color

Correct Answer:

Verified

nudge

master

color theme

RGB

HSL

(Matching)

4.8/5

(71)

Question 43

Match the following features with the masters that control them:

handout master

designate location of placeholders and objects on slides

Edit Master

group on the Slide Master tab

notes master

modified primarily for the speaker with individual slides

Correct Answer:

Verified

handout master

Edit Master

notes master

slide master

multiple masters

(Matching)

4.9/5

(75)

Question 44

Match the following terms with the corresponding description.

Database function

Identifies the lowest value in a database column that matches conditions you specify

DMIN

Identifies the highest value in a database column that matches conditions you specify. For example, you can use the DMAX function to determine the highest salary of account reps in Boston.

DMAX

Determines the arithmetic mean, or average, of numeric entries in a database column that match conditions you specify

Correct Answer:

Verified

Database function

DMIN

DMAX

DAVERAGE

DSUM

(Matching)

4.9/5

(66)

Question 45

Match the following terms with the corresponding description.

Loan amortization

Calculates the cumulative interest throughout a loan amortization table

IPMT

Calculates the principal payment for a specified payment period on a loan or an investment given a fixed interest rate, term, and periodic payments

PPMT

Calculates the cumulative principal throughout a loan amortization table

Correct Answer:

Verified

Loan amortization

IPMT

PPMT

CUMIPMT

CUMPRINC

(Matching)

4.8/5

(79)

Question 46

A column chart can be used to display a single or multiseries data set.

(True/False)

4.9/5

(78)

Question 47

When a table is embedded,any changes to the source data file are reflected in the presentation.

(True/False)

4.8/5

(95)

Question 48

A poster is an example of a text-based chart.

(True/False)

4.9/5

(74)

Question 49

Match the following Word options to the tab where located:

insert form controls

Insert tab

modify a macro from the Macros dialog box

Review tab

add a digital signature

File tab

Correct Answer:

Verified

insert form controls

modify a macro from the Macros dialog box

add a digital signature

display Restrict Editing pane

insert Signature Line

(Matching)

5.0/5

(87)

Question 50

A ________ chart is used to show proportions of a whole.

(Multiple Choice)

4.9/5

(65)

Question 51

Exam 7: Infographics: Hands On Exercise Videos

When using a multiseries chart,a ________ helps to identify the data series by assigning a format or color to each data series and displaying the information along with the data series name.

A column chart can be used to display a single or multiseries data set.

When a table is embedded,any changes to the source data file are reflected in the presentation.

A poster is an example of a text-based chart.

A ________ chart is used to show proportions of a whole.

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters