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

Case-Based Critical Thinking Question Sandy is a high school math teacher. She uses PowerPoint to create some of her online teaching tools that her students use in class. Sandy wants to save a presentation for the Web, and she needs your help. Sandy can use PowerPoint to host an online presentation in real time over the Internet as long as viewers have access to Microsoft's free Office Presentation Service.

(True/False)

4.9/5

(23)

Question 181

The mail merge process has ____ steps.

(Multiple Choice)

4.8/5

(32)

Question 182

Themes can include font, color, and alignment choices.

(True/False)

4.9/5

(36)

Question 183

After you create a password and click OK, the Confirm Password dialog box opens.

(True/False)

4.8/5

(40)

Question 184

One way to secure a PowerPoint presentation is to ____.

(Multiple Choice)

4.8/5

(29)

Question 185

When specifying criteria in the Custom AutoFilter dialog box, use the * (asterisk) wildcard to represent any single character. _________________________

(True/False)

4.9/5

(45)

Question 186

To sort a group of records in ascending order by state, click the State ____________________.

(Short Answer)

4.9/5

(28)

Question 187

Discuss two reasons you might want to modify section properties in a report.

(Essay)

4.8/5

(36)

Question 188

Filtering records pulls out records that meet specific criteria. _________________________

(True/False)

4.9/5

(42)

Question 189

A(n) column range is a cell range containing one row of labels and at least one additional row underneath the row of labels that contains the criteria you want to match. _________________________

(True/False)

4.9/5

(24)

Question 190

A ____ prompts you for criteria to determine the records to use for the report.

(Multiple Choice)

4.9/5

(35)

Question 191

Which report section is most commonly used to calculate a summary statistic on a group of records?

(Multiple Choice)

4.9/5

(30)

Question 192

The first thing you must do when creating a new data source is ____.

(Multiple Choice)

4.9/5

(26)

Question 193

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. Before traveling to a realtor's office, Jason creates a ____ custom slide show that is stored in the Custom Shows dialog box.

(Multiple Choice)

4.9/5

(42)

Question 194

Which report section would be the most logical choice to display the grouping field value?

(Multiple Choice)

4.9/5

(27)

Question 195

The file with the unique data for individual people or items is called the merge source. _________________________

(True/False)

4.8/5

(37)

Question 196

Merge fields inserted into a main document must match the field names in the associated database.

(True/False)

4.9/5

(31)

Question 197

Kelsey uses Access to track the sales by category for each trip. She needs to sum the price of each trip by category and she also needs a grand total. In which sections should she place the calculation to sum the price?

(Essay)

4.8/5

(30)

Question 198

A(n) ____ cannot be selected as the document type in the Mail Merge task pane.

(Multiple Choice)

4.9/5

(32)

Question 199

Parameters are predefined formats that you apply to the database to set all of the formatting enhancements. _________________________

(True/False)

4.9/5

(38)

Question 200

Showing 181 - 200 of 281

The mail merge process has ____ steps.

Themes can include font, color, and alignment choices.

After you create a password and click OK, the Confirm Password dialog box opens.

One way to secure a PowerPoint presentation is to ____.

When specifying criteria in the Custom AutoFilter dialog box, use the * (asterisk) wildcard to represent any single character. _________________________

To sort a group of records in ascending order by state, click the State ____________________.

Discuss two reasons you might want to modify section properties in a report.

Filtering records pulls out records that meet specific criteria. _________________________

A(n) column range is a cell range containing one row of labels and at least one additional row underneath the row of labels that contains the criteria you want to match. _________________________

A ____ prompts you for criteria to determine the records to use for the report.

Which report section is most commonly used to calculate a summary statistic on a group of records?

The first thing you must do when creating a new data source is ____.

Which report section would be the most logical choice to display the grouping field value?

The file with the unique data for individual people or items is called the merge source. _________________________

Merge fields inserted into a main document must match the field names in the associated database.

Kelsey uses Access to track the sales by category for each trip. She needs to sum the price of each trip by category and she also needs a grand total. In which sections should she place the calculation to sum the price?

A(n) ____ cannot be selected as the document type in the Mail Merge task pane.

Parameters are predefined formats that you apply to the database to set all of the formatting enhancements. _________________________

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

The mail merge process has ____ steps.

Themes can include font, color, and alignment choices.

After you create a password and click OK, the Confirm Password dialog box opens.

One way to secure a PowerPoint presentation is to ____.

When specifying criteria in the Custom AutoFilter dialog box, use the * (asterisk) wildcard to represent any single character. _________________________

To sort a group of records in ascending order by state, click the State ____________________.

Discuss two reasons you might want to modify section properties in a report.

Filtering records pulls out records that meet specific criteria. _________________________

A(n) column range is a cell range containing one row of labels and at least one additional row underneath the row of labels that contains the criteria you want to match. _________________________

A ____ prompts you for criteria to determine the records to use for the report.

Which report section is most commonly used to calculate a summary statistic on a group of records?

The first thing you must do when creating a new data source is ____.

Which report section would be the most logical choice to display the grouping field value?

The file with the unique data for individual people or items is called the merge source. _________________________

Merge fields inserted into a main document must match the field names in the associated database.​

Kelsey uses Access to track the sales by category for each trip. She needs to sum the price of each trip by category and she also needs a grand total. In which sections should she place the calculation to sum the price?

A(n) ____ cannot be selected as the document type in the Mail Merge task pane.

Parameters are predefined formats that you apply to the database to set all of the formatting enhancements. _________________________

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

Merge fields inserted into a main document must match the field names in the associated database.