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

When used in formulas, names become ____ cell references by default.

Free

(Multiple Choice)

4.7/5

(41)

Question 1

Correct Answer:

Verified

Pressing ____ at the end of a row moves the insertion point to the first cell in the next row.

Free

(Multiple Choice)

4.9/5

(30)

Question 2

Correct Answer:

Verified

You can access the Lookup properties from either Table Datasheet View or Table Design View.

Free

(True/False)

4.9/5

(37)

Question 3

Correct Answer:

Verified

False

The _____ function replaces text in a text string.

(Multiple Choice)

4.8/5

(39)

Question 4

Which Excel feature is used to break a data field into separate columns?

(Multiple Choice)

4.7/5

(34)

Question 5

To autofit the contents of a table, click the AutoFit button on the _____ tab.

(Multiple Choice)

4.8/5

(33)

Question 6

Describe three ways to resize columns and rows in a table.

(Essay)

4.9/5

(42)

Question 7

Connector tools can be lines or arrows.

(True/False)

5.0/5

(30)

Question 8

A(n) template usually contains a cohesive set of theme colors, theme fonts, theme effects, and background styles. _________________________

(True/False)

4.8/5

(37)

Question 9

The ____________________ Text to Columns feature breaks data fields in one column into separate columns.

(Short Answer)

4.7/5

(31)

Question 10

Explain how the SUMIF function works. Use an example.

(Essay)

4.9/5

(36)

Question 11

You copy and move rows and columns differently than you copy and move text.

(True/False)

4.8/5

(27)

Question 12

Which text function capitalizes the first letter in a string of text?

(Multiple Choice)

4.8/5

(33)

Question 13

Use the ____________________ Table menu command to create a complex table by drawing the table columns and rows.

(Short Answer)

4.8/5

(30)

Question 14

In the cell entry, =[Product.xlsx]Sales!$C$7, [Product.xlsx] refers to the ____.

(Multiple Choice)

4.7/5

(37)

Question 15

A ____ indent occurs when the first line of text begins to the left of a subsequent line of text.

(Multiple Choice)

4.8/5

(45)

Question 16

Which of the following is NOT a principle of relational database design?

(Multiple Choice)

4.9/5

(32)

Question 17

The Finish & Merge button is located in the Finish group on the _____ tab.

(Multiple Choice)

4.9/5

(40)

Question 18

A good Field Size property value for a state abbreviation field is ____.

(Multiple Choice)

4.8/5

(39)

Question 19

To toggle between showing and hiding comments, click the Show Comments list arrow, then click the ____ button

(Multiple Choice)

4.8/5

(29)

Question 20

Showing 1 - 20 of 321

When used in formulas, names become ____ cell references by default.

Pressing ____ at the end of a row moves the insertion point to the first cell in the next row.

You can access the Lookup properties from either Table Datasheet View or Table Design View.

The _____ function replaces text in a text string.

Which Excel feature is used to break a data field into separate columns?

To autofit the contents of a table, click the AutoFit button on the _____ tab.

Describe three ways to resize columns and rows in a table.

Connector tools can be lines or arrows.

A(n) template usually contains a cohesive set of theme colors, theme fonts, theme effects, and background styles. _________________________

The ____________________ Text to Columns feature breaks data fields in one column into separate columns.

Explain how the SUMIF function works. Use an example.

You copy and move rows and columns differently than you copy and move text.

Which text function capitalizes the first letter in a string of text?

Use the ____________________ Table menu command to create a complex table by drawing the table columns and rows.

In the cell entry, =[Product.xlsx]Sales!$C$7, [Product.xlsx] refers to the ____.

A ____ indent occurs when the first line of text begins to the left of a subsequent line of text.

Which of the following is NOT a principle of relational database design?

The Finish & Merge button is located in the Finish group on the _____ tab.

A good Field Size property value for a state abbreviation field is ____.

To toggle between showing and hiding comments, click the Show Comments list arrow, then click the ____ button

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

When used in formulas, names become ____ cell references by default.

Pressing ____ at the end of a row moves the insertion point to the first cell in the next row.

You can access the Lookup properties from either Table Datasheet View or Table Design View.​

The _____ function replaces text in a text string.​

Which Excel feature is used to break a data field into separate columns?

To autofit the contents of a table, click the AutoFit button on the _____ tab.​

Describe three ways to resize columns and rows in a table.

Connector tools can be lines or arrows.

A(n) template usually contains a cohesive set of theme colors, theme fonts, theme effects, and background styles. _________________________

The ____________________ Text to Columns feature breaks data fields in one column into separate columns.

Explain how the SUMIF function works. Use an example.

You copy and move rows and columns differently than you copy and move text.​

Which text function capitalizes the first letter in a string of text?

Use the ____________________ Table menu command to create a complex table by drawing the table columns and rows.

In the cell entry, =[Product.xlsx]Sales!$C$7, [Product.xlsx] refers to the ____.

A ____ indent occurs when the first line of text begins to the left of a subsequent line of text.

Which of the following is NOT a principle of relational database design?

The Finish & Merge button is located in the Finish group on the _____ tab.

A good Field Size property value for a state abbreviation field is ____.

To toggle between showing and hiding comments, click the Show Comments list arrow, then click the ____ button

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 access the Lookup properties from either Table Datasheet View or Table Design View.

The _____ function replaces text in a text string.

To autofit the contents of a table, click the AutoFit button on the _____ tab.

You copy and move rows and columns differently than you copy and move text.