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.​ ____________________

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?

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 ____.