Question 1

Which of the following does NOT appear in the AutoFilter list menu?

Accepted Answer

A)  sort options 
B)  row numbers 
C)  advanced filtering options 
D)  data from the column where the AutoFilter list arrow is 
A)  sort options 
B)  row numbers 
C)  advanced filtering options 
D)  data from the column where the AutoFilter list arrow is B

Question 2

You create a parameter report based on a parameter query by setting the report's ____ property.

Accepted Answer

A)  Recordset 
B)  Group Controls 
C)  Record Source 
D)  None of the above. 
A)  Recordset 
B)  Group Controls 
C)  Record Source 
D)  None of the above. C

Question 3

To find records for employees whose salary is greater than $60,000 and whose gender is female, use the ____.

Accepted Answer

A)  Table locator 
B)  Search button 
C)  Advanced Filter command 
D)  Filter by Selection command 
A)  Table locator 
B)  Search button 
C)  Advanced Filter command 
D)  Filter by Selection command C

Question 4

You can add  ____ conditional format(s) for any combination of selected controls.

Accepted Answer

A)  One 
B)  Two 
C)  Multiple 
D)  Currency 
A)  One 
B)  Two 
C)  Multiple 
D)  Currency

Question 5

You can use the Format Painter to format lines, labels, and text boxes.

Accepted Answer

A) True 
 B)False

Question 6

Use the ____________________ dialog box to apply advanced sort and filter options to a data source.

Accepted Answer

The answer of Use the ____________________ dialog box to apply...

Question 7

Which key do you press and hold to create a perfectly horizontal line?

Accepted Answer

A)  [Alt] 
B)  [Ctrl] 
C)  [Shift] 
D)  [Caps Lock] 
A)  [Alt] 
B)  [Ctrl] 
C)  [Shift] 
D)  [Caps Lock]

Question 8

The Encrypt Document dialog box is used to create a password. _________________________

Accepted Answer

A) True 
 B)False

Question 9

The Rules command on the Mailings tab​ sets guidelines that control how Word merges the data in the data source with the main document.

Accepted Answer

A) True 
 B)False

Question 10

Report ____________________ View allows you to work with a complete range of report, section, and control properties.

Accepted Answer

The answer of Report ____________________ View allows you to work...

Question 11

During an online presentation, what do you press and then wait for viewers to see each slide?

Accepted Answer

A)  [Tab] 
B)  [Next] 
C)  [Enter] 
D)  [Spacebar] 
A)  [Tab] 
B)  [Next] 
C)  [Enter] 
D)  [Spacebar]

Question 12

Describe the basic process of sending a presentation using email.

Accepted Answer

Once you have completed a presentation,

Question 13

A(n) theme displays a report within another report. _________________________

Accepted Answer

A) True 
 B)False

Question 14

The following small placeholders appear on the Handout Master.

Accepted Answer

A)  header 
B)  footer 
C)  page number 
D)  date 
E)  slide number 
A)  header 
B)  footer 
C)  page number 
D)  date 
E)  slide number

Question 15

You can use a(n) subreport control to change the order in which information prints. _________________________

Accepted Answer

A) True 
 B)False

Question 16

When you generate subtotals, all levels of detail show in a(n) ____.

Accepted Answer

A)  outline 
B)  extracted table 
C)  list range 
D)  graph 
A)  outline 
B)  extracted table 
C)  list range 
D)  graph

Question 17

To change the orientation of slides on a handout, click the Handout Orientation button in the _____ group.​

Accepted Answer

A) Page Setup 
B) Orientation 
C) Layout 
D) Print Preview 
A) Page Setup 
B) Orientation 
C) Layout 
D) Print Preview

Question 18

Shizuka is asked to print letters to send to all the employees in her company's sales department to let them know about some recent changes in the department. She has already written the letter. Now she is ready to create a mail merge. 
Shizuka's Outlook contacts list includes all the employees in the company, but she only wants to send letters to employees in the sales department. How can she modify the recipients list to only include employees in the sales department?

Accepted Answer

Shizuka needs to filter her recipients l

Question 19

Use the ____ dialog box to specify the fields you want to include in an address block.

Accepted Answer

A)  Insert Address Block 
B)  Insert Field 
C)  Edit Address Block 
D)  Format Address Block 
A)  Insert Address Block 
B)  Insert Field 
C)  Edit Address Block 
D)  Format Address Block

Question 20

The VLOOKUP function searches vertically down the  ____ of the table, then reads across the row until the matching value is found.

Accepted Answer

A)  first cell 
B)  left-most column 
C)  right-most column 
D)  first row 
A)  first cell 
B)  left-most column 
C)  right-most column 
D)  first row

Which of the following does NOT appear in the AutoFilter list menu?

You create a parameter report based on a parameter query by setting the report's ____ property.

To find records for employees whose salary is greater than $60,000 and whose gender is female, use the ____.

You can add ____ conditional format(s) for any combination of selected controls.

You can use the Format Painter to format lines, labels, and text boxes.

Use the ____________________ dialog box to apply advanced sort and filter options to a data source.

Which key do you press and hold to create a perfectly horizontal line?

The Encrypt Document dialog box is used to create a password. _________________________

The Rules command on the Mailings tab sets guidelines that control how Word merges the data in the data source with the main document.

Report ____________________ View allows you to work with a complete range of report, section, and control properties.

During an online presentation, what do you press and then wait for viewers to see each slide?

Describe the basic process of sending a presentation using email.

A(n) theme displays a report within another report. _________________________

The following small placeholders appear on the Handout Master.

You can use a(n) subreport control to change the order in which information prints. _________________________

When you generate subtotals, all levels of detail show in a(n) ____.

To change the orientation of slides on a handout, click the Handout Orientation button in the _____ group.

Use the ____ dialog box to specify the fields you want to include in an address block.

The VLOOKUP function searches vertically down the ____ of the table, then reads across the row until the matching value is found.

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 does NOT appear in the AutoFilter list menu?

You create a parameter report based on a parameter query by setting the report's ____ property.

To find records for employees whose salary is greater than $60,000 and whose gender is female, use the ____.

You can add ____ conditional format(s) for any combination of selected controls.

You can use the Format Painter to format lines, labels, and text boxes.

Use the ____________________ dialog box to apply advanced sort and filter options to a data source.

Which key do you press and hold to create a perfectly horizontal line?

The Encrypt Document dialog box is used to create a password. _________________________

The Rules command on the Mailings tab​ sets guidelines that control how Word merges the data in the data source with the main document.

Report ____________________ View allows you to work with a complete range of report, section, and control properties.

During an online presentation, what do you press and then wait for viewers to see each slide?

Describe the basic process of sending a presentation using email.

A(n) theme displays a report within another report. _________________________

The following small placeholders appear on the Handout Master.

You can use a(n) subreport control to change the order in which information prints. _________________________

When you generate subtotals, all levels of detail show in a(n) ____.

To change the orientation of slides on a handout, click the Handout Orientation button in the _____ group.​

Use the ____ dialog box to specify the fields you want to include in an address block.

The VLOOKUP function searches vertically down the ____ of the table, then reads across the row until the matching value is found.

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 Rules command on the Mailings tab sets guidelines that control how Word merges the data in the data source with the main document.

To change the orientation of slides on a handout, click the Handout Orientation button in the _____ group.