Question 1

A common example of a text delimiter is ____.

Accepted Answer

A)  , 
B)  = 
C)  + 
D)  ( 
A)  , 
B)  = 
C)  + 
D)  (

Question 2

The simplest way to apply an animation to objects is to use the Format Painter.

Accepted Answer

A) True 
 B)False

Question 3

You can merge data from an Access database containing the names, addresses, and other information about a company's customers, contacts, and suppliers with a letter you create in ____________________ to produce a series of individually addressed form letters.

Accepted Answer

The answer of You can merge data from an Access...

Question 4

Which error code will display if a column is not wide enough to display data?

Accepted Answer

A)  ##### 
B)  #NUM! 
C)  #NULL! 
D)  #NA 
A)  ##### 
B)  #NUM! 
C)  #NULL! 
D)  #NA

Question 5

Case-Based Critical Thinking Question John is using PowerPoint to create an extensive marketing presentation and he keeps modifying the same slide layout by adding new placeholders for pictures and adjusting the text indents in the content placeholder. John wants to modify his presentation so he can work more efficiently.
How can John solve his problem of having to modify the placeholders on all of his slides?

Accepted Answer

A)  Use a standard slide layout. 
B)  Adjust indent levels on the Slide Master. 
C)  Create a custom slide layout. 
D)  Use a different design theme. 
A)  Use a standard slide layout. 
B)  Adjust indent levels on the Slide Master. 
C)  Create a custom slide layout. 
D)  Use a different design theme.

Question 6

To name a range, select the range and then click the Define Name button in the Defined Names group.

Accepted Answer

A) True 
 B)False

Question 7

The CONCATENATE function joins two or more ____ into one.

Accepted Answer

A)  strings 
B)  formulas 
C)  cells 
D)  functions 
A)  strings 
B)  formulas 
C)  cells 
D)  functions

Question 8

A condition that can be answered with a true or false response is called a(n) ____.

Accepted Answer

A)  logical test. 
B)  what-if analysis. 
C)  True_False condition 
D)  IF analysis 
A)  logical test. 
B)  what-if analysis. 
C)  True_False condition 
D)  IF analysis

Question 9

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: 
   
What could you do to quickly make the table more attractive and easy to read?

Accepted Answer

You could apply a table style to the tab

Question 10

When you split a cell that contains text, Word splits the text between the new cells.

Accepted Answer

A) True 
 B)False

Question 11

Which error code will display if a number is used invalidly in a cell?

Accepted Answer

A)  #NUM! 
B)  #VAL 
C)  #VALUE! 
D)  #NAME? 
A)  #NUM! 
B)  #VAL 
C)  #VALUE! 
D)  #NAME?

Question 12

Use the buttons in the Table Styles group on the Table Tools  Layout tab to apply a table style. _________________________

Accepted Answer

A) True 
 B)False

Question 13

The ____ property determines whether users can add or edit the list of items in a Lookup field.

Accepted Answer

A)  Row Source 
B)  Limit to List 
C)  Allow Value List Edits 
D)  Display Control 
A)  Row Source 
B)  Limit to List 
C)  Allow Value List Edits 
D)  Display Control

Question 14

The Comments button is on the ____.

Accepted Answer

A)  Quick Access toolbar 
B)  status bar 
C)  Comments pane 
D)  Address bar 
A)  Quick Access toolbar 
B)  status bar 
C)  Comments pane 
D)  Address bar

Question 15

Animation effects, such as starting time and speed, can be customized.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The ____________________ function returns TRUE if any of its arguments are true.

Accepted Answer

The answer of The ____________________ function returns TRUE if any...

Question 18

Use the AutoFit command to change the height of rows or the width of columns.

Accepted Answer

A) True 
 B)False

Question 19

The parts of an IF function are separated by parentheses.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is not a placeholder for a slide layout?

Accepted Answer

A)  Text 
B)  Content 
C)  Clip Art 
D)  Video 
A)  Text 
B)  Content 
C)  Clip Art 
D)  Video

A common example of a text delimiter is ____.

The simplest way to apply an animation to objects is to use the Format Painter.

You can merge data from an Access database containing the names, addresses, and other information about a company's customers, contacts, and suppliers with a letter you create in ____________________ to produce a series of individually addressed form letters.

Which error code will display if a column is not wide enough to display data?

To name a range, select the range and then click the Define Name button in the Defined Names group.

The CONCATENATE function joins two or more ____ into one.

A condition that can be answered with a true or false response is called a(n) ____.

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: What could you do to quickly make the table more attractive and easy to read?

When you split a cell that contains text, Word splits the text between the new cells.

Which error code will display if a number is used invalidly in a cell?

Use the buttons in the Table Styles group on the Table Tools Layout tab to apply a table style. _________________________

The ____ property determines whether users can add or edit the list of items in a Lookup field.

The Comments button is on the ____.

Animation effects, such as starting time and speed, can be customized.

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

The ____________________ function returns TRUE if any of its arguments are true.

Use the AutoFit command to change the height of rows or the width of columns.

The parts of an IF function are separated by parentheses.

Which of the following is not a placeholder for a slide layout?

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

A common example of a text delimiter is ____.

The simplest way to apply an animation to objects is to use the Format Painter.

You can merge data from an Access database containing the names, addresses, and other information about a company's customers, contacts, and suppliers with a letter you create in ____________________ to produce a series of individually addressed form letters.

Which error code will display if a column is not wide enough to display data?

To name a range, select the range and then click the Define Name button in the Defined Names group.

The CONCATENATE function joins two or more ____ into one.

A condition that can be answered with a true or false response is called a(n) ____.

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: What could you do to quickly make the table more attractive and easy to read?

When you split a cell that contains text, Word splits the text between the new cells.

Which error code will display if a number is used invalidly in a cell?

Use the buttons in the Table Styles group on the Table Tools Layout tab to apply a table style. _________________________

The ____ property determines whether users can add or edit the list of items in a Lookup field.

The Comments button is on the ____.

Animation effects, such as starting time and speed, can be customized.

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

The ____________________ function returns TRUE if any of its arguments are true.

Use the AutoFit command to change the height of rows or the width of columns.

The parts of an IF function are separated by parentheses.

Which of the following is not a placeholder for a slide layout?

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