Question 1

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

Accepted Answer

The answer of ____________________ spacing is the space before and...

Question 2

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

Accepted Answer

A)  record 
B)  table 
C)  link 
D)  foreign

Question 3

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?

Accepted Answer

A)  First line indent marker. 
B)  Left indent marker. 
C)  Right indent marker. 
D)  Hanging indent marker.

Question 4

In Access, Word Merge is on the ____ tab.

Accepted Answer

A)  Mail 
B)  Merge 
C)  Mail Merge 
D)  External Data

Question 5

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

Accepted Answer

The answer of To open the Formula dialog box, click...

Question 6

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

Accepted Answer

A)  Animate 
B)  Trigger 
C)  Start 
D)  Delay

Question 7

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

Accepted Answer

A) Merge 
B) Data 
C) Alignment 
D) Table

Question 8

Which of the following is NOT true about field properties?

Accepted Answer

A)  Modifying them helps ensure database accuracy. 
B)  Some are required, and some are optional. 
C)  They are the same for each data type. 
D)  They can be used to change the way data is displayed.

Question 9

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.)

Accepted Answer

The answer of You manage the Sales department of a...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  =SUM(A1:A4) 
B)  =(A1-A4) 
C)  =SUM(A1-A4) 
D)  =(A1:A4)

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)  Format 
B)  Input Mask 
C)  Caption 
D)  Validation Rule

Question 15

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

Accepted Answer

A)  Field Size 
B)  Format 
C)  Input Mask 
D)  Validation Rule

Question 16

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

Accepted Answer

The answer of An Access report that you export to...

Question 17

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

Accepted Answer

A)  Excel 
B)  PowerPoint 
C)  Outlook 
D)  Access

Question 18

The Input Mask property contains how many parts?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4

Question 19

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

Accepted Answer

A)  Key fields are defined for each table. 
B)  One-to-many relationships are defined for each table. 
C)  There are multiple tables in the database. 
D)  There is redundant data in one or more tables.

Question 20

A custom slide layout is created in Slide Master view.

Accepted Answer

A) True 
 B)False

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.

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.

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 . ____________________