Question 1

To allow a person viewing a document to enter a date using a pop-up calendar, which of the following kinds of content control should be inserted?

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

A content control is a tool to organize floating objects on a page.

Accepted Answer

A) True 
 B)False

Question 4

To insert content controls, ensure that the Developer tab is displayed.

Accepted Answer

A) True 
 B)False

Question 5

Tim needs to ensure a paragraph is not separated onto different pages. He should do which of the following?

Accepted Answer

A)  Enable the keep lines together option. 
B)  Enable the keep with next option. 
C)  Enable the widow and orphan control option. 
D)  Enable the don't hyphenate option. 
A)  Enable the keep lines together option. 
B)  Enable the keep with next option. 
C)  Enable the widow and orphan control option. 
D)  Enable the don't hyphenate option.

Question 6

Adam needs to prevent people viewing a document from deleting a content control. He should do which of the following?

Accepted Answer

A)  Start a mail merge. 
B)  Turn on track changes. 
C)  Modify the content control properties. 
D)  Add formatting restrictions to the document. 
A)  Start a mail merge. 
B)  Turn on track changes. 
C)  Modify the content control properties. 
D)  Add formatting restrictions to the document.

Question 7

To add a content control that allows a person to enter text or choose from a list of text options, insert a combo box content control.

Accepted Answer

A) True 
 B)False

Question 8

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 9

To change the color of a cell in a table, which of the following should be done?

Accepted Answer

A)  Modify the font color of text in the cell. 
B)  Modify the cell border style. 
C)  Apply shading to the cell. 
A)  Modify the font color of text in the cell. 
B)  Modify the cell border style. 
C)  Apply shading to the cell.

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

To restrict editing to comments, which type of editing after applying editing restrictions should be allowed?

Accepted Answer

A)  tracked changes 
B)  comments 
C)  filling in forms 
D)  no changes (read only) 
A)  tracked changes 
B)  comments 
C)  filling in forms 
D)  no changes (read only)

Question 12

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 13

To evenly space the columns in a table, which of the following should be done?

Accepted Answer

A)  Click Distribute Rows. 
B)  Click Distribute Columns. 
C)  Click AutoFit Contents. 
D)  Click AutoFit Window. 
A)  Click Distribute Rows. 
B)  Click Distribute Columns. 
C)  Click AutoFit Contents. 
D)  Click AutoFit Window.

Question 14

To change the format of a date picker content control, modify the content control attributes.

Accepted Answer

False - properties
F

Question 15

To restrict editing to filling in forms, which type of editing after applying editing restrictions should be allowed?

Accepted Answer

A)  tracked changes 
B)  comments 
C)  filling in forms 
D)  no changes (read only) 
A)  tracked changes 
B)  comments 
C)  filling in forms 
D)  no changes (read only)

Question 16

Brian needs to view the paragraph marks in a document. Which of the following should he do?

Accepted Answer

A)  Enter Web Layout view 
B)  Enter Read Mode 
C)  Click the checkbox to show Gridlines 
D)  Select the Show/Hide ¶ button. 
A)  Enter Web Layout view 
B)  Enter Read Mode 
C)  Click the checkbox to show Gridlines 
D)  Select the Show/Hide ¶ button.

Question 17

Matthew needs to increase the space between the contents of a cell and the border of the cell. He should do which of the following?

Accepted Answer

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

Question 18

To allow a person viewing a document to insert a picture, which of the following kinds of content control should be inserted?

Accepted Answer

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

Question 19

To equally distribute the heights of the rows in a table, click Sort Rows.

Accepted Answer

False - distribute
F

Question 20

To create a content control that allows people to enter plain, unformatted text, which of the following should be done?

Accepted Answer

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

To allow a person viewing a document to enter a date using a pop-up calendar, which of the following kinds of content control should be inserted?

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

A content control is a tool to organize floating objects on a page.

To insert content controls, ensure that the Developer tab is displayed.

Tim needs to ensure a paragraph is not separated onto different pages. He should do which of the following?

Adam needs to prevent people viewing a document from deleting a content control. He should do which of the following?

To add a content control that allows a person to enter text or choose from a list of text options, insert a combo box content control.

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

To change the color of a cell in a table, 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 restrict editing to comments, which type of editing after applying editing restrictions should be allowed?

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

To evenly space the columns in a table, which of the following should be done?

To change the format of a date picker content control, modify the content control attributes.

To restrict editing to filling in forms, which type of editing after applying editing restrictions should be allowed?

Brian needs to view the paragraph marks in a document. Which of the following should he do?

Matthew needs to increase the space between the contents of a cell and the border of the cell. He should do which of the following?

To allow a person viewing a document to insert a picture, which of the following kinds of content control should be inserted?

To equally distribute the heights of the rows in a table, click Sort Rows.

To create a content control that allows people to enter plain, unformatted text, which of the following should be done?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Analyzing Data With Business Intelligence Tools

Filters

Exam 9: Exploring Financial Tools and Functions

To allow a person viewing a document to enter a date using a pop-up calendar, which of the following kinds of content control should be inserted?

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

A content control is a tool to organize floating objects on a page.

To insert content controls, ensure that the Developer tab is displayed.

Tim needs to ensure a paragraph is not separated onto different pages. He should do which of the following?

Adam needs to prevent people viewing a document from deleting a content control. He should do which of the following?

To add a content control that allows a person to enter text or choose from a list of text options, insert a combo box content control.

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

To change the color of a cell in a table, 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 restrict editing to comments, which type of editing after applying editing restrictions should be allowed?

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

To evenly space the columns in a table, which of the following should be done?

To change the format of a date picker content control, modify the content control attributes.

To restrict editing to filling in forms, which type of editing after applying editing restrictions should be allowed?

Brian needs to view the paragraph marks in a document. Which of the following should he do?

Matthew needs to increase the space between the contents of a cell and the border of the cell. He should do which of the following?

To allow a person viewing a document to insert a picture, which of the following kinds of content control should be inserted?

To equally distribute the heights of the rows in a table, click Sort Rows.

To create a content control that allows people to enter plain, unformatted text, which of the following should be done?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Analyzing Data With Business Intelligence Tools

Filters