Question 1

When using the Advanced Filter command, a criteria range is not entered into a dialog box.

Accepted Answer

A) True 
 B)False

Question 2

The data from a column that appears in a filter list arrow cannot be used as search criteria.

Accepted Answer

A) True 
 B)False

Question 3

When creating labels, use the ____ dialog box to select a label size and to specify the type of printer you plan to use.

Accepted Answer

A)  Labels 
B)  Create Labels 
C)  Label Options 
D)  Format Labels 
A)  Labels 
B)  Create Labels 
C)  Label Options 
D)  Format Labels

Question 4

The transpose function allows you to arrange a vertical range of cells horizontally.​

Accepted Answer

A) True 
 B)False

Question 5

Data sources created and saved as an Access database use the .mdb file extension.​

Accepted Answer

A) True 
 B)False

Question 6

You click the All Pictures black and white check box to change all of the pictures in a(n) contact sheet to black and white.  _________________________

Accepted Answer

A) True 
 B)False

Question 7

The Compatibility Checker is used to find and list features not supported in earlier versions of PowerPoint.

Accepted Answer

A) True 
 B)False

Question 8

When you create a table, Excel automatically generates a ____ next to each column header that you can use to filter records.

Accepted Answer

A)  criteria button 
B)  list arrow 
C)  plus sign 
D)  search button 
A)  criteria button 
B)  list arrow 
C)  plus sign 
D)  search button

Question 9

The menu that appears when you click a filter list arrow includes data from that column.

Accepted Answer

A) True 
 B)False

Question 10

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 now needs to add merge fields to her letter so that a greeting line, address, and job title appears in each of the customized letters. How would she add these fields?

Accepted Answer

Shizuka can use the Mail Merge task pane

Question 11

What is one advantage of merging to a printer instead of to a new file?

Accepted Answer

A)  You can avoid creating a large file. 
B)  You can edit the main document. 
C)  You can edit the individual merge documents. 
D)  You can save each merge document as a separate file. 
A)  You can avoid creating a large file. 
B)  You can edit the main document. 
C)  You can edit the individual merge documents. 
D)  You can save each merge document as a separate file.

Question 12

A report that contains a subreport is called the ____ report.

Accepted Answer

A)  control 
B)  main 
C)  parent 
D)  property 
A)  control 
B)  main 
C)  parent 
D)  property

Question 13

Summary reports may not contain controls in the Group Header and Footer sections.​

Accepted Answer

A) True 
 B)False

Question 14

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. 
During a presentation, viewers can use OneNote to invite others to view the broadcast.

Accepted Answer

A) True 
 B)False

Question 15

​If you leave a blank row in the criteria range, Excel filters nothing and shows all records.

Accepted Answer

A) True 
 B)False

Question 16

The ____________________ New Page property helps you start printing a section at the top of a new page.

Accepted Answer

The answer of The ____________________ New Page property helps you...

Question 17

Explain all aspects of a custom slide show. How would you most likely use one?

Accepted Answer

A custom show gives you the ability to a

Question 18

Which of the following is NOT changed with a theme?

Accepted Answer

A)  fonts 
B)  colors 
C)  field values 
D)  control alignment 
A)  fonts 
B)  colors 
C)  field values 
D)  control alignment

Question 19

​You can filter a table by the color of the cells if conditional formatting has been applied.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____________________ custom show is a separate presentation or a presentation that includes slides from the original presentation.

Accepted Answer

The answer of A(n) ____________________ custom show is a separate...

When using the Advanced Filter command, a criteria range is not entered into a dialog box.

The data from a column that appears in a filter list arrow cannot be used as search criteria.

When creating labels, use the ____ dialog box to select a label size and to specify the type of printer you plan to use.

The transpose function allows you to arrange a vertical range of cells horizontally.

Data sources created and saved as an Access database use the .mdb file extension.

You click the All Pictures black and white check box to change all of the pictures in a(n) contact sheet to black and white. _________________________

The Compatibility Checker is used to find and list features not supported in earlier versions of PowerPoint.

When you create a table, Excel automatically generates a ____ next to each column header that you can use to filter records.

The menu that appears when you click a filter list arrow includes data from that column.

What is one advantage of merging to a printer instead of to a new file?

A report that contains a subreport is called the ____ report.

Summary reports may not contain controls in the Group Header and Footer sections.

If you leave a blank row in the criteria range, Excel filters nothing and shows all records.

The ____________________ New Page property helps you start printing a section at the top of a new page.

Explain all aspects of a custom slide show. How would you most likely use one?

Which of the following is NOT changed with a theme?

You can filter a table by the color of the cells if conditional formatting has been applied.

A(n) ____________________ custom show is a separate presentation or a presentation that includes slides from the original presentation.

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 using the Advanced Filter command, a criteria range is not entered into a dialog box.

The data from a column that appears in a filter list arrow cannot be used as search criteria.

When creating labels, use the ____ dialog box to select a label size and to specify the type of printer you plan to use.

The transpose function allows you to arrange a vertical range of cells horizontally.​

Data sources created and saved as an Access database use the .mdb file extension.​

You click the All Pictures black and white check box to change all of the pictures in a(n) contact sheet to black and white. _________________________

The Compatibility Checker is used to find and list features not supported in earlier versions of PowerPoint.

When you create a table, Excel automatically generates a ____ next to each column header that you can use to filter records.

The menu that appears when you click a filter list arrow includes data from that column.

What is one advantage of merging to a printer instead of to a new file?

A report that contains a subreport is called the ____ report.

Summary reports may not contain controls in the Group Header and Footer sections.​

​If you leave a blank row in the criteria range, Excel filters nothing and shows all records.

The ____________________ New Page property helps you start printing a section at the top of a new page.

Explain all aspects of a custom slide show. How would you most likely use one?

Which of the following is NOT changed with a theme?

​You can filter a table by the color of the cells if conditional formatting has been applied.

A(n) ____________________ custom show is a separate presentation or a presentation that includes slides from the original presentation.

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 transpose function allows you to arrange a vertical range of cells horizontally.

Data sources created and saved as an Access database use the .mdb file extension.

Summary reports may not contain controls in the Group Header and Footer sections.

If you leave a blank row in the criteria range, Excel filters nothing and shows all records.

You can filter a table by the color of the cells if conditional formatting has been applied.