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

The Validation Rule property is not used with Text or Date/Time fields.

(True/False)

5.0/5

(41)

Question 141

The IFERROR function is used to look for spelling errors in Excel.

(True/False)

4.8/5

(29)

Question 142

Use the ____________________ function to quickly total the numbers in a column or row.

(Short Answer)

4.8/5

(28)

Question 143

Each animated object on a slide has a starting time in relation to other animated objects.

(True/False)

4.9/5

(33)

Question 144

Pressing [Enter] moves the insertion point to the next cell in the row.

(True/False)

4.8/5

(43)

Question 145

If there are invalid cell references in a formula, the error value #REF! will display in the cell.

(True/False)

4.8/5

(35)

Question 146

How do you insert multiple rows at the same time?

(Multiple Choice)

4.7/5

(27)

Question 147

To reroute a connector to the closest points between shapes, right-click the connector, then click Change Connectors on the shortcut menu. ____________________

(True/False)

4.9/5

(38)

Question 148

How can you animate objects in PowerPoint?

(Essay)

4.9/5

(37)

Question 149

Use the ____________________ tool to create a free-form curved line.

(Short Answer)

4.8/5

(33)

Question 150

Which Short Text field property should you use to specify whether an entry was required for the field?

(Multiple Choice)

4.8/5

(38)

Question 151

When you want to include an Access table in a Word document, you first export it to a document that is saved in ____________________ Format.

(Short Answer)

4.7/5

(40)

Question 152

Field descriptions may be entered in Table Design View. _________________________

(True/False)

4.9/5

(31)

Question 153

To reset a bullet to the default symbol, click ____________________ in the Bullets and Numbering dialog box.

(Short Answer)

4.8/5

(34)

Question 154

What happens when you click the table move handle?

(Multiple Choice)

4.8/5

(38)

Question 155

You can use the Caption tab in the Table Properties dialog box to add alternative test for a table that will appear on a Web page.

(True/False)

4.7/5

(35)

Question 156

Which Excel function totals only the cells in a range that meet given criteria?

(Multiple Choice)

4.9/5

(35)

Question 157

The "one" field of a one-to-many relationship is never the primary key field in the table on the "one" side of the relationship.

(True/False)

4.8/5

(36)

Question 158

Locking the drawing mode of a shape allows you to draw the same shape multiple times without having to reselect the shape button in the Shapes Gallery each time. _________________________

(True/False)

4.8/5

(32)

Question 159

The ____________________ function contains three parts: a condition or logical test, an action to take if the condition is true, and an action to take if the condition is false.

(Short Answer)

4.9/5

(33)

Question 160

Showing 141 - 160 of 321

The Validation Rule property is not used with Text or Date/Time fields.

The IFERROR function is used to look for spelling errors in Excel.

Use the ____________________ function to quickly total the numbers in a column or row.

Each animated object on a slide has a starting time in relation to other animated objects.

Pressing [Enter] moves the insertion point to the next cell in the row.

If there are invalid cell references in a formula, the error value #REF! will display in the cell.

How do you insert multiple rows at the same time?

To reroute a connector to the closest points between shapes, right-click the connector, then click Change Connectors on the shortcut menu. ____________________

How can you animate objects in PowerPoint?

Use the ____________________ tool to create a free-form curved line.

Which Short Text field property should you use to specify whether an entry was required for the field?

When you want to include an Access table in a Word document, you first export it to a document that is saved in ____________________ Format.

Field descriptions may be entered in Table Design View. _________________________

To reset a bullet to the default symbol, click ____________________ in the Bullets and Numbering dialog box.

What happens when you click the table move handle?

You can use the Caption tab in the Table Properties dialog box to add alternative test for a table that will appear on a Web page.

Which Excel function totals only the cells in a range that meet given criteria?

The "one" field of a one-to-many relationship is never the primary key field in the table on the "one" side of the relationship.

Locking the drawing mode of a shape allows you to draw the same shape multiple times without having to reselect the shape button in the Shapes Gallery each time. _________________________

The ____________________ function contains three parts: a condition or logical test, an action to take if the condition is true, and an action to take if the condition 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

The Validation Rule property is not used with Text or Date/Time fields.

The IFERROR function is used to look for spelling errors in Excel.

Use the ____________________ function to quickly total the numbers in a column or row.

Each animated object on a slide has a starting time in relation to other animated objects.​

Pressing [Enter] moves the insertion point to the next cell in the row.

If there are invalid cell references in a formula, the error value #REF! will display in the cell.

How do you insert multiple rows at the same time?

To reroute a connector to the closest points between shapes, right-click the connector, then click Change Connectors on the shortcut menu.​ ____________________

How can you animate objects in PowerPoint?

Use the ____________________ tool to create a free-form curved line.

Which Short Text field property should you use to specify whether an entry was required for the field?

When you want to include an Access table in a Word document, you first export it to a document that is saved in ____________________ Format.

Field descriptions may be entered in Table Design View. _________________________

To reset a bullet to the default symbol, click ____________________ in the Bullets and Numbering dialog box.​

What happens when you click the table move handle?

You can use the Caption tab in the Table Properties dialog box to add alternative​ test for a table that will appear on a Web page.

Which Excel function totals only the cells in a range that meet given criteria?

The "one" field of a one-to-many relationship is never the primary key field in the table on the "one" side of the relationship.

Locking the drawing mode of a shape allows you to draw the same shape multiple times without having to reselect the shape button in the Shapes Gallery each time. _________________________

The ____________________ function contains three parts: a condition or logical test, an action to take if the condition is true, and an action to take if the condition 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

Each animated object on a slide has a starting time in relation to other animated objects.

To reroute a connector to the closest points between shapes, right-click the connector, then click Change Connectors on the shortcut menu. ____________________

To reset a bullet to the default symbol, click ____________________ in the Bullets and Numbering dialog box.

You can use the Caption tab in the Table Properties dialog box to add alternative test for a table that will appear on a Web page.