Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  indexes 
B)  tables 
C)  links 
D)  properties

Question 3

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.

Accepted Answer

A) Table Tools Layout 
B) Data 
C) Insert 
D) Home

Question 4

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

Accepted Answer

A)  range 
B)  location 
C)  scope 
D)  definition

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  scrubbing the database 
B)  enforcing rules 
C)  applying syntax 
D)  adding criteria

Question 7

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?

Accepted Answer

A)  In the Edit Master group. 
B)  In the Edit Layouts group. 
C)  In the Slide Master group. 
D)  In the Rename group.

Question 8

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.

Accepted Answer

A)  Merge All 
B)  Merge it 
C)  Combine Access and Word 
D)  Merge it with Microsoft Office Word

Question 9

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

Accepted Answer

The answer of The position of each indent level on...

Question 10

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

Accepted Answer

A)  Import Text to Table 
B) Convert Text to Table 
C) Import Text 
D) Change Text to Table

Question 11

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

Accepted Answer

A)  formula 
B)  cell reference 
C)  function 
D)  argument

Question 12

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

Accepted Answer

A)  primary 
B)  first 
C)  foreign 
D)  infinity

Question 13

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

Accepted Answer

A)  Format 
B)  Default Value 
C)  Validation Rule 
D)  Input Mask

Question 14

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.

Accepted Answer

A)  in Rich Text Format 
B)  as a JPEG 
C)  in .accdb format 
D)  in HTML format

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  #NAME? 
B)  #VAL 
C)  #NONE 
D)  #NA

Question 17

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.

Accepted Answer

The answer of Jake wants to build a formula that...

Question 18

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

Accepted Answer

A)  3-D 
B)  Mirror 
C)  Backstage 
D)  Stage

Question 19

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.

Accepted Answer

A)  Simple Query Wizard 
B)  Advanced Query Wizard 
C)  Merge Query Wizard 
D)  Word Query Wizard

Question 20

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

Accepted Answer

A) Insert 
B) Layout 
C)  Home 
D) Design

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.

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