Question 1

The ____ property determines the layout of a form.

Accepted Answer

A)  Appearance 
B)  Format 
C)  Form View 
D)  Default View 
A)  Appearance 
B)  Format 
C)  Form View 
D)  Default View

Question 2

David is writing a flyer to advertise a sale in the store he works for. He wants to save the information in the flyer so he can use it again without having to recreate it. How could he do this?

Accepted Answer

He could save the information by selecti

Question 3

Maria is writing a proposal to purchase new computer equipment for her company. How can she add a cover letter to the proposal?

Accepted Answer

Maria can insert a cover page based on o

Question 4

A(n) ____________________ is a set of actions that you use to automate tasks.

Accepted Answer

The answer of A(n) ____________________ is a set of actions...

Question 5

To remove a cover page from a document, click the Cover Page list arrow in the Pages group and then click ____.

Accepted Answer

A)  Delete Cover Page 
B)  Remove Cover Page 
C)  Remove Current Cover Page 
D)  Delete Current Cover Page 
A)  Delete Cover Page 
B)  Remove Cover Page 
C)  Remove Current Cover Page 
D)  Delete Current Cover Page

Question 6

Inserting extra spaces at the beginning of a cell entry in a table can affect sorting and finding data later.

Accepted Answer

A) True 
 B)False

Question 7

In PowerPoint, a video clip can be trimmed anywhere in the clip.​

Accepted Answer

A) True 
 B)False

Question 8

If Denise specifies Jan* as a search criterion, which of the following will Excel locate?

Accepted Answer

A)  Jane 
B)  Janet 
C)  January 
D)  All of the above. 
A)  Jane 
B)  Janet 
C)  January 
D)  All of the above.

Question 9

The Limit to List property is associated with the ____ control.

Accepted Answer

A)  combo box 
B)  list box 
C)  text box 
D)  menu list 
A)  combo box 
B)  list box 
C)  text box 
D)  menu list

Question 10

You can press [ Tab ] while dragging the action button to nudge it into place. _________________________

Accepted Answer

A) True 
 B)False

Question 11

A(n) ____________________ is a table row that contains data about an object, person, or other type of item.

Accepted Answer

The answer of A(n) ____________________ is a table row that...

Question 12

Briefly explain the two ways to use a combo box control on a form.

Accepted Answer

You can use a combo box for da

Question 13

Which of the following is NOT a guideline you should follow when planning a table?

Accepted Answer

A)  Plan and design your table so that all rows have similar items in the same column. 
B)  Avoid blank columns. 
C)  Avoid blank rows. 
D)  Use a variety of formats for all cells in a column. 
A)  Plan and design your table so that all rows have similar items in the same column. 
B)  Avoid blank columns. 
C)  Avoid blank rows. 
D)  Use a variety of formats for all cells in a column.

Question 14

You use the ____ button on the Insert tab to insert sidebars and pull quotes.

Accepted Answer

A)  Sidebar 
B)  Building Blocks 
C)  Object 
D)  Text Box 
A)  Sidebar 
B)  Building Blocks 
C)  Object 
D)  Text Box

Question 15

To modify the number of items displayed in a combo box list, you use the ____ property.

Accepted Answer

A)  Control Source 
B)  List Rows 
C)  Limit to List 
D)  Drop-Down 
A)  Control Source 
B)  List Rows 
C)  Limit to List 
D)  Drop-Down

Question 16

Which of the following form sections often contains command buttons?

Accepted Answer

A)  Commands 
B)  Form Header 
C)  Page Footer 
D)  Report Footer 
A)  Commands 
B)  Form Header 
C)  Page Footer 
D)  Report Footer

Question 17

You can open the Field List with the Add Existing Fields button. _________________________

Accepted Answer

A) True 
 B)False

Question 18

You can easily format a table using table ____.

Accepted Answer

A)  styles 
B)  galleries 
C)  fields 
D)  themes 
A)  styles 
B)  galleries 
C)  fields 
D)  themes

Question 19

Where do you commonly add new records to an Excel table?

Accepted Answer

A)  Between the header row and the first record. 
B)  Below the last row of the existing table. 
C)  To the right of the header row. 
D)  Above the header row. 
A)  Between the header row and the first record. 
B)  Below the last row of the existing table. 
C)  To the right of the header row. 
D)  Above the header row.

Question 20

____________________ layout is the default view for a main form.

Accepted Answer

The answer of ____________________ layout is the default view for...

The ____ property determines the layout of a form.

David is writing a flyer to advertise a sale in the store he works for. He wants to save the information in the flyer so he can use it again without having to recreate it. How could he do this?

Maria is writing a proposal to purchase new computer equipment for her company. How can she add a cover letter to the proposal?

A(n) ____________________ is a set of actions that you use to automate tasks.

To remove a cover page from a document, click the Cover Page list arrow in the Pages group and then click ____.

Inserting extra spaces at the beginning of a cell entry in a table can affect sorting and finding data later.

In PowerPoint, a video clip can be trimmed anywhere in the clip.

If Denise specifies Jan* as a search criterion, which of the following will Excel locate?

The Limit to List property is associated with the ____ control.

You can press [ Tab ] while dragging the action button to nudge it into place. _________________________

A(n) ____________________ is a table row that contains data about an object, person, or other type of item.

Briefly explain the two ways to use a combo box control on a form.

Which of the following is NOT a guideline you should follow when planning a table?

You use the ____ button on the Insert tab to insert sidebars and pull quotes.

To modify the number of items displayed in a combo box list, you use the ____ property.

Which of the following form sections often contains command buttons?

You can open the Field List with the Add Existing Fields button. _________________________

You can easily format a table using table ____.

Where do you commonly add new records to an Excel table?

____________________ layout is the default view for a main form.

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

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

Exam 7: Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

The ____ property determines the layout of a form.

David is writing a flyer to advertise a sale in the store he works for. He wants to save the information in the flyer so he can use it again without having to recreate it. How could he do this?

Maria is writing a proposal to purchase new computer equipment for her company. How can she add a cover letter to the proposal?

A(n) ____________________ is a set of actions that you use to automate tasks.

To remove a cover page from a document, click the Cover Page list arrow in the Pages group and then click ____.

Inserting extra spaces at the beginning of a cell entry in a table can affect sorting and finding data later.

In PowerPoint, a video clip can be trimmed anywhere in the clip.​

If Denise specifies Jan* as a search criterion, which of the following will Excel locate?

The Limit to List property is associated with the ____ control.

You can press [ Tab ] while dragging the action button to nudge it into place. _________________________

A(n) ____________________ is a table row that contains data about an object, person, or other type of item.

Briefly explain the two ways to use a combo box control on a form.

Which of the following is NOT a guideline you should follow when planning a table?

You use the ____ button on the Insert tab to insert sidebars and pull quotes.

To modify the number of items displayed in a combo box list, you use the ____ property.

Which of the following form sections often contains command buttons?

You can open the Field List with the Add Existing Fields button. _________________________

You can easily format a table using table ____.

Where do you commonly add new records to an Excel table?

____________________ layout is the default view for a main form.

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

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

In PowerPoint, a video clip can be trimmed anywhere in the clip.