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. _________________________

(True/False)

4.8/5

(36)

Question 121

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

(Multiple Choice)

4.7/5

(45)

Question 122

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

(Short Answer)

4.9/5

(34)

Question 123

Match each term with its correct description.

Shows statistics on groups of records

Parameter report

Prompts the user for criteria to select records for a report

Conditional formatting

Changes the way a control looks on a form or report based on criteria you specify

Theme

Correct Answer:

Verified

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

(Matching)

4.8/5

(23)

Question 124

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

(Multiple Choice)

4.8/5

(32)

Question 125

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

(True/False)

4.7/5

(31)

Question 126

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

(True/False)

4.9/5

(37)

Question 127

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

(Short Answer)

4.8/5

(36)

Question 128

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

(Multiple Choice)

4.7/5

(41)

Question 129

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

(True/False)

4.9/5

(37)

Question 130

The New Address List dialog box is used to ____.

(Multiple Choice)

4.9/5

(32)

Question 131

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

(True/False)

4.8/5

(34)

Question 132

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

(Multiple Choice)

4.7/5

(28)

Question 133

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

(Multiple Choice)

4.7/5

(28)

Question 134

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.

(True/False)

4.8/5

(29)

Question 135

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

(True/False)

4.8/5

(35)

Question 136

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

(True/False)

4.8/5

(33)

Question 137

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

(True/False)

4.7/5

(43)

Question 138

A custom show allows you to ____.

(Multiple Choice)

4.7/5

(40)

Question 139

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

(Short Answer)

4.9/5

(33)

Question 140

Showing 121 - 140 of 281

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.

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.

Module 4: Integrating Word and Excel Access

Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Filters

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.

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.

Module 4: Integrating Word and Excel Access

Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Filters

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.