Match between columns Premises: >= <=

The Answer of Greater than and Not equal to and is...

Match between columns Premises: run macro record macro edit macro macro Macro-Enabled Document

The Answer of process of creating a macro and process is...

Match between columns Premises: RGB HSL color theme 16 million 12

The Answer of colors used in a color theme and is...

Match between columns Premises: TrueType font embedded fonts AutoRecover AutoCorrect AutoFormat

The Answer of included within a presentation and can be is...

Match between columns Premises: form control form template form legacy forms Design Mode

The Answer of examples are purchase orders and invoices and is...

Match between columns Premises: combo box control subform detail section section bar section

The Answer of part of a form or report that is...

Match between columns Premises: PV FV NPER RATE NPV

The Answer of Calculates the periodic rate for an investment is...

Match between columns Premises: AND OR NOT IF INDEX

The Answer of A function to test if no arguments is...

Match between columns Premises: Nested function IF AND OR NOT

The Answer of A function that tests if one argument is...

Match between columns Premises: IRM digital signature signature line selfcert.exe digital certificate

The Answer of electronic stamp and a self-certification program and is...

Exam 7: Infographics: Hands On Exercise Videos

A pie chart can be used to display multiple series.

Free

(True/False)

4.9/5

(35)

Question 1

Correct Answer:

Verified

False

Match the following terms with the corresponding description.

< >

Greater than

<

Not equal to

>

Less than

Correct Answer:

Verified

< >

Greater than

<

Not equal to

>

Less than

>=

Less than or equal to

<=

Greater than or equal to

Free

(Matching)

4.9/5

(32)

Question 2

Correct Answer:

Verified

Match the following terms to their meanings:

run macro

process of creating a macro

record macro

process of playing back a macro

edit macro

a set of instructions that executes a task

Correct Answer:

Verified

run macro

process of creating a macro

record macro

process of playing back a macro

edit macro

a set of instructions that executes a task

macro

can use Visual Basic for Applications (VBA)

Macro-Enabled Document

contains VBA macro code

Free

(Matching)

4.7/5

(44)

Question 3

Correct Answer:

Verified

Match the following terms with their descriptions:

RGB

colors used in a color theme

HSL

color model that balances color characteristics to produce a color

color theme

numeric system to identify colors

Correct Answer:

Verified

RGB

HSL

color theme

16 million

12

(Matching)

4.8/5

(35)

Question 4

Match the following terms or features of PowerPoint with their descriptions:

TrueType font

included within a presentation and can be accessed and viewed from any computer

embedded fonts

how PowerPoint automatically modifies text

AutoRecover

how PowerPoint automatically arranges text and placeholders

Correct Answer:

Verified

TrueType font

embedded fonts

AutoRecover

AutoCorrect

AutoFormat

(Matching)

4.8/5

(23)

Question 5

When drawing a table,the pointer is displayed as a(n)________.

(Multiple Choice)

4.8/5

(35)

Question 6

The buttons for making table modifications such as text alignment,cell size,and merging cells are found on the ________ tab.

(Multiple Choice)

4.9/5

(40)

Question 7

Match the following terms with their meanings:

form control

examples are purchase orders and invoices

form template

enables you to view and modify control fields

form

also known as form field

Correct Answer:

Verified

form control

form template

form

legacy forms

Design Mode

(Matching)

5.0/5

(31)

Question 8

By using a predefined ________,you can keep your charts consistent and maintain a professional look to a presentation.

(Multiple Choice)

4.9/5

(37)

Question 9

Match the following meanings with their terms:

user types data and is allowed to change the format

Plain Text control

user enters data but is not allowed to change the format

Drop-Down List control

user picks a choice from a list but then modifies the item name

Combo Box control

Correct Answer:

Verified

user types data and is allowed to change the format

user enters data but is not allowed to change the format

user picks a choice from a list but then modifies the item name

user selects from a list of predefined items

user selects an item by clicking the box that displays beside the item

(Matching)

4.8/5

(20)

Question 10

Match the following tabs or features to their appropriate dialog boxes:

AutoFormat As You Type tab

Colors dialog box

Customize Ribbon tab

Insert Hyperlink dialog box

Custom tab

AutoCorrect dialog box

Correct Answer:

Verified

AutoFormat As You Type tab

Customize Ribbon tab

Custom tab

Place in This Document button

Sample box

(Matching)

4.8/5

(35)

Question 11

Match the following meanings with their terms.

provides a verifiable signature

VBA

to collect signature

digital certificate

a programming language to edit a macro

signature line

Correct Answer:

Verified

provides a verifiable signature

to collect signature

a programming language to edit a macro

to prevent unauthorized access to a document

display information about the person or organization

(Matching)

4.8/5

(26)

Question 12

Match the following terms with their meanings:

combo box control

part of a form or report that can be manipulated separately from other parts of the form or report

subform

displays the records in the record source

detail section

provides a drop-down menu displaying a list of options from which the user can chose a single value

Correct Answer:

Verified

combo box control

subform

detail section

section bar

section

(Matching)

4.8/5

(41)

Question 13

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

hide a slide

Slide Show tab

change the font

Home tab

resize a placeholder

Format tab

Correct Answer:

Verified

hide a slide

change the font

resize a placeholder

determine location to save a file

modify the notes master

(Matching)

4.9/5

(36)

Question 14

Match the following terms with the corresponding description.

PV

Calculates the periodic rate for an investment or loan given the number of payment periods, a fixed periodic payment, and present E, value

FV

Calculates the number of payment periods for an investment or loan given a fixed interest rate, periodic payment, and present value.

NPER

Calculates the net present value of an investment, given a fixed discount rate (rate of return) and a set of given cash inflows

Correct Answer:

Verified

PV

FV

NPER

RATE

NPV

(Matching)

4.8/5

(31)

Question 15

You can use the Eraser to remove table borders.

(True/False)

4.8/5

(37)

Question 16

Match the following functions with the corresponding description.

AND

A function to test if no arguments are met

OR

A function to test if at least one or more conditions are met

NOT

A function to test to see if multiple conditions are met

Correct Answer:

Verified

AND

OR

NOT

IF

INDEX

(Matching)

5.0/5

(31)

Question 17

The figure shown above depicts a(n)________ chart .

(Multiple Choice)

4.9/5

(37)

Question 18

Match the following terms with the corresponding description.

Nested function

A function that tests if one argument is met

IF

A function to test if no arguments are met

AND

A function to test if at least one or more conditions are met

Correct Answer:

Verified

Nested function

IF

AND

OR

NOT

(Matching)

4.9/5

(29)

Question 19

Match the following terms to their meanings:

IRM

electronic stamp

digital signature

a self-certification program

signature line

attachment to a file that guarantees authenticity

Correct Answer:

Verified

IRM

digital signature

signature line

selfcert.exe

digital certificate

(Matching)

4.7/5

(37)

Question 20

Exam 7: Infographics: Hands On Exercise Videos

A pie chart can be used to display multiple series.

When drawing a table,the pointer is displayed as a(n)________.

The buttons for making table modifications such as text alignment,cell size,and merging cells are found on the ________ tab.

By using a predefined ________,you can keep your charts consistent and maintain a professional look to a presentation.

You can use the Eraser to remove table borders.

The figure shown above depicts a(n)________ chart .

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