Question 1

You can create ____ of PowerPoint slides in Word.

Accepted Answer

A)  handouts 
B)  titles 
C)  copies 
D)  footnotes 
A)  handouts 
B)  titles 
C)  copies 
D)  footnotes

Question 2

The wildcard character that represents one character in query criteria is the ____.

Accepted Answer

A)  asterisk (*) 
B)  exclamation point (!) 
C)  tilde (˜) 
D)  question mark (?) 
A)  asterisk (*) 
B)  exclamation point (!) 
C)  tilde (˜) 
D)  question mark (?)

Question 3

You can give a document personality by applying a style or effect to a graphic object.​

Accepted Answer

A) True 
 B)False

Question 4

The Change Chart Type button is in the ____ group.

Accepted Answer

A)  Type 
B)  Chart 
C)  Style 
D)  Change 
A)  Type 
B)  Chart 
C)  Style 
D)  Change

Question 5

Which of the following is a way to edit grouped worksheets?

Accepted Answer

A)  Freeze the worksheet panes 
B)  Create a read-only version 
C)  Protect them 
D)  Insert a header 
A)  Freeze the worksheet panes 
B)  Create a read-only version 
C)  Protect them 
D)  Insert a header

Question 6

____________________ include keywords, the author's name, a title, the status, and comments.

Accepted Answer

The answer of ____________________ include keywords, the author's name, a...

Question 7

You want to search for all last names beginning with the letter M. The field name for last name is LName. Describe how to do this.

Accepted Answer

In the query design grid, ente

Question 8

A floating object is on the drawing layer in Word.

Accepted Answer

A) True 
 B)False

Question 9

Which gallery shows available shapes for WordArt text?

Accepted Answer

A)  WordArt Styles 
B)  Themes 
C)  Transform 
D)  Shape Styles 
A)  WordArt Styles 
B)  Themes 
C)  Transform 
D)  Shape Styles

Question 10

Access helps you with criteria syntax in the query design grid.

Accepted Answer

A) True 
 B)False

Question 11

Use the Graphic button in the Illustrations group on the Insert tab to insert a graphic file into a document. _________________________

Accepted Answer

A) True 
 B)False

Question 12

The program used to create an embedded object is called the ____.

Accepted Answer

A)  source program 
B)  embedded program 
C)  destination program 
D)  linked program 
A)  source program 
B)  embedded program 
C)  destination program 
D)  linked program

Question 13

You can specify more than one sort field in Query Design View.

Accepted Answer

A) True 
 B)False

Question 14

The Paste list arrow displays _____ available paste options.​

Accepted Answer

A) two 
B) three 
C) four 
D) five 
A) two 
B) three 
C) four 
D) five

Question 15

The Break Link command is in the ____________________ dialog box in Word.

Accepted Answer

The answer of The Break Link command is in the...

Question 16

Each criteria row of the query design grid is evaluated separately.

Accepted Answer

A) True 
 B)False

Question 17

You can change the color and effects of chart elements by applying one of the ____________ in the Chart Styles gallery.

Accepted Answer

The answer of You can change the color and effects...

Question 18

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

Accepted Answer

A)  Group By row 
B)  Total row 
C)  Values row 
D)  Crosstab row 
A)  Group By row 
B)  Total row 
C)  Values row 
D)  Crosstab row

Question 19

You cannot embed a PowerPoint slide in a Word document.​

Accepted Answer

A) True 
 B)False

Question 20

You can add trendlines and error bars to a chart.

Accepted Answer

A) True 
 B)False

You can create ____ of PowerPoint slides in Word.

The wildcard character that represents one character in query criteria is the ____.

You can give a document personality by applying a style or effect to a graphic object.

The Change Chart Type button is in the ____ group.

Which of the following is a way to edit grouped worksheets?

____________________ include keywords, the author's name, a title, the status, and comments.

You want to search for all last names beginning with the letter M. The field name for last name is LName. Describe how to do this.

A floating object is on the drawing layer in Word.

Which gallery shows available shapes for WordArt text?

Access helps you with criteria syntax in the query design grid.

Use the Graphic button in the Illustrations group on the Insert tab to insert a graphic file into a document. _________________________

The program used to create an embedded object is called the ____.

You can specify more than one sort field in Query Design View.

The Paste list arrow displays _____ available paste options.

The Break Link command is in the ____________________ dialog box in Word.

Each criteria row of the query design grid is evaluated separately.

You can change the color and effects of chart elements by applying one of the ____________ in the Chart Styles gallery.

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

You cannot embed a PowerPoint slide in a Word document.

You can add trendlines and error bars to a chart.

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

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

Exam 6: Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

You can create ____ of PowerPoint slides in Word.

The wildcard character that represents one character in query criteria is the ____.

You can give a document personality by applying a style or effect to a graphic object.​

The Change Chart Type button is in the ____ group.

Which of the following is a way to edit grouped worksheets?

____________________ include keywords, the author's name, a title, the status, and comments.

You want to search for all last names beginning with the letter M. The field name for last name is LName. Describe how to do this.

A floating object is on the drawing layer in Word.

Which gallery shows available shapes for WordArt text?

Access helps you with criteria syntax in the query design grid.

Use the Graphic button in the Illustrations group on the Insert tab to insert a graphic file into a document. _________________________

The program used to create an embedded object is called the ____.

You can specify more than one sort field in Query Design View.

The Paste list arrow displays _____ available paste options.​

The Break Link command is in the ____________________ dialog box in Word.

Each criteria row of the query design grid is evaluated separately.

You can change the color and effects of chart elements by applying one of the ____________ in the Chart Styles gallery.

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

You cannot embed a PowerPoint slide in a Word document.​

You can add trendlines and error bars to a chart.

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

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

You can give a document personality by applying a style or effect to a graphic object.

The Paste list arrow displays _____ available paste options.

You cannot embed a PowerPoint slide in a Word document.