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

Which Excel function averages cells in a range based on a specified condition?

(Multiple Choice)

4.8/5

(39)

Question 261

The lines that divide the columns and rows in a table are called ____.

(Multiple Choice)

4.9/5

(32)

Question 262

When you change a bullet type, you can use a(n) ____.

(Multiple Choice)

4.8/5

(32)

Question 263

You cannot create columns within a text object. ____________________

(True/False)

4.8/5

(33)

Question 264

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: You decide to combine Print and Misc. into one cell. How can you do this?

(Essay)

4.7/5

(35)

Question 265

Which of the following is NOT shown on a Relationship report?

(Multiple Choice)

4.9/5

(31)

Question 266

To avoid a circular reference, you can enable the iteration feature. ____________________

(True/False)

4.7/5

(38)

Question 267

Describe two examples of why you would need to use the PMT function.

(Essay)

4.9/5

(38)

Question 268

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

(Multiple Choice)

4.7/5

(29)

Question 269

A linked IF function contains IF functions inside other IF functions. ____________________

(True/False)

4.8/5

(36)

Question 270

When sorting text information in a document, the term " fields " refers to text or numbers that are separated by a character, such as a tab or comma. ____________________

(True/False)

4.9/5

(36)

Question 271

If you want to quickly make all the columns in a table the same width, which command do you use?

(Multiple Choice)

4.9/5

(39)

Question 272

If the value in cell A1 is 10 and the value in cell B1 is 20, the formula, =OR(A1>5,B1>25) will return a result of TRUE . ____________________

(True/False)

4.8/5

(44)

Question 273

In Access, the Report Wizard button appears in the ____ tab.

(Multiple Choice)

4.9/5

(40)

Question 274

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.

(Multiple Choice)

4.9/5

(36)

Question 275

You can modify the Field Size property of a Short Text field. _________________________

(True/False)

4.8/5

(41)

Question 276

You should use the ____________________ function to reverse the value of an argument.

(Short Answer)

4.8/5

(36)

Question 277

A field that contains unique information for each record is called a(n) ____ field.

(Multiple Choice)

4.9/5

(34)

Question 278

To move a field list in the Relationships window, drag the table's primary key field . _________________________

(True/False)

4.9/5

(39)

Question 279

The symbol stands for "equal to."

(True/False)

4.8/5

(23)

Question 280

Showing 261 - 280 of 321

Which Excel function averages cells in a range based on a specified condition?

The lines that divide the columns and rows in a table are called ____.

When you change a bullet type, you can use a(n) ____.

You cannot create columns within a text object. ____________________

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: You decide to combine Print and Misc. into one cell. How can you do this?

Which of the following is NOT shown on a Relationship report?

To avoid a circular reference, you can enable the iteration feature. ____________________

Describe two examples of why you would need to use the PMT function.

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

A linked IF function contains IF functions inside other IF functions. ____________________

When sorting text information in a document, the term " fields " refers to text or numbers that are separated by a character, such as a tab or comma. ____________________

If you want to quickly make all the columns in a table the same width, which command do you use?

If the value in cell A1 is 10 and the value in cell B1 is 20, the formula, =OR(A1>5,B1>25) will return a result of TRUE . ____________________

In Access, the Report Wizard button appears in the ____ tab.

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.

You can modify the Field Size property of a Short Text field. _________________________

You should use the ____________________ function to reverse the value of an argument.

A field that contains unique information for each record is called a(n) ____ field.

To move a field list in the Relationships window, drag the table's primary key field . _________________________

The symbol stands for "equal to."

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

Which Excel function averages cells in a range based on a specified condition?

The lines that divide the columns and rows in a table are called ____.

When you change a bullet type, you can use a(n) ____.

You cannot create columns within a text object.​ ____________________

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: You decide to combine Print and Misc. into one cell. How can you do this?

Which of the following is NOT shown on a Relationship report?

To avoid a circular reference, you can enable the iteration feature​. ____________________

Describe two examples of why you would need to use the PMT function.

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

A linked IF function contains IF functions inside other IF functions.​ ____________________

When sorting text information in a document, the term " fields " refers to text or numbers that are separated by a character, such as a tab or comma. ____________________​

If you want to quickly make all the columns in a table the same width, which command do you use?

If the value in cell A1 is 10 and the value in cell B1 is 20, the formula, =OR(A1>5,B1>25) will return a result of TRUE . ____________________

In Access, the Report Wizard button appears in the ____ tab.

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.​

You can modify the Field Size property of a Short Text field. _________________________

You should use the ____________________ function to reverse the value of an argument.

A field that contains unique information for each record is called a(n) ____ field.

To move a field list in the Relationships window, drag the table's primary key field . _________________________

The symbol stands for "equal to."

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 cannot create columns within a text object. ____________________

To avoid a circular reference, you can enable the iteration feature. ____________________

A linked IF function contains IF functions inside other IF functions. ____________________

When sorting text information in a document, the term " fields " refers to text or numbers that are separated by a character, such as a tab or comma. ____________________

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.