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.

(True/False)

4.7/5

(35)

Question 21

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

(Multiple Choice)

4.9/5

(38)

Question 22

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

(Multiple Choice)

5.0/5

(39)

Question 23

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

(Multiple Choice)

4.7/5

(40)

Question 24

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

(True/False)

4.7/5

(35)

Question 25

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

(Multiple Choice)

4.7/5

(32)

Question 26

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

(Short Answer)

4.9/5

(44)

Question 27

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

(True/False)

4.8/5

(35)

Question 28

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

(Multiple Choice)

4.8/5

(32)

Question 29

Data can be consolidated from different workbooks in one worksheet.

(True/False)

4.8/5

(29)

Question 30

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.

(Short Answer)

4.8/5

(33)

Question 31

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

(True/False)

4.8/5

(31)

Question 32

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?

(Essay)

4.9/5

(27)

Question 33

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

(True/False)

4.8/5

(29)

Question 34

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

(True/False)

4.8/5

(28)

Question 35

Bent connector lines are referred to as elbows.

(True/False)

4.9/5

(35)

Question 36

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

(Multiple Choice)

4.7/5

(31)

Question 37

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

(True/False)

4.9/5

(35)

Question 38

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

(True/False)

4.9/5

(27)

Question 39

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

(True/False)

4.9/5

(37)

Question 40

Showing 21 - 40 of 321

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

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

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

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

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