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

____________________ spacing is the space before and after paragraphs (bullet levels).

(Short Answer)

4.9/5

(34)

Question 61

The ____ key field is the linking field on the "many" side of the relationship.

(Multiple Choice)

4.8/5

(33)

Question 62

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. Which of the following should John move in order to change the space between the bullet and text in an indent level?

(Multiple Choice)

4.9/5

(36)

Question 63

In Access, Word Merge is on the ____ tab.

(Multiple Choice)

4.8/5

(37)

Question 64

To open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.

(Short Answer)

4.7/5

(31)

Question 65

To set an animation to run after you click another object, click the ____ button in the Advanced Animation group.

(Multiple Choice)

4.8/5

(32)

Question 66

When you want to wrap text around a table, you click the Properties command in the _____ group on the Table Tools Layout tab.

(Multiple Choice)

4.7/5

(41)

Question 67

Which of the following is NOT true about field properties?

(Multiple Choice)

4.7/5

(37)

Question 68

You manage the Sales department of a company that has four salespeople. You are creating a table that summarizes the company's sales to send to your manager. The sales for the 1st quarter for P. Burke are in cell B4 and the sales for the 2nd quarter are in cell C4. How can you use the SUM function to calculate the total sales for P. Burke in cell D4? ( Hint : Write the formula.)

(Essay)

4.9/5

(40)

Question 69

When you copy and paste a column within a table, the column is inserted to the left of the column containing the insertion point. ____________________

(True/False)

4.8/5

(34)

Question 70

The Input Mask property provides a pattern for data to be entered using three parts.

(True/False)

4.9/5

(42)

Question 71

What formula would you use to calculate the total of the values in cells A1 through A4?

(Multiple Choice)

4.9/5

(33)

Question 72

To help organize slides of a presentation into groups, you can create parts . ____________________

(True/False)

4.9/5

(32)

Question 73

(999)000-000;1;_ would be a possible entry for which field property?

(Multiple Choice)

4.9/5

(27)

Question 74

Byte, Long Integer, Single, and Double are examples of entries for which property?

(Multiple Choice)

4.8/5

(41)

Question 75

An Access report that you export to an .rtf file is not linked to the Access ____________________.

(Short Answer)

5.0/5

(30)

Question 76

You can merge a(n) ____ database with a Word letter to produce a series of individually addressed form letters.

(Multiple Choice)

5.0/5

(30)

Question 77

The Input Mask property contains how many parts?

(Multiple Choice)

4.7/5

(32)

Question 78

Which of the following is a clue that a database needs to be redesigned?

(Multiple Choice)

4.9/5

(36)

Question 79

A custom slide layout is created in Slide Master view.

(True/False)

4.9/5

(36)

Question 80

Showing 61 - 80 of 321

____________________ spacing is the space before and after paragraphs (bullet levels).

The ____ key field is the linking field on the "many" side of the relationship.

In Access, Word Merge is on the ____ tab.

To open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.

To set an animation to run after you click another object, click the ____ button in the Advanced Animation group.

When you want to wrap text around a table, you click the Properties command in the _____ group on the Table Tools Layout tab.

Which of the following is NOT true about field properties?

When you copy and paste a column within a table, the column is inserted to the left of the column containing the insertion point. ____________________

The Input Mask property provides a pattern for data to be entered using three parts.

What formula would you use to calculate the total of the values in cells A1 through A4?

To help organize slides of a presentation into groups, you can create parts . ____________________

(999)000-000;1;_ would be a possible entry for which field property?

Byte, Long Integer, Single, and Double are examples of entries for which property?

An Access report that you export to an .rtf file is not linked to the Access ____________________.

You can merge a(n) ____ database with a Word letter to produce a series of individually addressed form letters.

The Input Mask property contains how many parts?

Which of the following is a clue that a database needs to be redesigned?

A custom slide layout is created in Slide Master view.

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

____________________ spacing is the space before and after paragraphs (bullet levels).

The ____ key field is the linking field on the "many" side of the relationship.

In Access, Word Merge is on the ____ tab.

To open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.​

To set an animation to run after you click another object, click the ____ button in the Advanced Animation group.

When you want to wrap text around a table, you click the Properties command in the _____ group on the Table Tools Layout tab.​

Which of the following is NOT true about field properties?

When you copy and paste a column within a table, the column is inserted to the left of the column containing the insertion point.​ ____________________

The Input Mask property provides a pattern for data to be entered using three parts.

What formula would you use to calculate the total of the values in cells A1 through A4?

To help organize slides of a presentation into groups, you can create parts .​ ____________________

(999)000-000;1;_ would be a possible entry for which field property?

Byte, Long Integer, Single, and Double are examples of entries for which property?

An Access report that you export to an .rtf file is not linked to the Access ____________________.

You can merge a(n) ____ database with a Word letter to produce a series of individually addressed form letters.

The Input Mask property contains how many parts?

Which of the following is a clue that a database needs to be redesigned?

A custom slide layout is created in Slide Master view.

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 open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.

When you want to wrap text around a table, you click the Properties command in the _____ group on the Table Tools Layout tab.

When you copy and paste a column within a table, the column is inserted to the left of the column containing the insertion point. ____________________

To help organize slides of a presentation into groups, you can create parts . ____________________