Match between columns Premises: violet white gray brown red

The Answer of cleanliness, perfection, simplicity and wealth, royalty, power, is...

Match between columns Premises: orange yellow green blue black

The Answer of fall, warmth, happiness, enjoyment and peace, calm, is...

Match between columns Premises: calculated control tab order bound control read-only form unbound control

The Answer of the sequential advancing in a form from is...

Match between columns Premises: DAVERAGE DMIN DMAX DSUM DCOUNT

The Answer of Adds the values in a numeric database is...

Match between columns Premises: Legacy form field ActiveX control VBA IRM Design Mode

The Answer of used to edit the statements in a is...

Match between columns Premises: NPER FV IPMT PPMT CUMIPMT

The Answer of Use this function to calculate the total is...

Match between columns Premises: MATCH INDEX HLOOKUP VLOOKUP Lookup_value

The Answer of Looks for a value in the left is...

Match between columns Premises: RATE NPER INDEX MATCH FV

The Answer of Use this function to return a value is...

Exam 7: Infographics: Hands On Exercise Videos

Selecting the First Column table style:

(Multiple Choice)

4.8/5

(82)

Question 21

Match the following colors with their color associations:

violet

cleanliness, perfection, simplicity

white

wealth, royalty, power, respect ,and attention

gray

energy, aggression, making a point or gain attention

Correct Answer:

Verified

violet

white

gray

brown

red

(Matching)

4.8/5

(63)

Question 22

To combine a group of cells into a single cell,you click ________ Cells.

(Multiple Choice)

4.7/5

(83)

Question 23

You can use a table ________ to apply formatting to the table components based on the theme of your presentation.

(Multiple Choice)

4.9/5

(78)

Question 24

Match the following colors with their color associations:

orange

fall, warmth, happiness, enjoyment

yellow

peace, calm, cold, building trust

green

sunshine, bright, gaining positive response

Correct Answer:

Verified

orange

yellow

green

blue

black

(Matching)

4.9/5

(90)

Question 25

Which option scales a slide to show the entire slide?

(Multiple Choice)

4.9/5

(66)

Question 26

Match the following terms with their meanings:

calculated control

the sequential advancing in a form from one field or control to the next

tab order

a control not tied to a specific field

bound control

a control containing an expression that generates a calculated result

Correct Answer:

Verified

calculated control

tab order

bound control

read-only form

unbound control

(Matching)

5.0/5

(72)

Question 27

Match the following terms with the corresponding description.

DAVERAGE

Adds the values in a numeric database column based on conditions you specify in a criteria range

DMIN

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

DMAX

Counts the cells that contain numbers in a database column that match conditions you specify

Correct Answer:

Verified

DAVERAGE

DMIN

DMAX

DSUM

DCOUNT

(Matching)

4.9/5

(82)

Question 28

Match the following terms with their descriptions:

basic custom show

designed for the presenter but can be distributed to audience also

handout master

connects to a main custom show

notes master

single presentation from which you create separate presentations

Correct Answer:

Verified

basic custom show

handout master

notes master

hyperlinked custom show

slide master

(Matching)

4.8/5

(72)

Question 29

Match the following terms to their meanings:

Legacy form field

used to edit the statements in a macro

ActiveX control

allow user to make modifications to control fields

VBA

form element that works in Office 2007 and later versions

Correct Answer:

Verified

Legacy form field

ActiveX control

VBA

IRM

Design Mode

(Matching)

4.8/5

(80)

Question 30

Match the following terms to their meanings:

Enable all macros

all macros and security alerts are disabled

Disable all macros with notification

macro default setting

Disable all macros without notification

setting for developers only

Correct Answer:

Verified

Enable all macros

Disable all macros with notification

Disable all macros without notification

Disable all macros except digitally signed macros

Trust access to the VBA project object model

(Matching)

4.8/5

(77)

Question 31

Match the following terms with the corresponding description.

NPER

Use this function to calculate the total interest paid on a mortgage

FV

Use this function to calculate the amount of principle paid on the first payment of a car loan

IPMT

Use this function to calculate the number of periods in a loan

Correct Answer:

Verified

NPER

FV

IPMT

PPMT

CUMIPMT

(Matching)

4.8/5

(77)

Question 32

You can manually change each element of a chart individually,or you can apply a predefined layout to the entire chart.

(True/False)

4.8/5

(85)

Question 33

Clicking Distribute Columns and Distribute Rows ensures that the width and height of all cells will be distributed equally.

(True/False)

4.9/5

(72)

Question 34

Match the following PowerPoint features with the tabs where they are located:

change PowerPoint options

View tab

modify handout master

Insert tab

view custom slides shows

Slide Show tab

Correct Answer:

Verified

change PowerPoint options

modify handout master

view custom slides shows

change the font of a presentation

create a hyperlink on a slide

(Matching)

4.8/5

(75)

Question 35

Match the following terms with the corresponding description.

MATCH

Looks for a value in the left most column of a table, and then returns a value in the same row from a column you specify

INDEX

Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify

HLOOKUP

Returns a value or the reference to a value within a range based on X and Y coordinates

Correct Answer:

Verified

MATCH

INDEX

HLOOKUP

VLOOKUP

Lookup_value

(Matching)

4.9/5

(97)

Question 36

A(n)________ chart is used to show to show data changes over a period of time or Comparisons among items.

(Multiple Choice)

4.8/5

(76)

Question 37

To select all slices in a pie,you double-click any slice.

(True/False)

4.9/5

(82)

Question 38

Match the following dialog boxes to their features or options:

Microsoft Office Security Options dialog box

name a macro

Record Macro dialog box

edit a macro

Trust Center dialog box

select date formats in Date Picker

Correct Answer:

Verified

Microsoft Office Security Options dialog box

Record Macro dialog box

Trust Center dialog box

Visual Basic editor

Properties dialog box

(Matching)

4.9/5

(69)

Question 39

Match the following terms with the corresponding description.

RATE

Use this function to return a value given X and Y coordinates

NPER

Use this function to determine the future value of an investment

INDEX

Use this function to determine the number of payments in an autoloan

Correct Answer:

Verified

RATE

NPER

INDEX

MATCH

FV

(Matching)

4.9/5

(74)

Question 40

Exam 7: Infographics: Hands On Exercise Videos

Selecting the First Column table style:

To combine a group of cells into a single cell,you click ________ Cells.

You can use a table ________ to apply formatting to the table components based on the theme of your presentation.

Which option scales a slide to show the entire slide?

You can manually change each element of a chart individually,or you can apply a predefined layout to the entire chart.

Clicking Distribute Columns and Distribute Rows ensures that the width and height of all cells will be distributed equally.

A(n)________ chart is used to show to show data changes over a period of time or Comparisons among items.

To select all slices in a pie,you double-click any slice.

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