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

A data scale uses a set of two, three, or four fill colors to convey relative values. ____________________

(True/False)

4.8/5

(34)

Question 261

What results when a main document is merged with a data source?

(Multiple Choice)

4.9/5

(30)

Question 262

To send a presentation to Word, click the File tab on the Ribbon, then click Send To.

(True/False)

4.8/5

(32)

Question 263

To view a broadcast as an audience member, you need to open the Internet address (____) provided by the host of the broadcast.

(Multiple Choice)

4.9/5

(33)

Question 264

In a filtered table, the matching row numbers are ____.

(Multiple Choice)

4.9/5

(30)

Question 265

Click the Customize Columns button in the New Address List dialog box if you want to ____.

(Multiple Choice)

4.9/5

(34)

Question 266

Why might you want to use a subreport control?

(Essay)

4.9/5

(36)

Question 267

You insert the merge fields in the main document before you create or select the data source. ____________________

(True/False)

4.9/5

(34)

Question 268

On a report, combo boxes and text boxes display data the same way.

(True/False)

4.9/5

(33)

Question 269

Explain two benefits of using the Excel data validation feature.

(Essay)

4.8/5

(32)

Question 270

What are the six steps in the mail merge process?

(Essay)

4.8/5

(29)

Question 271

The first step in the mail merge process is to ____.

(Multiple Choice)

4.9/5

(35)

Question 272

Excel's VLOOKUP function searches vertically down the far left column of a table, then reads across the row to find the value in the column you specify. _________________________

(True/False)

5.0/5

(40)

Question 273

In a report, label controls display data from underlying fields.

(True/False)

4.9/5

(40)

Question 274

To match field names in a mail merge template with the field names used in the data source, click the Match Fields button in the _____ group.

(Multiple Choice)

4.9/5

(33)

Question 275

In Report Design View, if you want to view the grouping and sorting fields, click the ____.

(Multiple Choice)

4.8/5

(32)

Question 276

When you define the criteria range and the copy-to location in the Advanced Filter dialog box, Excel automatically creates which two range names?

(Multiple Choice)

4.8/5

(36)

Question 277

The ____________________ Checker feature checks for features not supported in earlier versions of PowerPoint.

(Short Answer)

4.9/5

(33)

Question 278

During a slide show, you can use the highlight pointer to help focus the audience's attention to specific areas. _________________________

(True/False)

4.8/5

(34)

Question 279

Which of the following reports would be the most logical choice for a Vice President who is interested in high level, aggregated totals and not individual details?

(Multiple Choice)

4.8/5

(34)

Question 280

Showing 261 - 280 of 281

A data scale uses a set of two, three, or four fill colors to convey relative values. ____________________

What results when a main document is merged with a data source?

To send a presentation to Word, click the File tab on the Ribbon, then click Send To.

To view a broadcast as an audience member, you need to open the Internet address (____) provided by the host of the broadcast.

In a filtered table, the matching row numbers are ____.

Click the Customize Columns button in the New Address List dialog box if you want to ____.

Why might you want to use a subreport control?

You insert the merge fields in the main document before you create or select the data source. ____________________

On a report, combo boxes and text boxes display data the same way.

Explain two benefits of using the Excel data validation feature.

What are the six steps in the mail merge process?

The first step in the mail merge process is to ____.

Excel's VLOOKUP function searches vertically down the far left column of a table, then reads across the row to find the value in the column you specify. _________________________

In a report, label controls display data from underlying fields.

To match field names in a mail merge template with the field names used in the data source, click the Match Fields button in the _____ group.

In Report Design View, if you want to view the grouping and sorting fields, click the ____.

When you define the criteria range and the copy-to location in the Advanced Filter dialog box, Excel automatically creates which two range names?

The ____________________ Checker feature checks for features not supported in earlier versions of PowerPoint.

During a slide show, you can use the highlight pointer to help focus the audience's attention to specific areas. _________________________

Which of the following reports would be the most logical choice for a Vice President who is interested in high level, aggregated totals and not individual details?

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

A data scale uses a set of two, three, or four fill colors to convey relative values.​ ____________________

What results when a main document is merged with a data source?

To send a presentation to Word, click the File tab on the Ribbon, then click Send To.​

To view a broadcast as an audience member, you need to open the Internet address (____) provided by the host of the broadcast.

In a filtered table, the matching row numbers are ____.

Click the Customize Columns button in the New Address List dialog box if you want to ____.

Why might you want to use a subreport control?

You insert the merge fields in the main document before you create or select the data source. ____________________

On a report, combo boxes and text boxes display data the same way.​

Explain two benefits of using the Excel data validation feature.

What are the six steps in the mail merge process?

The first step in the mail merge process is to ____.

Excel's VLOOKUP function searches vertically down the far left column of a table, then reads across the row to find the value in the column you specify. _________________________

In a report, label controls display data from underlying fields.

​To match field names in a mail merge template with the field names used in the data source, click the Match Fields button in the _____ group.

In Report Design View, if you want to view the grouping and sorting fields, click the ____.

When you define the criteria range and the copy-to location in the Advanced Filter dialog box, Excel automatically creates which two range names?

The ____________________ Checker feature checks for features not supported in earlier versions of PowerPoint.

During a slide show, you can use the highlight pointer to help focus the audience's attention to specific areas. _________________________

Which of the following reports would be the most logical choice for a Vice President who is interested in high level, aggregated totals and not individual details?

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

A data scale uses a set of two, three, or four fill colors to convey relative values. ____________________

To send a presentation to Word, click the File tab on the Ribbon, then click Send To.

On a report, combo boxes and text boxes display data the same way.

To match field names in a mail merge template with the field names used in the data source, click the Match Fields button in the _____ group.