Exam 5: Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

The . J pg file extension is short for JPEG , an acronym for the Joint Photographic Experts Group. _________________________

(True/False)

4.8/5

(36)

Question 121

If a value in a formula is not available, the error value #VALUE! will display in the cell.

(True/False)

4.8/5

(29)

Question 122

When you export an Access report to Word, the document is formatted with [Tab] characters that separate the data columns.

(True/False)

4.8/5

(36)

Question 123

In Access, you can open the Export - RTF File dialog box by first clicking the ____________________ tab, then the More button, and then Word.

(Short Answer)

4.7/5

(29)

Question 124

Define the following terms: indent levels, indent markers, and tab selector. Name and briefly describe the four tab options (hint: One tab option is a Decimal-aligned tab).

(Essay)

5.0/5

(35)

Question 125

The Query Wizard button opens the ____.

(Multiple Choice)

4.8/5

(29)

Question 126

The goal of building one-to-many relationships between tables is to minimize ____ data.

(Multiple Choice)

4.8/5

(25)

Question 127

A subdatasheet is used to modify field properties.

(True/False)

4.8/5

(29)

Question 128

You can only use the Draw pointer and Erase pointer to change the structure of a table you draw from scratch.

(True/False)

4.8/5

(37)

Question 129

To turn gridlines off or on, you should click the View Gridlines button in the ____ group on the Table Tools Layout tab.

(Multiple Choice)

4.7/5

(35)

Question 130

You can rename a slide master by clicking Rename in the ____ group.

(Multiple Choice)

4.8/5

(40)

Question 131

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

(True/False)

4.7/5

(34)

Question 132

Custom slide layouts are created in ____ view.

(Multiple Choice)

4.9/5

(33)

Question 133

The Shading list arrow is in the ____ group.

(Multiple Choice)

4.9/5

(35)

Question 134

To convert an Access report to a Word table,use the Convert Text to Table command in the _____ group.

(Multiple Choice)

4.9/5

(30)

Question 135

When you ____ a cell, you combine adjacent cells into a single larger cell.

(Multiple Choice)

4.7/5

(33)

Question 136

Press the ____________________ key to add an absolute reference symbol ($) to a formula.

(Short Answer)

4.9/5

(33)

Question 137

A custom slide layout has eight different ____ to choose from.

(Multiple Choice)

4.9/5

(27)

Question 138

Linking to a workbook means that any changes to the original values are automatically reflected in the consolidation sheet as well.

(True/False)

4.7/5

(31)

Question 139

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2017 as: ____.

(Multiple Choice)

4.8/5

(39)

Question 140

Showing 121 - 140 of 321

The . J pg file extension is short for JPEG , an acronym for the Joint Photographic Experts Group. _________________________

If a value in a formula is not available, the error value #VALUE! will display in the cell.

When you export an Access report to Word, the document is formatted with [Tab] characters that separate the data columns.

In Access, you can open the Export - RTF File dialog box by first clicking the ____________________ tab, then the More button, and then Word.

Define the following terms: indent levels, indent markers, and tab selector. Name and briefly describe the four tab options (hint: One tab option is a Decimal-aligned tab).

The Query Wizard button opens the ____.

The goal of building one-to-many relationships between tables is to minimize ____ data.

A subdatasheet is used to modify field properties.

You can only use the Draw pointer and Erase pointer to change the structure of a table you draw from scratch.

To turn gridlines off or on, you should click the View Gridlines button in the ____ group on the Table Tools Layout tab.

You can rename a slide master by clicking Rename in the ____ group.

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

Custom slide layouts are created in ____ view.

The Shading list arrow is in the ____ group.

To convert an Access report to a Word table,use the Convert Text to Table command in the _____ group.

When you ____ a cell, you combine adjacent cells into a single larger cell.

Press the ____________________ key to add an absolute reference symbol ($) to a formula.

A custom slide layout has eight different ____ to choose from.

Linking to a workbook means that any changes to the original values are automatically reflected in the consolidation sheet as well.

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2017 as: ____.

Module 4: Integrating Word and Excel Access

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

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 5: Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

The . J pg file extension is short for JPEG , an acronym for the Joint Photographic Experts Group. _________________________

If a value in a formula is not available, the error value #VALUE! will display in the cell.

When you export an Access report to Word, the document is formatted with [Tab] characters that separate the data columns.​

In Access, you can open the Export - RTF File dialog box by first clicking the ____________________ tab, then the More button, and then Word.

Define the following terms: indent levels, indent markers, and tab selector. Name and briefly describe the four tab options (hint: One tab option is a Decimal-aligned tab).

The Query Wizard button opens the ____.

The goal of building one-to-many relationships between tables is to minimize ____ data.

A subdatasheet is used to modify field properties.

You can only use the Draw pointer and Erase pointer to change the structure of a table you draw from scratch.​

To turn gridlines off or on, you should click the View Gridlines button in the ____ group on the Table Tools Layout tab.

You can rename a slide master by clicking Rename in the ____ group.

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

Custom slide layouts are created in ____ view.

The Shading list arrow is in the ____ group.

To convert an Access report to a Word table,use the Convert Text to Table command in the _____ group.

When you ____ a cell, you combine adjacent cells into a single larger cell.

Press the ____________________ key to add an absolute reference symbol ($) to a formula.

A custom slide layout has eight different ____ to choose from.

Linking to a workbook means that any changes to the original values are automatically reflected in the consolidation sheet as well.

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2017 as: ____.

Module 4: Integrating Word and Excel Access

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

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

When you export an Access report to Word, the document is formatted with [Tab] characters that separate the data columns.

You can only use the Draw pointer and Erase pointer to change the structure of a table you draw from scratch.