Question 1

In a query, the operator means not equal.

Accepted Answer

A) True 
 B)False

Question 2

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

Accepted Answer

A) True 
 B)False

Question 3

Animating data markers individually by   ____________________  displays the data markers of each category in the chart.

Accepted Answer

The answer of Animating data markers individually by   ____________________  displays the...

Question 4

The Links dialog box includes ____.

Accepted Answer

A)  PowerPoint slides 
B)  PowerPoint notes 
C)  Excel files 
D)  Excel charts

Question 5

In Query Design View, you can drag the edge of a(n) field list to resize it.  _________________________

Accepted Answer

A) True 
 B)False

Question 6

You are writing a yearly report for the sales company you work for, which has two sales teams. You have created a chart that shows the quarterly breakdown of each team's 2016 sales. 
How would you go about changing data without having to recreate the chart?

Accepted Answer

The answer of You are writing a yearly report for...

Question 7

The Online Video command in the ____________________ group on the Insert tab allows you to insert and play videos found on the web.​

Accepted Answer

The answer of The Online Video command in the ____________________...

Question 8

You can copy a query datasheet but not an Access table into PowerPoint.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is not a possible window arrangement in the Arrange Windows dialog box?

Accepted Answer

A)  Tiled 
B)  Layered 
C)  Horizontal 
D)  Cascade

Question 10

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

Accepted Answer

The answer of Use the ____ check box in the...

Question 11

To add the name of the worksheet to a header or footer, click the Sheet Title button in the Header and Footer Elements group.​ ____________________

Accepted Answer

A) True 
 B)False

Question 12

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 could Julie add to her chart that would identify potential inaccuracies in data?

Accepted Answer

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

Question 13

The Links dialog box shows PowerPoint slides linked to a(n) ____________________ document.

Accepted Answer

The answer of The Links dialog box shows PowerPoint slides...

Question 14

Cool Slant is a(n) ____________________ style.

Accepted Answer

The answer of Cool Slant is a(n) ____________________ style....

Question 15

The information that appears in the Insights task pane is generated by the Googl e search engine.​____________________

Accepted Answer

A) True 
 B)False

Question 16

To select multiple objects, press and hold the [Shift] key.​

Accepted Answer

A) True 
 B)False

Question 17

To sort records by last name then by payment date, the last name field must be the secondary sort field and the payment date must be the primary sort field.​

Accepted Answer

A) True 
 B)False

Question 18

Which command in the Adjust group allows you to change one picture for another but retain the original picture's size and formatting?

Accepted Answer

A)  Swap 
B)  Replace 
C)  Relink 
D)  Change Picture

Question 19

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Accepted Answer

The answer of The Find ____ Query Wizard is used...

Question 20

In Query Design View, primary key fields in a field list are ____.

Accepted Answer

A)  underlined 
B)  the first field listed 
C)  the last field listed 
D)  indicated with a key icon

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

In a query, the operator means not equal.

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

Animating data markers individually by ____________________ displays the data markers of each category in the chart.

The Links dialog box includes ____.

In Query Design View, you can drag the edge of a(n) field list to resize it. _________________________

You are writing a yearly report for the sales company you work for, which has two sales teams. You have created a chart that shows the quarterly breakdown of each team's 2016 sales. How would you go about changing data without having to recreate the chart?

The Online Video command in the ____________________ group on the Insert tab allows you to insert and play videos found on the web.

You can copy a query datasheet but not an Access table into PowerPoint.

Which of the following is not a possible window arrangement in the Arrange Windows dialog box?

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

To add the name of the worksheet to a header or footer, click the Sheet Title button in the Header and Footer Elements group. ____________________

The Links dialog box shows PowerPoint slides linked to a(n) ____________________ document.

Cool Slant is a(n) ____________________ style.

The information that appears in the Insights task pane is generated by the Googl e search engine.____________________

To select multiple objects, press and hold the [Shift] key.

To sort records by last name then by payment date, the last name field must be the secondary sort field and the payment date must be the primary sort field.

Which command in the Adjust group allows you to change one picture for another but retain the original picture's size and formatting?

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

In Query Design View, primary key fields in a field list are ____.

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

In a query, the operator means not equal.

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

Animating data markers individually by ____________________ displays the data markers of each category in the chart.

The Links dialog box includes ____.

In Query Design View, you can drag the edge of a(n) field list to resize it. _________________________

You are writing a yearly report for the sales company you work for, which has two sales teams. You have created a chart that shows the quarterly breakdown of each team's 2016 sales. How would you go about changing data without having to recreate the chart?

The Online Video command in the ____________________ group on the Insert tab allows you to insert and play videos found on the web.​

You can copy a query datasheet but not an Access table into PowerPoint.

Which of the following is not a possible window arrangement in the Arrange Windows dialog box?

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

To add the name of the worksheet to a header or footer, click the Sheet Title button in the Header and Footer Elements group.​ ____________________

The Links dialog box shows PowerPoint slides linked to a(n) ____________________ document.

Cool Slant is a(n) ____________________ style.

The information that appears in the Insights task pane is generated by the Googl e search engine.​____________________

To select multiple objects, press and hold the [Shift] key.​

To sort records by last name then by payment date, the last name field must be the secondary sort field and the payment date must be the primary sort field.​

Which command in the Adjust group allows you to change one picture for another but retain the original picture's size and formatting?

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

In Query Design View, primary key fields in a field list are ____.

The Online Video command in the ____________________ group on the Insert tab allows you to insert and play videos found on the web.

To add the name of the worksheet to a header or footer, click the Sheet Title button in the Header and Footer Elements group. ____________________

The information that appears in the Insights task pane is generated by the Googl e search engine.____________________

To select multiple objects, press and hold the [Shift] key.

To sort records by last name then by payment date, the last name field must be the secondary sort field and the payment date must be the primary sort field.