Question 1

To ensure the lines within a paragraph are not separated on different pages,which of the following should be done?

Accepted Answer

A)  Enable the page break before option. 
B)  Enable the keep lines together option. 
C)  Enable the keep with next option. 
D)  Enable the widow and orphan control option. 
A)  Enable the page break before option. 
B)  Enable the keep lines together option. 
C)  Enable the keep with next option. 
D)  Enable the widow and orphan control option.

Question 2

To increase the distance between cells in a table,which of the following should be done?

Accepted Answer

A)  Increase the spacing between cells. 
B)  Increase the border weight. 
C)  Increase the cell margin. 
D)  Increase the width of cells. 
A)  Increase the spacing between cells. 
B)  Increase the border weight. 
C)  Increase the cell margin. 
D)  Increase the width of cells.

Question 3

Jasmine needs to add choices to a drop-down list content control.She should do which of the following?

Accepted Answer

A)  Modify the content control properties. 
B)  Apply bullets to the content control. 
C)  Apply a text effect to the content control. 
D)  Modify the content control style. 
A)  Modify the content control properties. 
B)  Apply bullets to the content control. 
C)  Apply a text effect to the content control. 
D)  Modify the content control style.

Question 4

To remove restrictions from a document,which of the following should be done?

Accepted Answer

A)  Stop protection. 
B)  Disable macros. 
C)  Apply editing restrictions. 
D)  Apply formatting restrictions. 
A)  Stop protection. 
B)  Disable macros. 
C)  Apply editing restrictions. 
D)  Apply formatting restrictions.

Question 5

To modify the fill of a rich text content control,which of the following should be done?

Accepted Answer

A)  Enter text in the content control. 
B)  Group the content control. 
C)  Modify the content control properties. 
D)  Change the alignment of the content control. 
A)  Enter text in the content control. 
B)  Group the content control. 
C)  Modify the content control properties. 
D)  Change the alignment of the content control.

Question 6

To allow a person viewing a document to insert a picture,add apicture content control.

Accepted Answer

A) True 
 B)False

Question 7

To add a content control that allows users to select from a variety of AutoText options,which of the following should be done?

Accepted Answer

A)  Insert a plain text content control. 
B)  Insert a combo box content control. 
C)  Insert a date picker content control. 
D)  Insert a building block content control. 
A)  Insert a plain text content control. 
B)  Insert a combo box content control. 
C)  Insert a date picker content control. 
D)  Insert a building block content control.

Question 8

To modify the fill of a rich text content control,use the Content Control Properties dialogue box.

Accepted Answer

A) True 
 B)False

Question 9

To create a content control that allows people to enter formatted text,insert a Rich Text Content Control.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following describes the purpose of Design mode?

Accepted Answer

A)  Design mode is optimized to help you organize headings in a document. 
B)  Design mode is optimized to help you create a webpage. 
C)  Design mode is optimized to help you arrange objects on a page. 
D)  Design mode is optimized to help you create a fillable form. 
A)  Design mode is optimized to help you organize headings in a document. 
B)  Design mode is optimized to help you create a webpage. 
C)  Design mode is optimized to help you arrange objects on a page. 
D)  Design mode is optimized to help you create a fillable form.

Question 11

To add repeating pieces of information to a form,which of the following should be inserted?

Accepted Answer

A)  A combo box content control 
B)  A building block content control 
C)  A repeating section content control 
D)  A plain text content control 
A)  A combo box content control 
B)  A building block content control 
C)  A repeating section content control 
D)  A plain text content control

Question 12

To add repeating pieces of information to a form,insert a repeating section content control.

Accepted Answer

A) True 
 B)False

Question 13

Adam needs people viewing a document to be able to place a check mark in a box.He should do which of the following?

Accepted Answer

A)  Insert a check box content control. 
B)  Insert a combo box content control. 
C)  Insert a plain text content control. 
D)  Insert a date picker content control. 
A)  Insert a check box content control. 
B)  Insert a combo box content control. 
C)  Insert a plain text content control. 
D)  Insert a date picker content control.

Question 14

To uniquely identify a content control in a document,modify the tag property.

Accepted Answer

A) True 
 B)False

Question 15

To increase the space between the contents of a cell and the border of the cell,which of the following should be done?

Accepted Answer

A)  Increase the cell width. 
B)  Decrease the cell width 
C)  Decrease the cell margins. 
D)  Increase the cell margins. 
A)  Increase the cell width. 
B)  Decrease the cell width 
C)  Decrease the cell margins. 
D)  Increase the cell margins.

Question 16

To center a table on the page,change the alignment of the table.

Accepted Answer

A) True 
 B)False

Question 17

To specify an exact column width,which of the following should be done?

Accepted Answer

A)  Click Distribute Rows. 
B)  Specify a fixed width for the columns. 
C)  Click Distribute Columns. 
D)  Autofit content in the columns. 
A)  Click Distribute Rows. 
B)  Specify a fixed width for the columns. 
C)  Click Distribute Columns. 
D)  Autofit content in the columns.

Question 18

To ensure a document can only be viewed by people with an access password,which of the following should be done?

Accepted Answer

