Question 1

To prevent people from making changes to a document, apply formatting restrictions.

Accepted Answer

False - ed

Question 2

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 3

To create a content control that allows people to enter plain text, insert a Date Picker Content Control.

Accepted Answer

A) True 
 B)False

Question 4

Kendall wants people viewing a document to only be able to leave comments. She should allow which type of editing after applying editing restrictions?

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 5

Gabrielle needs a table to be centered on a page. She should do which of the following?

Accepted Answer

A)  Change the alignment of the table. 
B)  Change the alignment of the cells. 
C)  Change the orientation of the page. 
D)  Change the style of the table. 
A)  Change the alignment of the table. 
B)  Change the alignment of the cells. 
C)  Change the orientation of the page. 
D)  Change the style of the table.

Question 6

To allow a person viewing a document to insert a picture, add a picture 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 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 check box content control. 
C)  Insert a building block gallery content control. 
D)  Insert a picture content control. 
A)  Insert a plain text content control. 
B)  Insert a check box content control. 
C)  Insert a building block gallery content control. 
D)  Insert a picture content control.

Question 9

To add a content control that allows a person to enter text or choose from a list of text options, which of the following should be inserted?

Accepted Answer

A)  A combo box content control 
B)  A drop-down list content control 
C)  A repeating section content control 
D)  A plain text content control 
A)  A combo box content control 
B)  A drop-down list content control 
C)  A repeating section content control 
D)  A plain text content control

Question 10

To change the format of a date picker content control, which of the following should be done?

Accepted Answer

A)  Change the content control properties. 
B)  Apply a paragraph style to the content control. 
C)  Group the content control. 
D)  Modify the content control in Design Mode. 
A)  Change the content control properties. 
B)  Apply a paragraph style to the content control. 
C)  Group the content control. 
D)  Modify the content control in Design Mode.

Question 11

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 12

Kiara needs each column in a table to be 0.5 inches in width. She should do which of the following?

Accepted Answer

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

Question 13

To evenly space the columns in a table, click Distribute Columns.

Accepted Answer

A) True 
 B)False

Question 14

To insert content controls, which of the following tabs should be ensured to be displayed?

Accepted Answer

A)  References tab 
B)  Review tab 
C)  Add-ins tab 
D)  Developer tab 
A)  References tab 
B)  Review tab 
C)  Add-ins tab 
D)  Developer tab

Question 15

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 16

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 17

Laila needs to divide a cell into two cells. She should do which of the following?

Accepted Answer

A)  Split the cell. 
B)  Merge the cell. 
C)  Split the table. 
A)  Split the cell. 
B)  Merge the cell. 
C)  Split the table.

Question 18

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 19

To allow a person viewing a document to enter specific text from a list of choices without the option to enter custom text, which of the following kinds of content control should be inserted?

Accepted Answer

A)  Check box content control 
B)  Plain text content control 
C)  Combo box content control 
D)  Drop-down list content control 
A)  Check box content control 
B)  Plain text content control 
C)  Combo box content control 
D)  Drop-down list content control

Question 20

To allow a person viewing a document to enter specific text from a list of choices, insert a drop-down content control.

Accepted Answer

A) True 
 B)False

To prevent people from making changes to a document, apply formatting restrictions.

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

To create a content control that allows people to enter plain text, insert a Date Picker Content Control.

Kendall wants people viewing a document to only be able to leave comments. She should allow which type of editing after applying editing restrictions?

Gabrielle needs a table to be centered on a page. She should do which of the following?

To allow a person viewing a document to insert a picture, add a picture 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 add a content control that allows users to select from a variety of AutoText options, which of the following should be done?

To add a content control that allows a person to enter text or choose from a list of text options, which of the following should be inserted?

To change the format of a date picker content control, 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?

Kiara needs each column in a table to be 0.5 inches in width. She should do which of the following?

To evenly space the columns in a table, click Distribute Columns.

To insert content controls, which of the following tabs should be ensured to be displayed?

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 add repeating pieces of information to a form, which of the following should be inserted?

Laila needs to divide a cell into two cells. She should do which of the following?

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 enter specific text from a list of choices without the option to enter custom text, which of the following kinds of content control should be inserted?

To allow a person viewing a document to enter specific text from a list of choices, insert a drop-down content control.

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 prevent people from making changes to a document, apply formatting restrictions.

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

To create a content control that allows people to enter plain text, insert a Date Picker Content Control.

Kendall wants people viewing a document to only be able to leave comments. She should allow which type of editing after applying editing restrictions?

Gabrielle needs a table to be centered on a page. She should do which of the following?

To allow a person viewing a document to insert a picture, add a picture 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 add a content control that allows users to select from a variety of AutoText options, which of the following should be done?

To add a content control that allows a person to enter text or choose from a list of text options, which of the following should be inserted?

To change the format of a date picker content control, 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?

Kiara needs each column in a table to be 0.5 inches in width. She should do which of the following?

To evenly space the columns in a table, click Distribute Columns.

To insert content controls, which of the following tabs should be ensured to be displayed?

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 add repeating pieces of information to a form, which of the following should be inserted?

Laila needs to divide a cell into two cells. She should do which of the following?

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 enter specific text from a list of choices without the option to enter custom text, which of the following kinds of content control should be inserted?

To allow a person viewing a document to enter specific text from a list of choices, insert a drop-down content control.

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