Question 1

When you sort records, you pull out the records that meet a certain criteria and include only those records in the merge. _________________________

Accepted Answer

A) True 
 B)False

Question 2

To start a mail merge, click the Start Mail Merge button on the Mailings tab, then click ____.

Accepted Answer

A)  Step-by-Step Mail Merge Wizard 
B)  New Mail Merge 
C)  Start Mail Merge 
D)  Start Mail Merge Wizard

Question 3

When creating a photo album, you can convert the ____________________ to black and white.

Accepted Answer

The answer of When creating a photo album, you can...

Question 4

Match between columns
                        Premises: Shows statistics on groups of records
Prompts the user for criteria to select records for a report
Changes the way a control looks on a form or report based on criteria you specify
Copies formatting properties from one control to another
Predefined format that you can apply to all objects in the database

Accepted Answer

The Answer of Parameter report and Conditional formatting and Theme is...

Question 5

When specifying criteria in the Custom AutoFilter dialog box, use the ____ wildcard to specify a single character.

Accepted Answer

A)  (?) 
B)  * 
C)  ' 
D)  Both A and B.

Question 6

To create a parameter report, you base it on a parameter table . _________________________

Accepted Answer

A) True 
 B)False

Question 7

You can use collaboration software, such as SharePoint Online to work with others on a presentation. ____________________​

Accepted Answer

A) True 
 B)False

Question 8

____________________ formatting allows you to change the appearance of a control on a form or report based on criteria you specify.

Accepted Answer

The answer of ____________________ formatting allows you to change the...

Question 9

The HLOOKUP function searches horizontally ____ of the table until the matching value is found.

Accepted Answer

A)  across the upper row 
B)  across the bottom row 
C)  in the left-most column 
D)  in the right-most column

Question 10

​You can restrict data in a table to whole numbers, decimal numbers, or text.

Accepted Answer

A) True 
 B)False

Question 11

The New Address List dialog box is used to ____.

Accepted Answer

A)  add records to the data source 
B)  add fields to the data source 
C)  sort and filter records 
D)  print labels

Question 12

You can use the Check Vision feature to check for potential issues for people with reading disabilities. ____________________​

Accepted Answer

A) True 
 B)False

Question 13

To use advanced filtering, you must define a(n) ____ range.

Accepted Answer

A)  extract 
B)  conditional 
C)  criteria 
D)  response

Question 14

You can merge a reviewer's changes to your presentation into your original presentation using the ____ command on the Review tab.

Accepted Answer

A)  Review Comments 
B)  Integrate 
C)  Merge 
D)  Compare

Question 15

Case-Based Critical Thinking Question 
Sandy is a high school math teacher. She uses PowerPoint to create some of her online teaching tools that her students use in class. Sandy wants to save a presentation for the Web, and she needs your help. 
For online presentations, viewers need the URL, which is automatically supplied by PowerPoint.

Accepted Answer

A) True 
 B)False

Question 16

Parameter formatting allows you to change the appearance of a control on a form or report based on criteria you specify. _________________________

Accepted Answer

A) True 
 B)False

Question 17

When you filter a table, you temporarily delete the records that do not meet your criteria.​

Accepted Answer

A) True 
 B)False

Question 18

You use conditional formatting to highlight important data in a report.

Accepted Answer

A) True 
 B)False

Question 19

A custom show allows you to ____.

Accepted Answer

A)  progress through slides using a laser pointer 
B)  add special features from the Internet to be used during a slide show 
C)  adapt a presentation for use with a specific audience 
D)  add more functionality to PowerPoint, like movie and sound editing

Question 20

A(n) ____________________ gives you more control over how data is printed than forms and datasheets.

Accepted Answer

The answer of A(n) ____________________ gives you more control over...

Exam 8: Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

When you sort records, you pull out the records that meet a certain criteria and include only those records in the merge. _________________________

To start a mail merge, click the Start Mail Merge button on the Mailings tab, then click ____.

When creating a photo album, you can convert the ____________________ to black and white.

Match each term with its correct description.

When specifying criteria in the Custom AutoFilter dialog box, use the ____ wildcard to specify a single character.

To create a parameter report, you base it on a parameter table . _________________________

You can use collaboration software, such as SharePoint Online to work with others on a presentation. ____________________

____________________ formatting allows you to change the appearance of a control on a form or report based on criteria you specify.

The HLOOKUP function searches horizontally ____ of the table until the matching value is found.

You can restrict data in a table to whole numbers, decimal numbers, or text.

The New Address List dialog box is used to ____.

You can use the Check Vision feature to check for potential issues for people with reading disabilities. ____________________

To use advanced filtering, you must define a(n) ____ range.

You can merge a reviewer's changes to your presentation into your original presentation using the ____ command on the Review tab.

Parameter formatting allows you to change the appearance of a control on a form or report based on criteria you specify. _________________________

When you filter a table, you temporarily delete the records that do not meet your criteria.

You use conditional formatting to highlight important data in a report.

A custom show allows you to ____.

A(n) ____________________ gives you more control over how data is printed than forms and datasheets.

Exam 8: Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

When you sort records, you pull out the records that meet a certain criteria and include only those records in the merge. _________________________

To start a mail merge, click the Start Mail Merge button on the Mailings tab, then click ____.

When creating a photo album, you can convert the ____________________ to black and white.

Match each term with its correct description.

When specifying criteria in the Custom AutoFilter dialog box, use the ____ wildcard to specify a single character.

To create a parameter report, you base it on a parameter table . _________________________

You can use collaboration software, such as SharePoint Online to work with others on a presentation. ____________________​

____________________ formatting allows you to change the appearance of a control on a form or report based on criteria you specify.

The HLOOKUP function searches horizontally ____ of the table until the matching value is found.

​You can restrict data in a table to whole numbers, decimal numbers, or text.

The New Address List dialog box is used to ____.

You can use the Check Vision feature to check for potential issues for people with reading disabilities. ____________________​

To use advanced filtering, you must define a(n) ____ range.

You can merge a reviewer's changes to your presentation into your original presentation using the ____ command on the Review tab.

Parameter formatting allows you to change the appearance of a control on a form or report based on criteria you specify. _________________________

When you filter a table, you temporarily delete the records that do not meet your criteria.​

You use conditional formatting to highlight important data in a report.

A custom show allows you to ____.

A(n) ____________________ gives you more control over how data is printed than forms and datasheets.

You can use collaboration software, such as SharePoint Online to work with others on a presentation. ____________________

You can restrict data in a table to whole numbers, decimal numbers, or text.

You can use the Check Vision feature to check for potential issues for people with reading disabilities. ____________________

When you filter a table, you temporarily delete the records that do not meet your criteria.