Question 1

Which of the following is not a category tab in the Property Sheet?

Accepted Answer

A)  Print 
B)  Format 
C)  Data 
D)  All 
A)  Print 
B)  Format 
C)  Data 
D)  All

Question 2

To specify a long list of valid entries you can type them ____ and then type the list range in the Source text box.

Accepted Answer

A)  on a new sheet 
B)  in the formula bar 
C)  in another workbook 
D)  elsewhere in the worksheet 
A)  on a new sheet 
B)  in the formula bar 
C)  in another workbook 
D)  elsewhere in the worksheet

Question 3

Which of the following contains the unique information for each individual or item?

Accepted Answer

A)  Merge source 
B)  Data source 
C)  Data file 
D)  Main document 
A)  Merge source 
B)  Data source 
C)  Data file 
D)  Main document

Question 4

After extracting table data, what button do you use to display the original table again?

Accepted Answer

A)  Clear 
B)  Filter 
C)  Reverse Filter 
D)  Revert 
A)  Clear 
B)  Filter 
C)  Reverse Filter 
D)  Revert

Question 5

In the Data Validation dialog box, clicking List from the ____ list arrow allows you to type a list of specific options.

Accepted Answer

A)  Allow 
B)  Values 
C)  Restrict 
D)  Valid 
A)  Allow 
B)  Values 
C)  Restrict 
D)  Valid

Question 6

You can filter records based on information in a specific field.

Accepted Answer

A) True 
 B)False

Question 7

Viewers of a(n) ____________________ presentation need access to the Internet, a web browser, and the URL for the presentation.

Accepted Answer

The answer of Viewers of a(n) ____________________ presentation need access...

Question 8

Sorting the ____ determines the order in which they are merged.

Accepted Answer

A)  fields 
B)  records 
C)  names 
D)  filters 
A)  fields 
B)  records 
C)  names 
D)  filters

Question 9

To ensure that only authorized viewers see your presentation, you can ____.

Accepted Answer

A)  set a password for it. 
B)  create a custom show 
C)  email it to them directly 
D)  add them to the reviewers list 
A)  set a password for it. 
B)  create a custom show 
C)  email it to them directly 
D)  add them to the reviewers list

Question 10

Before you can add subtotals to table data, you must convert it to a(n) ____ and then sort it.

Accepted Answer

A)  list 
B)  column 
C)  range 
D)  argument 
A)  list 
B)  column 
C)  range 
D)  argument

Question 11

Which of the following can you apply to a photograph in a PowerPoint photo album?

Accepted Answer

A)  theme 
B)  frame 
C)  title 
D)  effect 
E)  caption
F) rotation angle 
A)  theme 
B)  frame 
C)  title 
D)  effect 
E)  caption
F) rotation angle

Question 12

Report section properties cannot be modified to improve report printouts. _________________________

Accepted Answer

A) True 
 B)False

Question 13

What can you do with linked files in a presentation you are going to email to ensure they are included with the presentation?

Accepted Answer

A)  Compress the files 
B)  Use the Compatibility Checker 
C)  Attach the linked files to the email 
D)  Change the linked objects to embedded objects 
A)  Compress the files 
B)  Use the Compatibility Checker 
C)  Attach the linked files to the email 
D)  Change the linked objects to embedded objects

Question 14

The default format for a greeting line uses a colon (:).​

Accepted Answer

A) True 
 B)False

Question 15

When sent via email, a presentation is sent as a(n) ____.

Accepted Answer

A)  attachment 
B)  picture 
C)  Microsoft Word document 
D)  link 
A)  attachment 
B)  picture 
C)  Microsoft Word document 
D)  link

Question 16

One advantage of the Advanced Filter is that you can move filtered table data to a new worksheet.​

Accepted Answer

A) True 
 B)False

Question 17

The merge fields in a main document must correspond with the field names in the associated data source.​

Accepted Answer

A) True 
 B)False

Question 18

Extra spaces and punctuation marks included in a field entry are deleted when the data is merged.​

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: Conditions entered on different lines in an advanced filter
Conditions entered on the same line in an advanced filter
To display only the records that meet the criteria you specify
Wildcard to specify a series of characters
Place a copy of a filtered table in a range that you specify in the Advanced Filter dialog box
Wildcard to specify a single character
Used in an advanced filter to specify conditions for the filter

Accepted Answer

The Answer of extract and And and * and Criteria is...

Question 20

You select the type of document you want to create in step ____ of the mail merge process.

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Which of the following is not a category tab in the Property Sheet?

To specify a long list of valid entries you can type them ____ and then type the list range in the Source text box.

Which of the following contains the unique information for each individual or item?

After extracting table data, what button do you use to display the original table again?

In the Data Validation dialog box, clicking List from the ____ list arrow allows you to type a list of specific options.

You can filter records based on information in a specific field.

Viewers of a(n) ____________________ presentation need access to the Internet, a web browser, and the URL for the presentation.

Sorting the ____ determines the order in which they are merged.

To ensure that only authorized viewers see your presentation, you can ____.

Before you can add subtotals to table data, you must convert it to a(n) ____ and then sort it.

Which of the following can you apply to a photograph in a PowerPoint photo album?

Report section properties cannot be modified to improve report printouts. _________________________

What can you do with linked files in a presentation you are going to email to ensure they are included with the presentation?

The default format for a greeting line uses a colon (:).

When sent via email, a presentation is sent as a(n) ____.

One advantage of the Advanced Filter is that you can move filtered table data to a new worksheet.

The merge fields in a main document must correspond with the field names in the associated data source.

Extra spaces and punctuation marks included in a field entry are deleted when the data is merged.

You select the type of document you want to create in step ____ of the mail merge process.

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

Which of the following is not a category tab in the Property Sheet?

To specify a long list of valid entries you can type them ____ and then type the list range in the Source text box.

Which of the following contains the unique information for each individual or item?

After extracting table data, what button do you use to display the original table again?

In the Data Validation dialog box, clicking List from the ____ list arrow allows you to type a list of specific options.

You can filter records based on information in a specific field.

Viewers of a(n) ____________________ presentation need access to the Internet, a web browser, and the URL for the presentation.

Sorting the ____ determines the order in which they are merged.

To ensure that only authorized viewers see your presentation, you can ____.

Before you can add subtotals to table data, you must convert it to a(n) ____ and then sort it.

Which of the following can you apply to a photograph in a PowerPoint photo album?

Report section properties cannot be modified to improve report printouts. _________________________

What can you do with linked files in a presentation you are going to email to ensure they are included with the presentation?

The default format for a greeting line uses a colon (:).​

When sent via email, a presentation is sent as a(n) ____.

One advantage of the Advanced Filter is that you can move filtered table data to a new worksheet.​

The merge fields in a main document must correspond with the field names in the associated data source.​

Extra spaces and punctuation marks included in a field entry are deleted when the data is merged.​

You select the type of document you want to create in step ____ of the mail merge process.

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

The default format for a greeting line uses a colon (:).

One advantage of the Advanced Filter is that you can move filtered table data to a new worksheet.

The merge fields in a main document must correspond with the field names in the associated data source.

Extra spaces and punctuation marks included in a field entry are deleted when the data is merged.