Question 1

Symbols, such as less than ( ), and equal to (=), are all examples of comparison operators.

Accepted Answer

A) True 
 B)False

Question 2

Which key is used to update the field result of a calculation?

Accepted Answer

A)  [F6] 
B)  [F9] 
C)  [F4] 
D)  [F3]

Question 3

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.

Accepted Answer

A)  Validation Rule 
B)  Description Rule 
C)  Input Mask 
D)  Validation Text

Question 4

How do you center the text vertically in each table cell?

Accepted Answer

A)  Select the table and click the Center button in the Paragraph group on the Home tab. 
B)  Click the Select button in the Table group, click Select Table, then click the Align Center Left button in the Alignment group. 
C)  Select the table and click the Distribute Columns button. 
D)  Select the table and click the AutoFit button.

Question 5

The AND function returns a value of TRUE if every logical test in the formula is true.

Accepted Answer

A) True 
 B)False

Question 6

Straight, elbow, and curved are all types of ____.

Accepted Answer

A)  connectors 
B)  templates 
C)  placeholders 
D)  shapes

Question 7

After you name a cell or range, you can define its ____________________, or the worksheets where you will be able to use it.

Accepted Answer

The answer of After you name a cell or range,...

Question 8

The lines that divide columns and rows in a table are called borders . _________________________

Accepted Answer

A) True 
 B)False

Question 9

A(n) ____ is a box formed by the intersection of a column and a row.

Accepted Answer

A)  divider 
B)  table 
C)  cell 
D)  border

Question 10

Data can be consolidated from different workbooks in one worksheet.

Accepted Answer

A) True 
 B)False

Question 11

A(n) ____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

Accepted Answer

The answer of A(n) ____________________ record is a record in...

Question 12

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Accepted Answer

A) True 
 B)False

Question 13

You own an extensive DVD collection that you have cataloged in an Access database. You want to create a Word document with a list of the DVDs you own that contain movies directed by Steven Spielberg. You want your end result to be a table in Word. 
You just finished exporting your Access table. Which file format did you use?

Accepted Answer

The answer of You own an extensive DVD collection that...

Question 14

When you select a row, you must also select the end of row mark for the row to be selected.

Accepted Answer

A) True 
 B)False

Question 15

You can convert text that is sep arated by a comma into a table.​

Accepted Answer

A) True 
 B)False

Question 16

Bent connector lines are referred to as elbows.

Accepted Answer

A) True 
 B)False

Question 17

The Split Cells command appears in the ____ group on the Table Tools Layout tab.

Accepted Answer

A)  Rows & Columns 
B)  Cell Size 
C)  Merge 
D)  Split

Question 18

Cell and range names can use uppercase and lowercase letters, digits, and spaces.

Accepted Answer

A) True 
 B)False

Question 19

When a Caption property is not entered, the field name is used to label the field.

Accepted Answer

A) True 
 B)False

Question 20

If the formula, =IF(B3>B1,5,0) is entered in cell C3,​ the value 0 will be stored in cell C3 if the logical test is false. ____________________

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

Symbols, such as less than ( ), and equal to (=), are all examples of comparison operators.

Which key is used to update the field result of a calculation?

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.

How do you center the text vertically in each table cell?

The AND function returns a value of TRUE if every logical test in the formula is true.

Straight, elbow, and curved are all types of ____.

After you name a cell or range, you can define its ____________________, or the worksheets where you will be able to use it.

The lines that divide columns and rows in a table are called borders . _________________________

A(n) ____ is a box formed by the intersection of a column and a row.

Data can be consolidated from different workbooks in one worksheet.

A(n) ____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

When you select a row, you must also select the end of row mark for the row to be selected.

You can convert text that is sep arated by a comma into a table.

Bent connector lines are referred to as elbows.

The Split Cells command appears in the ____ group on the Table Tools Layout tab.

Cell and range names can use uppercase and lowercase letters, digits, and spaces.

When a Caption property is not entered, the field name is used to label the field.

If the formula, =IF(B3>B1,5,0) is entered in cell C3, the value 0 will be stored in cell C3 if the logical test is false. ____________________

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

Symbols, such as less than ( ), and equal to (=), are all examples of comparison operators.

Which key is used to update the field result of a calculation?

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.

How do you center the text vertically in each table cell?

The AND function returns a value of TRUE if every logical test in the formula is true.

Straight, elbow, and curved are all types of ____.

After you name a cell or range, you can define its ____________________, or the worksheets where you will be able to use it.

The lines that divide columns and rows in a table are called borders . _________________________

A(n) ____ is a box formed by the intersection of a column and a row.

Data can be consolidated from different workbooks in one worksheet.

A(n) ____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

When you select a row, you must also select the end of row mark for the row to be selected.

You can convert text that is sep arated by a comma into a table.​

Bent connector lines are referred to as elbows.

The Split Cells command appears in the ____ group on the Table Tools Layout tab.

Cell and range names can use uppercase and lowercase letters, digits, and spaces.

When a Caption property is not entered, the field name is used to label the field.

If the formula, =IF(B3>B1,5,0) is entered in cell C3,​ the value 0 will be stored in cell C3 if the logical test is false. ____________________

You can convert text that is sep arated by a comma into a table.

If the formula, =IF(B3>B1,5,0) is entered in cell C3, the value 0 will be stored in cell C3 if the logical test is false. ____________________