A)  Enable track changes. 
B)  Encrypt the document with a password. 
C)  Apply formatting restrictions. 
D)  Apply editing restrictions. 
A)  Enable track changes. 
B)  Encrypt the document with a password. 
C)  Apply formatting restrictions. 
D)  Apply editing restrictions.

Question 19

To move information from one row in a table to another row in a table without changing the total number of rows,which of the following should be done?

Accepted Answer

A)  Copy the desired source row of the table and then overwrite the cells in the desired destination row. 
B)  Cut the desired source row of the table and then overwrite the cells in the desired destination row. 
C)  Copy the desired source row of the table and then insert the data as a new row. 
D)  Cut the desired source row of the table and then insert the data as a new row. 
A)  Copy the desired source row of the table and then overwrite the cells in the desired destination row. 
B)  Cut the desired source row of the table and then overwrite the cells in the desired destination row. 
C)  Copy the desired source row of the table and then insert the data as a new row. 
D)  Cut the desired source row of the table and then insert the data as a new row.

Question 20

To change lowercase letters to uppercase letters in a smaller font size,which of the following should be done?

Accepted Answer

A)  Format the text in Small caps. 
B)  Manually replace the lowercase letters with uppercase letters. 
C)  Format the text in All caps. 
A)  Format the text in Small caps. 
B)  Manually replace the lowercase letters with uppercase letters. 
C)  Format the text in All caps.

To ensure the lines within a paragraph are not separated on different pages,which of the following should be done?

To increase the distance between cells in a table,which of the following should be done?

Jasmine needs to add choices to a drop-down list content control.She should do which of the following?

To remove restrictions from a document,which of the following should be done?

To modify the fill of a rich text content control,which of the following should be done?

To allow a person viewing a document to insert a picture,add apicture content control.

To add a content control that allows users to select from a variety of AutoText options,which of the following should be done?

To modify the fill of a rich text content control,use the Content Control Properties dialogue box.

To create a content control that allows people to enter formatted text,insert a Rich Text Content Control.

Which of the following describes the purpose of Design mode?

To add repeating pieces of information to a form,which of the following should be inserted?

To add repeating pieces of information to a form,insert a repeating section content control.

Adam needs people viewing a document to be able to place a check mark in a box.He should do which of the following?

To uniquely identify a content control in a document,modify the tag property.

To increase the space between the contents of a cell and the border of the cell,which of the following should be done?

To center a table on the page,change the alignment of the table.

To specify an exact column width,which of the following should be done?

To ensure a document can only be viewed by people with an access password,which of the following should be done?

To move information from one row in a table to another row in a table without changing the total number of rows,which of the following should be done?

To change lowercase letters to uppercase letters in a smaller font size,which of the following should be done?

Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference

Formatting Workbook Text and Data: Creating a Sales Report

Performing Calculations With Formulas and Functions: Staffing a Call Center

Analyzing and Charting Financial Data: Preparing an Investment Report

Generating Reports From Multiple Worksheets and Workbooks: Summarizing Profit and Lo

Managing Data With Data Tools: Analyzing Employment Data

Summarizing Data With Pivottables: Preparing a Social Media Marketing Report

Performing What-If Analyses: Maximizing Profits With the Right Product Mix

Analyzing Data With Business Intelligence Tools: Presenting Sales and Revenue Data

Filters

Exam 9: Exploring Financial Tools and Functions: Analyzing a Business Plan

To ensure the lines within a paragraph are not separated on different pages,which of the following should be done?

To increase the distance between cells in a table,which of the following should be done?

Jasmine needs to add choices to a drop-down list content control.She should do which of the following?

To remove restrictions from a document,which of the following should be done?

To modify the fill of a rich text content control,which of the following should be done?

To allow a person viewing a document to insert a picture,add apicture content control.

To add a content control that allows users to select from a variety of AutoText options,which of the following should be done?

To modify the fill of a rich text content control,use the Content Control Properties dialogue box.

To create a content control that allows people to enter formatted text,insert a Rich Text Content Control.

Which of the following describes the purpose of Design mode?

To add repeating pieces of information to a form,which of the following should be inserted?

To add repeating pieces of information to a form,insert a repeating section content control.

Adam needs people viewing a document to be able to place a check mark in a box.He should do which of the following?

To uniquely identify a content control in a document,modify the tag property.

To increase the space between the contents of a cell and the border of the cell,which of the following should be done?

To center a table on the page,change the alignment of the table.

To specify an exact column width,which of the following should be done?

To ensure a document can only be viewed by people with an access password,which of the following should be done?

To move information from one row in a table to another row in a table without changing the total number of rows,which of the following should be done?

To change lowercase letters to uppercase letters in a smaller font size,which of the following should be done?

Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference

Formatting Workbook Text and Data: Creating a Sales Report

Performing Calculations With Formulas and Functions: Staffing a Call Center

Analyzing and Charting Financial Data: Preparing an Investment Report

Generating Reports From Multiple Worksheets and Workbooks: Summarizing Profit and Lo

Managing Data With Data Tools: Analyzing Employment Data

Summarizing Data With Pivottables: Preparing a Social Media Marketing Report

Performing What-If Analyses: Maximizing Profits With the Right Product Mix

Analyzing Data With Business Intelligence Tools: Presenting Sales and Revenue Data

Filters