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

Modifying the Decimal Places property changes the way the data is presented.

(True/False)

4.9/5

(36)

Question 81

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

(Multiple Choice)

4.9/5

(38)

Question 82

You can convert a table to text that is separated by tabs, by selecting the table, clicking the_____ tab, and then clicking the Convert to Text button.

(Multiple Choice)

4.9/5

(34)

Question 83

The ____ refers to where you will be able to use a named cell or range in worksheets.

(Multiple Choice)

4.9/5

(26)

Question 84

When you merge data from an Access database with a Word document, the document opens with the Mail Merge task pane open.

(True/False)

4.8/5

(35)

Question 85

The process of removing and fixing orphan records is often called ____.

(Multiple Choice)

4.8/5

(43)

Question 86

Case-Based Critical Thinking Question John is using PowerPoint to create an extensive marketing presentation and he keeps modifying the same slide layout by adding new placeholders for pictures and adjusting the text indents in the content placeholder. John wants to modify his presentation so he can work more efficiently. John wants to rename the new master, Marketing. Where can he find the Rename button?

(Multiple Choice)

5.0/5

(38)

Question 87

When merging from Access to Word, you can initiate the merge process directly from Access by using the ____ feature to merge data contained in an Access query datasheet with a Word document.

(Multiple Choice)

4.9/5

(38)

Question 88

The position of each indent level on the ruler is represented by two small triangles and a square called ____________________ markers.

(Short Answer)

4.8/5

(31)

Question 89

To convert text to a table, select the text, click the Table button in the Tables group on the Insert tab, and then click _____.

(Multiple Choice)

4.8/5

(33)

Question 90

The text following an equal sign (=) is a(n) ____.

(Multiple Choice)

4.8/5

(36)

Question 91

A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

(Multiple Choice)

4.7/5

(33)

Question 92

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

(Multiple Choice)

4.7/5

(32)

Question 93

To include Access data in a Word document, you can export a table or a query to a document ____ that you can open in Word.

(Multiple Choice)

4.8/5

(39)

Question 94

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber . _________________________

(True/False)

4.8/5

(33)

Question 95

Which error code will display if a value in a formula is not available?

(Multiple Choice)

4.9/5

(38)

Question 96

Jake wants to build a formula that tells Excel to multiply the value in cell F6 by 10 if cell B5 equals 5; otherwise, a zero should be entered into the cell. Create the formula needed for this calculation.

(Essay)

4.8/5

(37)

Question 97

Cell references that reference other sheets behind the summary sheet are known as ____ references.

(Multiple Choice)

4.8/5

(28)

Question 98

In Access, the ____ is a dialog box where you can select all the fields that you want to include in the table you will merge with a form letter you create in Word.

(Multiple Choice)

4.9/5

(35)

Question 99

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

(Multiple Choice)

4.7/5

(30)

Question 100

Showing 81 - 100 of 321

Modifying the Decimal Places property changes the way the data is presented.

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

You can convert a table to text that is separated by tabs, by selecting the table, clicking the_____ tab, and then clicking the Convert to Text button.

The ____ refers to where you will be able to use a named cell or range in worksheets.

When you merge data from an Access database with a Word document, the document opens with the Mail Merge task pane open.

The process of removing and fixing orphan records is often called ____.

When merging from Access to Word, you can initiate the merge process directly from Access by using the ____ feature to merge data contained in an Access query datasheet with a Word document.

The position of each indent level on the ruler is represented by two small triangles and a square called ____________________ markers.

To convert text to a table, select the text, click the Table button in the Tables group on the Insert tab, and then click _____.

The text following an equal sign (=) is a(n) ____.

A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

To include Access data in a Word document, you can export a table or a query to a document ____ that you can open in Word.

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber . _________________________

Which error code will display if a value in a formula is not available?

Jake wants to build a formula that tells Excel to multiply the value in cell F6 by 10 if cell B5 equals 5; otherwise, a zero should be entered into the cell. Create the formula needed for this calculation.

Cell references that reference other sheets behind the summary sheet are known as ____ references.

In Access, the ____ is a dialog box where you can select all the fields that you want to include in the table you will merge with a form letter you create in Word.

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

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

Modifying the Decimal Places property changes the way the data is presented.

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

You can convert a table to text that is separated by tabs, by selecting the table, clicking the_____ tab, and then clicking the Convert to Text button.

The ____ refers to where you will be able to use a named cell or range in worksheets.

When you merge data from an Access database with a Word document, the document opens with the Mail Merge task pane open.

The process of removing and fixing orphan records is often called ____.

When merging from Access to Word, you can initiate the merge process directly from Access by using the ____ feature to merge data contained in an Access query datasheet with a Word document.

The position of each indent level on the ruler is represented by two small triangles and a square called ____________________ markers.

To convert text to a table, select the text, click the Table button in the Tables group on the Insert tab, and then click _____.​

The text following an equal sign (=) is a(n) ____.

A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

To include Access data in a Word document, you can export a table or a query to a document ____ that you can open in Word.

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber . _________________________

Which error code will display if a value in a formula is not available?

Jake wants to build a formula that tells Excel to multiply the value in cell F6 by 10 if cell B5 equals 5; otherwise, a zero should be entered into the cell. Create the formula needed for this calculation.

Cell references that reference other sheets behind the summary sheet are known as ____ references.

In Access, the ____ is a dialog box where you can select all the fields that you want to include in the table you will merge with a form letter you create in Word.

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

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

To convert text to a table, select the text, click the Table button in the Tables group on the Insert tab, and then click _____.