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

After others have reviewed your presentation, you have the option of rejecting some or all of the changes and ending the review without making all of the changes.

(True/False)

4.9/5

(32)

Question 241

The V in the VLOOKUP function stands for ____________________.

(Short Answer)

4.8/5

(29)

Question 242

You can use the _____ dialog box to specify records to include in the merge.

(Multiple Choice)

4.9/5

(42)

Question 243

A presentation can only have one reviewer.

(True/False)

4.8/5

(38)

Question 244

What does it mean to merge with an existing data source?

(Essay)

4.9/5

(33)

Question 245

You can apply conditional formatting to table cells in the same way that you can format a range of worksheet data.

(True/False)

4.9/5

(38)

Question 246

Which of the following can not be a data source for a mail merge?

(Multiple Choice)

4.8/5

(35)

Question 247

Not all PowerPoint features are supported for broadcasting.

(True/False)

4.9/5

(45)

Question 248

Which report section is most commonly used for titles, dates, and page numbers?

(Multiple Choice)

4.9/5

(31)

Question 249

You use the ____________________ button in the Write & Insert Fields group to add an Address Block merge field to a label.

(Short Answer)

4.8/5

(37)

Question 250

To apply more than one filter to the data source, use the options on the Filter & Sort tab.

(True/False)

5.0/5

(34)

Question 251

When you specify a complicated set of search criteria, it is a good idea to filter it in place rather than extract it.

(True/False)

4.9/5

(30)

Question 252

To format and print individual envelopes, use the Envelopes command in the _____ group on the Mailings tab.

(Multiple Choice)

4.7/5

(37)

Question 253

Sorting and filtering a data source does not alter the records in a data source.

(True/False)

4.8/5

(43)

Question 254

In the Page Setup group, Landscape is a type of ____.

(Multiple Choice)

4.9/5

(42)

Question 255

The Group, Sort, and Total pane allows you to open group header and footer sections.

(True/False)

4.9/5

(33)

Question 256

The Transpose function is a TEXT function that can be used to rearrange a range of cells. ____________________

(True/False)

4.8/5

(26)

Question 257

When performing an advanced filter, ____________________ conditions must be entered on the same row.

(Short Answer)

4.9/5

(41)

Question 258

It is necessary to keep all of the report sections the same height in order for the report to display properly.

(True/False)

4.8/5

(34)

Question 259

Report Design View gives you full control of all aspects of a report.

(True/False)

4.9/5

(44)

Question 260

Showing 241 - 260 of 281

After others have reviewed your presentation, you have the option of rejecting some or all of the changes and ending the review without making all of the changes.

The V in the VLOOKUP function stands for ____________________.

You can use the _____ dialog box to specify records to include in the merge.

A presentation can only have one reviewer.

What does it mean to merge with an existing data source?

You can apply conditional formatting to table cells in the same way that you can format a range of worksheet data.

Which of the following can not be a data source for a mail merge?

Not all PowerPoint features are supported for broadcasting.

Which report section is most commonly used for titles, dates, and page numbers?

You use the ____________________ button in the Write & Insert Fields group to add an Address Block merge field to a label.

To apply more than one filter to the data source, use the options on the Filter & Sort tab.

When you specify a complicated set of search criteria, it is a good idea to filter it in place rather than extract it.

To format and print individual envelopes, use the Envelopes command in the _____ group on the Mailings tab.

Sorting and filtering a data source does not alter the records in a data source.

In the Page Setup group, Landscape is a type of ____.

The Group, Sort, and Total pane allows you to open group header and footer sections.

The Transpose function is a TEXT function that can be used to rearrange a range of cells. ____________________

When performing an advanced filter, ____________________ conditions must be entered on the same row.

It is necessary to keep all of the report sections the same height in order for the report to display properly.

Report Design View gives you full control of all aspects of a report.

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

After others have reviewed your presentation, you have the option of rejecting some or all of the changes and ending the review without making all of the changes.

The V in the VLOOKUP function stands for ____________________.

You can use the _____ dialog box to specify records to include in the merge.​

A presentation can only have one reviewer.

What does it mean to merge with an existing data source?

You can apply conditional formatting to table cells in the same way that you can format a range of worksheet data.

Which of the following can not be a data source for a mail merge?

Not all PowerPoint features are supported for broadcasting.​

Which report section is most commonly used for titles, dates, and page numbers?

You use the ____________________ button in the Write & Insert Fields group to add an Address Block merge field to a label.

To apply more than one filter to the data source, use the options on the Filter & Sort tab.​

When you specify a complicated set of search criteria, it is a good idea to filter it in place rather than extract it.

To format and print individual envelopes, use the Envelopes command in the _____ group on the Mailings tab.

Sorting and filtering a data source does not alter the records in a data source.​

In the Page Setup group, Landscape is a type of ____.

The Group, Sort, and Total pane allows you to open group header and footer sections.

The Transpose function is a TEXT fun​ction that can be used to rearrange a range of cells. ____________________

When performing an advanced filter, ____________________ conditions must be entered on the same row.

It is necessary to keep all of the report sections the same height in order for the report to display properly.

Report Design View gives you full control of all aspects of a report.

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 the _____ dialog box to specify records to include in the merge.

Not all PowerPoint features are supported for broadcasting.

To apply more than one filter to the data source, use the options on the Filter & Sort tab.

Sorting and filtering a data source does not alter the records in a data source.

The Transpose function is a TEXT function that can be used to rearrange a range of cells. ____________________