Exam 8: Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Office extras are applications you can download to PowerPoint from the Microsoft Office store. ____________________

(True/False)

4.7/5

(38)

Question 21

Report View does not show page margins. ____________________

(True/False)

4.9/5

(34)

Question 22

Shizuka is asked to print letters to send to all the employees in her company's sales department to let them know about some recent changes in the department. She has already written the letter. Now she is ready to create a mail merge. What are some of the options available to Shizuka to use as her data source?

(Essay)

4.7/5

(41)

Question 23

Provide an example of customizing a merged document.

(Essay)

4.9/5

(37)

Question 24

A custom slide show is saved as a separate presentation on your computer.

(True/False)

4.8/5

(31)

Question 25

Merging to a new file creates an individual document for each customized letter.

(True/False)

4.9/5

(45)

Question 26

Icon sets let you visually communicate relative cell values by adding icons to cells based on the values they contain. _________________________

(True/False)

4.7/5

(36)

Question 27

Default margins are often 0.25 inches in Report Design View. For a report printed in portrait orientation on 8.5x11" paper, this means that the report can be no wider than ____.

(Multiple Choice)

4.9/5

(29)

Question 28

When specifying criteria in the Custom AutoFilter dialog box, use the ____ wildcard to specify any series of characters.

(Multiple Choice)

4.9/5

(27)

Question 29

To display records for customers with incomes that are above $40,000 and below $70,000, use the ____________________ logical condition.

(Short Answer)

4.8/5

(28)

Question 30

When you package a presentation, all linked and embedded objects are included.

(True/False)

4.8/5

(33)

Question 31

You know a slide is hidden because the ____.

(Multiple Choice)

4.7/5

(25)

Question 32

If you want to find the closest possible match, what do you enter in the Range_lookup text box in the Function Arguments dialog box?

(Multiple Choice)

4.8/5

(33)

Question 33

Conditional formatting allows you to compare the values of one column to another with small data bars.

(True/False)

4.9/5

(37)

Question 34

Case-Based Critical Thinking Questions Jason works for real estate developer that builds luxury condominiums. He travels around the country to show realtors upcoming properties for sale. He has built a presentation in PowerPoint that includes twelve new properties in different states. To show his custom slide show, Jason first has to ____.

(Multiple Choice)

4.8/5

(36)

Question 35

In a mail merge, the ____________________ document contains boilerplate text.

(Short Answer)

4.7/5

(38)

Question 36

You enter parameter criteria in Query Design View inside of ____.

(Multiple Choice)

4.7/5

(38)

Question 37

With the data validation feature, you can restrict data to all of the following EXCEPT ____.

(Multiple Choice)

5.0/5

(26)

Question 38

You can create a main document using _____.

(Multiple Choice)

4.8/5

(34)

Question 39

You can use the Custom Label button in the Label Options dialog box to create labels with custom measurements.

(True/False)

4.7/5

(43)

Question 40

Showing 21 - 40 of 281

Office extras are applications you can download to PowerPoint from the Microsoft Office store. ____________________

Report View does not show page margins. ____________________

Provide an example of customizing a merged document.

A custom slide show is saved as a separate presentation on your computer.

Merging to a new file creates an individual document for each customized letter.

Icon sets let you visually communicate relative cell values by adding icons to cells based on the values they contain. _________________________

Default margins are often 0.25 inches in Report Design View. For a report printed in portrait orientation on 8.5x11" paper, this means that the report can be no wider than ____.

When specifying criteria in the Custom AutoFilter dialog box, use the ____ wildcard to specify any series of characters.

To display records for customers with incomes that are above $40,000 and below $70,000, use the ____________________ logical condition.

When you package a presentation, all linked and embedded objects are included.

You know a slide is hidden because the ____.

If you want to find the closest possible match, what do you enter in the Range_lookup text box in the Function Arguments dialog box?

Conditional formatting allows you to compare the values of one column to another with small data bars.

In a mail merge, the ____________________ document contains boilerplate text.

You enter parameter criteria in Query Design View inside of ____.

With the data validation feature, you can restrict data to all of the following EXCEPT ____.

You can create a main document using _____.

You can use the Custom Label button in the Label Options dialog box to create labels with custom measurements.

Module 4: Integrating Word and Excel Access

Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and 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

Filters

Exam 8: Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Office extras are applications you can download to PowerPoint from the Microsoft Office store. ____________________​

Report View does not show page margins.​ ____________________

Provide an example of customizing a merged document.

A custom slide show is saved as a separate presentation on your computer.

Merging to a new file creates an individual document for each customized letter.

Icon sets let you visually communicate relative cell values by adding icons to cells based on the values they contain. _________________________

Default margins are often 0.25 inches in Report Design View. For a report printed in portrait orientation on 8.5x11" paper, this means that the report can be no wider than ____.

When specifying criteria in the Custom AutoFilter dialog box, use the ____ wildcard to specify any series of characters.

To display records for customers with incomes that are above $40,000 and below $70,000, use the ____________________ logical condition.​

When you package a presentation, all linked and embedded objects are included.​

You know a slide is hidden because the ____.

If you want to find the closest possible match, what do you enter in the Range_lookup text box in the Function Arguments dialog box?

Conditional formatting allows you to compare the values of one column to another with small data bars.

In a mail merge, the ____________________ document contains boilerplate text.

You enter parameter criteria in Query Design View inside of ____.

With the data validation feature, you can restrict data to all of the following EXCEPT ____.

You can create a main document using​ _____.

You can use the Custom Label b​utton in the Label Options dialog box to create labels with custom measurements.

Module 4: Integrating Word and Excel Access

Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and 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

Filters

Office extras are applications you can download to PowerPoint from the Microsoft Office store. ____________________

Report View does not show page margins. ____________________

To display records for customers with incomes that are above $40,000 and below $70,000, use the ____________________ logical condition.

When you package a presentation, all linked and embedded objects are included.

You can create a main document using _____.

You can use the Custom Label button in the Label Options dialog box to create labels with custom measurements.