Question 1

A linked chart is saved as a separate file.

Accepted Answer

A) True 
 B)False  True

Question 2

Which aggregate function is used to find the number of values in a field?

Accepted Answer

A)  Values 
B)  Num 
C)  Number 
D)  Count 
A)  Values 
B)  Num 
C)  Number 
D)  Count D

Question 3

A link is a ____.

Accepted Answer

A)  connection between a source file and a destination file 
B)  connection between an embedded object and a source file 
C)  picture that is pasted to a slide 
D)  chart created using Microsoft Graph 
A)  connection between a source file and a destination file 
B)  connection between an embedded object and a source file 
C)  picture that is pasted to a slide 
D)  chart created using Microsoft Graph A

Question 4

The wildcard character that represents any combination of characters 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 5

To ensure that a workbook displays the same way on different computers, publish it in _____ format.

Accepted Answer

A) pdf 
B) ods 
C) xps 
D) xltm 
A) pdf 
B) ods 
C) xps 
D) xltm

Question 6

You can insert a linked Excel file into a PowerPoint presentation using the ___________________ command.

Accepted Answer

The answer of You can insert a linked Excel file...

Question 7

Which arithmetic operator signifies division?

Accepted Answer

A)  ^ 
B)  * 
C)  / 
D)  \ 
A)  ^ 
B)  * 
C)  / 
D)  \

Question 8

The ____________________ task pane helps you find information on a selected word or phrase.​

Accepted Answer

The answer of The ____________________ task pane helps you find...

Question 9

The data displayed in a query is sometimes called a(n) ____ view of the data.

Accepted Answer

The answer of The data displayed in a query is...

Question 10

​To show table gridlines, click the Tables Tools _____ tab, then click the View Gridlines button in the Table group.

Accepted Answer

A) Layout 
B) Format 
C) Design 
D) Arrange 
A) Layout 
B) Format 
C) Design 
D) Arrange

Question 11

To format a linked Excel worksheet, right-click it and then click ____.

Accepted Answer

A)  Format Object 
B)  Format Painter 
C)  Format Linked Object 
D)  Format 
A)  Format Object 
B)  Format Painter 
C)  Format Linked Object 
D)  Format

Question 12

When you copy an Access table into PowerPoint, a link is established between the two programs.

Accepted Answer

A) True 
 B)False

Question 13

To add a shape fill to an object, click the Drawing Tools  Format  tab, and then click the Shape Fill list arrow in the Shape Styles group.​

Accepted Answer

A) True 
 B)False

Question 14

When a graphic is selected, a white ____ appears at the top of the graphic.

Accepted Answer

A)  sizing handle 
B)  rotate handle 
C)  anchor 
D)  adjustment handle 
A)  sizing handle 
B)  rotate handle 
C)  anchor 
D)  adjustment handle

Question 15

Use the ____ button in the Adjust group to replace the current picture with another picture while preserving the formatting and size of the current picture.

Accepted Answer

A)  Replace 
B)  Change Picture 
C)  Import 
D)  Change Graphic 
A)  Replace 
B)  Change Picture 
C)  Import 
D)  Change Graphic

Question 16

Case-Based Critical Thinking Question Julie is working on a financial presentation that involves a number of complex charts. She wants her charts to be clear and easy to read. She also wants to use some of PowerPoint's advanced charting features.
What would Julie add to her chart to make sure her categories are clearly identified on the category axis?

Accepted Answer

A)  Trendlines 
B)  Tick marks 
C)  Error bars 
D)  Up bars 
A)  Trendlines 
B)  Tick marks 
C)  Error bars 
D)  Up bars

Question 17

When you create an Excel chart in PowerPoint, you can perform advanced commands on Excel data in the worksheet window in PowerPoint.

Accepted Answer

A) True 
 B)False

Question 18

The coding format used for all web documents is called ____.

Accepted Answer

A)  HTML 
B)  XML 
C)  MHTML 
D)  JAVA 
A)  HTML 
B)  XML 
C)  MHTML 
D)  JAVA

Question 19

A picture added to the worksheet background will show on screen and will also print.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following cannot be a target?

Accepted Answer

A)  Web site home page 
B)  hyperlink 
C)  Word document 
D)  Excel worksheet 
A)  Web site home page 
B)  hyperlink 
C)  Word document 
D)  Excel worksheet

A linked chart is saved as a separate file.

Which aggregate function is used to find the number of values in a field?

A link is a ____.

The wildcard character that represents any combination of characters in query criteria is the ____.

To ensure that a workbook displays the same way on different computers, publish it in _____ format.

You can insert a linked Excel file into a PowerPoint presentation using the ___________________ command.

Which arithmetic operator signifies division?

The ____________________ task pane helps you find information on a selected word or phrase.

The data displayed in a query is sometimes called a(n) ____ view of the data.

To show table gridlines, click the Tables Tools _____ tab, then click the View Gridlines button in the Table group.

To format a linked Excel worksheet, right-click it and then click ____.

When you copy an Access table into PowerPoint, a link is established between the two programs.

To add a shape fill to an object, click the Drawing Tools Format tab, and then click the Shape Fill list arrow in the Shape Styles group.

When a graphic is selected, a white ____ appears at the top of the graphic.

Use the ____ button in the Adjust group to replace the current picture with another picture while preserving the formatting and size of the current picture.

When you create an Excel chart in PowerPoint, you can perform advanced commands on Excel data in the worksheet window in PowerPoint.

The coding format used for all web documents is called ____.

A picture added to the worksheet background will show on screen and will also print.

Which of the following cannot be a target?

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

A linked chart is saved as a separate file.

Which aggregate function is used to find the number of values in a field?

A link is a ____.

The wildcard character that represents any combination of characters in query criteria is the ____.

To ensure that a workbook displays the same way on different computers, publish it in _____ format.

You can insert a linked Excel file into a PowerPoint presentation using the ___________________ command.

Which arithmetic operator signifies division?

The ____________________ task pane helps you find information on a selected word or phrase.​

The data displayed in a query is sometimes called a(n) ____ view of the data.

​To show table gridlines, click the Tables Tools _____ tab, then click the View Gridlines button in the Table group.

To format a linked Excel worksheet, right-click it and then click ____.

When you copy an Access table into PowerPoint, a link is established between the two programs.

To add a shape fill to an object, click the Drawing Tools Format tab, and then click the Shape Fill list arrow in the Shape Styles group.​

When a graphic is selected, a white ____ appears at the top of the graphic.

Use the ____ button in the Adjust group to replace the current picture with another picture while preserving the formatting and size of the current picture.

When you create an Excel chart in PowerPoint, you can perform advanced commands on Excel data in the worksheet window in PowerPoint.

The coding format used for all web documents is called ____.

A picture added to the worksheet background will show on screen and will also print.

Which of the following cannot be a target?

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

The ____________________ task pane helps you find information on a selected word or phrase.

To show table gridlines, click the Tables Tools _____ tab, then click the View Gridlines button in the Table group.

To add a shape fill to an object, click the Drawing Tools Format tab, and then click the Shape Fill list arrow in the Shape Styles group.