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

You can choose to paste a Word object with or without linking it to the source document.

(True/False)

4.9/5

(49)

Question 101

Which of the following indicates that a graphic is anchored to the nearest paragraph?

(Multiple Choice)

4.9/5

(34)

Question 102

You cannot create a direct ____ between Access and PowerPoint when an Access table has been copied into a PowerPoint slide.

(Multiple Choice)

4.8/5

(29)

Question 103

A linked object is stored in its source file, not on a presentation slide such as embedded objects. _________________________

(True/False)

4.8/5

(36)

Question 104

You can embed all or part of an Excel worksheet in a PowerPoint slide.

(True/False)

4.8/5

(41)

Question 105

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

(True/False)

4.8/5

(33)

Question 106

You are creating a presentation with highlights from your company's annual report. You want to include a slide that contains a table with a list of your company's branch offices and the number of employees at each location. Instead of manually typing the information in the table, you would like to insert an Access table in your presentation. Now that you have inserted the table, you want to format it to match your presentation style (e.g., using Themed Style 1 - Accent 1). How can you do this?

(Essay)

4.8/5

(39)

Question 107

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

(Multiple Choice)

4.7/5

(32)

Question 108

Which of the following is not a valid file extension for a bitmap graphic?

(Multiple Choice)

4.8/5

(37)

Question 109

You can format a text box by clicking the More button in the ____ group.

(Multiple Choice)

4.7/5

(42)

Question 110

You can animate data makers of the same color individually ____.

(Multiple Choice)

4.7/5

(40)

Question 111

A background that is repeated to fill a background is a(n) ____________________ background.

(Short Answer)

4.9/5

(36)

Question 112

To hold headers in place as you scroll through a worksheet, _____ the panes.

(Multiple Choice)

4.9/5

(41)

Question 113

What appears in the title bar when you mark a workbook as final?

(Multiple Choice)

4.9/5

(31)

Question 114

A(n) ____________________ is usually used to show trends, patterns, and relationships.

(Short Answer)

4.8/5

(35)

Question 115

Excel is integrated with PowerPoint.

(True/False)

4.8/5

(29)

Question 116

To edit or change a linked object, ____.

(Multiple Choice)

4.8/5

(40)

Question 117

You can animate ____ in a chart.

(Multiple Choice)

4.8/5

(35)

Question 118

The Rotate button is in the ____________________ group on the Ribbon.

(Short Answer)

4.8/5

(36)

Question 119

When you enter criteria in a query, you must be aware that criteria are case sensitive, that is, BIO and Bio are not equivalent.

(True/False)

4.8/5

(42)

Question 120

Showing 101 - 120 of 353

You can choose to paste a Word object with or without linking it to the source document.

Which of the following indicates that a graphic is anchored to the nearest paragraph?

You cannot create a direct ____ between Access and PowerPoint when an Access table has been copied into a PowerPoint slide.

A linked object is stored in its source file, not on a presentation slide such as embedded objects. _________________________

You can embed all or part of an Excel worksheet in a PowerPoint slide.

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

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

Which of the following is not a valid file extension for a bitmap graphic?

You can format a text box by clicking the More button in the ____ group.

You can animate data makers of the same color individually ____.

A background that is repeated to fill a background is a(n) ____________________ background.

To hold headers in place as you scroll through a worksheet, _____ the panes.

What appears in the title bar when you mark a workbook as final?

A(n) ____________________ is usually used to show trends, patterns, and relationships.

Excel is integrated with PowerPoint.

To edit or change a linked object, ____.

You can animate ____ in a chart.

The Rotate button is in the ____________________ group on the Ribbon.

When you enter criteria in a query, you must be aware that criteria are case sensitive, that is, BIO and Bio are not equivalent.

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 choose to paste a Word object with or without linking it to the source document.​

Which of the following indicates that a graphic is anchored to the nearest paragraph?

You cannot create a direct ____ between Access and PowerPoint when an Access table has been copied into a PowerPoint slide.

A linked object is stored in its source file, not on a presentation slide such as embedded objects. _________________________

You can embed all or part of an Excel worksheet in a PowerPoint slide.​

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

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

Which of the following is not a valid file extension for a bitmap graphic?

You can format a text box by clicking the More button in the ____ group.

You can animate data makers of the same color individually ____.

A background that is repeated to fill a background is a(n) ____________________ background.

To hold headers in place as you scroll through a worksheet, _____ the panes.​

What appears in the title bar when you mark a workbook as final?

A(n) ____________________ is usually used to show trends, patterns, and relationships.

Excel is integrated with PowerPoint.

To edit or change a linked object, ____.

You can animate ____ in a chart.

The Rotate button is in the ____________________ group on the Ribbon.

When you enter criteria in a query, you must be aware that criteria are case sensitive, that is, BIO and Bio are not equivalent.​

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 choose to paste a Word object with or without linking it to the source document.

You can embed all or part of an Excel worksheet in a PowerPoint slide.

To hold headers in place as you scroll through a worksheet, _____ the panes.

When you enter criteria in a query, you must be aware that criteria are case sensitive, that is, BIO and Bio are not equivalent.