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

It is possible to resize a graphic using exact measurements.

(True/False)

4.8/5

(31)

Question 201

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

(Essay)

4.9/5

(33)

Question 202

You can embed a PowerPoint slide in a Word document and then, because it is embedded, use PowerPoint tools within Word to add text to the slide and apply formatting.

(True/False)

4.8/5

(27)

Question 203

Why would you want to insert Word objects in a PowerPoint presentation? How can you do this?

(Essay)

4.8/5

(34)

Question 204

Match each of the following with the correct definition or statement.

A predefined Access formula that returns a value such as a subtotal or count

Wildcard character

An asterisk or question mark used in a query

Expression

A statistic such as a subtotal or count is determined on a given field in a group of records

Function

Correct Answer:

Verified

A predefined Access formula that returns a value such as a subtotal or count

An asterisk or question mark used in a query

A statistic such as a subtotal or count is determined on a given field in a group of records

A combination of field names, operators and functions

A datasheet's records are placed in a determined order

A field of data that is created based on values of other fields

(Matching)

4.9/5

(37)

Question 205

To delete a table row, click the Edit Table button on the mini-toolbar, and then click Delete Rows. ____________________

(True/False)

4.8/5

(35)

Question 206

The area or range of cells whose data is allowed to change is known as the ____________________ entry area.

(Short Answer)

4.9/5

(31)

Question 207

When a workbook is marked as final, a yellow bar appears below the tabs with a(n) _____ button.

(Multiple Choice)

5.0/5

(28)

Question 208

To apply a quick style, click the Quick Styles button in the Format group. ____________________

(True/False)

4.9/5

(34)

Question 209

A ____ will print behind worksheet data.

(Multiple Choice)

4.9/5

(35)

Question 210

Explain the position and purpose for the three typical field positions used in a crosstab query.

(Essay)

4.9/5

(35)

Question 211

If you animate a chart's data markers as a series, the entire data series is animated as a group.

(True/False)

4.8/5

(30)

Question 212

A worksheet displayed in its own window is called a(n) ____.

(Multiple Choice)

4.8/5

(38)

Question 213

To change the chart colors, click the Change Colors button in the Chart Format group.

(True/False)

4.9/5

(26)

Question 214

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 predict future developments?

(Multiple Choice)

4.9/5

(30)

Question 215

How do you change an inline graphic to a floating graphic?

(Multiple Choice)

4.7/5

(30)

Question 216

When you change the source file of a linked object, ____.

(Multiple Choice)

4.8/5

(34)

Question 217

The destination of a hyperlink is called the ____________________.

(Short Answer)

4.8/5

(39)

Question 218

An SQL statement determines how the resulting records are sorted after the ____ keyword.

(Multiple Choice)

4.8/5

(29)

Question 219

The single-file w eb page file format is called ____________________.

(Short Answer)

4.8/5

(38)

Question 220

Showing 201 - 220 of 353

It is possible to resize a graphic using exact measurements.

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

You can embed a PowerPoint slide in a Word document and then, because it is embedded, use PowerPoint tools within Word to add text to the slide and apply formatting.

Why would you want to insert Word objects in a PowerPoint presentation? How can you do this?

To delete a table row, click the Edit Table button on the mini-toolbar, and then click Delete Rows. ____________________

The area or range of cells whose data is allowed to change is known as the ____________________ entry area.

When a workbook is marked as final, a yellow bar appears below the tabs with a(n) _____ button.

To apply a quick style, click the Quick Styles button in the Format group. ____________________

A ____ will print behind worksheet data.

Explain the position and purpose for the three typical field positions used in a crosstab query.

If you animate a chart's data markers as a series, the entire data series is animated as a group.

A worksheet displayed in its own window is called a(n) ____.

To change the chart colors, click the Change Colors button in the Chart Format group.

How do you change an inline graphic to a floating graphic?

When you change the source file of a linked object, ____.

The destination of a hyperlink is called the ____________________.

An SQL statement determines how the resulting records are sorted after the ____ keyword.

The single-file w eb page file format is called ____________________.

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

It is possible to resize a graphic using exact measurements.

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

You can embed a PowerPoint slide in a Word document and then, because it is embedded, use PowerPoint tools within Word to add text to the slide and apply formatting.

Why would you want to insert Word objects in a PowerPoint presentation? How can you do this?

To delete a table row, click the Edit Table button on the mini-toolbar, and then click Delete Rows​. ____________________

The area or range of cells whose data is allowed to change is known as the ____________________ entry area.

When a workbook is marked as final, a yellow bar appears below the tabs with a(n) _____ button.​

To apply a quick style, click the Quick Styles button in the Format group.​ ____________________

A ____ will print behind worksheet data.

Explain the position and purpose for the three typical field positions used in a crosstab query.

If you animate a chart's data markers as a series, the entire data series is animated as a group.

A worksheet displayed in its own window is called a(n) ____.

To change the chart colors, click the Change Colors button in the Chart Format group.​

How do you change an inline graphic to a floating graphic?

When you change the source file of a linked object, ____.

The destination of a hyperlink is called the ____________________.

An SQL statement determines how the resulting records are sorted after the ____ keyword.

The single-file w eb page file format is called ____________________.

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

To delete a table row, click the Edit Table button on the mini-toolbar, and then click Delete Rows. ____________________

When a workbook is marked as final, a yellow bar appears below the tabs with a(n) _____ button.

To apply a quick style, click the Quick Styles button in the Format group. ____________________

To change the chart colors, click the Change Colors button in the Chart Format group.