Question 1

To add a border to a table, modify the table shading.

Accepted Answer

A) True 
 B)False

Question 2

To set the style for text typed into a content control, which of the following should be done?

Accepted Answer

A)  Modify the content control properties. 
B)  Group the content control. 
C)  Apply shading to the content control. 
D)  Modify the content control's tag. 
A)  Modify the content control properties. 
B)  Group the content control. 
C)  Apply shading to the content control. 
D)  Modify the content control's tag.

Question 3

Aaron needs a drop-down list content control to be orange. He should do which of the following?

Accepted Answer

A)  Change the content control alignment. 
B)  Create a macro. 
C)  Change the page color. 
D)  Modify the content control properties. 
A)  Change the content control alignment. 
B)  Create a macro. 
C)  Change the page color. 
D)  Modify the content control properties.

Question 4

Samantha created a survey for distribution. She wants to ensure people taking the survey are only able to fill in the form, without making changes to the form itself. She should apply which type of 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

To prevent people from making any changes to a document, which of the following should be done?

Accepted Answer

A)  Apply formatting restrictions. 
B)  Apply editing restrictions, and allow no changes. 
C)  Enable track changes. 
D)  Inspect the document. 
A)  Apply formatting restrictions. 
B)  Apply editing restrictions, and allow no changes. 
C)  Enable track changes. 
D)  Inspect the document.

Question 6

Josiah needs a row to be exactly 0.5 inches tall. He should do which of the following?

Accepted Answer

A)  Select the row, then enter the desired width in the Width text box. 
B)  Select the row, then enter the desired height in the Height text box. 
C)  Drag the row border to adjust the width. 
D)  Drag the row border to adjust the height. 
A)  Select the row, then enter the desired width in the Width text box. 
B)  Select the row, then enter the desired height in the Height text box. 
C)  Drag the row border to adjust the width. 
D)  Drag the row border to adjust the height.

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Jeremy needs to prevent people from modifying the formatting of a document. He should do which of the following?

Accepted Answer

A)  Enable document editing restrictions. 
B)  Enable document formatting restrictions. 
C)  Set the document macro security settings to disable all macros with notification. 
D)  Set the document macro security settings to disable all macros except digitally signed macros. 
A)  Enable document editing restrictions. 
B)  Enable document formatting restrictions. 
C)  Set the document macro security settings to disable all macros with notification. 
D)  Set the document macro security settings to disable all macros except digitally signed macros.

Question 9

Sherri needs the people viewing a document to enter information in the document. She needs people to enter one of three choices. She should do which of the following?

Accepted Answer

A)  Create a text box content control. 
B)  Create a date picker content control. 
C)  Create a drop-down list content control. 
D)  Create a picture content control. 
A)  Create a text box content control. 
B)  Create a date picker content control. 
C)  Create a drop-down list content control. 
D)  Create a picture content control.

Question 10

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 11

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

Accepted Answer

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

Question 12

Elijah needs to move information from the last row in a table to the second from the top row of the table. He should do which of the following?

Accepted Answer

A)  Copy the last row of the table and then insert the data as a new row after the top row. 
B)  Cut the last row of the table and then insert the data as a new row after the top row. 
C)  Copy the last row of the table and then overwrite the cells in the second from the top row. 
D)  Cut the last row of the table and then overwrite the cells in the second from the top row. 
A)  Copy the last row of the table and then insert the data as a new row after the top row. 
B)  Cut the last row of the table and then insert the data as a new row after the top row. 
C)  Copy the last row of the table and then overwrite the cells in the second from the top row. 
D)  Cut the last row of the table and then overwrite the cells in the second from the top row.

Question 13

Xavier is experimenting with different layouts for a table. To try out different heights for a row, he should do which of the following?

Accepted Answer

A)  Select Draw Table and modify the table as desired. 
B)  Drag the row border to resize the height to an approximate value. 
C)  Select the row and press Delete. 
D)  Select the row and press Split Cells. 
A)  Select Draw Table and modify the table as desired. 
B)  Drag the row border to resize the height to an approximate value. 
C)  Select the row and press Delete. 
D)  Select the row and press Split Cells.

Question 14

To prevent people from editing a document, which of the following should be done?

Accepted Answer

A)  Set the document macro security settings to disable all macros with notification. 
B)  Set the document macro security settings to disable all macros except digitally signed macros. 
C)  Enable document editing restrictions. 
D)  Enable document formatting restrictions. 
A)  Set the document macro security settings to disable all macros with notification. 
B)  Set the document macro security settings to disable all macros except digitally signed macros. 
C)  Enable document editing restrictions. 
D)  Enable document formatting restrictions.

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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.

Question 17

To edit the placeholder text of a rich text content control, which of the following should be done?

Accepted Answer

A)  Modify the content control properties. 
B)  Group the content control. 
C)  Enter text in the content control. 
D)  Enter design mode and modify the placeholder text directly. 
A)  Modify the content control properties. 
B)  Group the content control. 
C)  Enter text in the content control. 
D)  Enter design mode and modify the placeholder text directly.

Question 18

To add a content control that allows users to select from a variety of AutoText options, add a plain text content control.

Accepted Answer

A) True 
 B)False

Question 19

Jada needs the text in a cell to be rotated 90 degrees to the right. She should do which of the following?

Accepted Answer

A)  Click the Align Center Right button. 
B)  Click the Text Direction button. 
C)  Click the Sort button. 
D)  Click the Insert Right button. 
A)  Click the Align Center Right button. 
B)  Click the Text Direction button. 
C)  Click the Sort button. 
D)  Click the Insert Right button.

Question 20

To add choices to a drop-down content control, which of the following should be done?

Accepted Answer

A)  Modify the content control properties. 
B)  Modify the content control style. 
C)  Modify the content control paragraph alignment. 
D)  Modify the content control indent. 
A)  Modify the content control properties. 
B)  Modify the content control style. 
C)  Modify the content control paragraph alignment. 
D)  Modify the content control indent.

To add a border to a table, modify the table shading.

To set the style for text typed into a content control, which of the following should be done?

Aaron needs a drop-down list content control to be orange. He should do which of the following?

Samantha created a survey for distribution. She wants to ensure people taking the survey are only able to fill in the form, without making changes to the form itself. She should apply which type of editing restrictions?

To prevent people from making any changes to a document, which of the following should be done?

Josiah needs a row to be exactly 0.5 inches tall. He should do which of the following?

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

Jeremy needs to prevent people from modifying the formatting of a document. He should do which of the following?

Sherri needs the people viewing a document to enter information in the document. She needs people to enter one of three choices. She should do which of the following?

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

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

Elijah needs to move information from the last row in a table to the second from the top row of the table. He should do which of the following?

Xavier is experimenting with different layouts for a table. To try out different heights for a row, he should do which of the following?

To prevent people from editing a document, which of the following should be done?

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

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

To edit the placeholder text of a rich text content control, which of the following should be done?

To add a content control that allows users to select from a variety of AutoText options, add a plain text content control.

Jada needs the text in a cell to be rotated 90 degrees to the right. She should do which of the following?

To add choices to a drop-down content control, 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 add a border to a table, modify the table shading.

To set the style for text typed into a content control, which of the following should be done?

Aaron needs a drop-down list content control to be orange. He should do which of the following?

Samantha created a survey for distribution. She wants to ensure people taking the survey are only able to fill in the form, without making changes to the form itself. She should apply which type of editing restrictions?

To prevent people from making any changes to a document, which of the following should be done?

Josiah needs a row to be exactly 0.5 inches tall. He should do which of the following?

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

Jeremy needs to prevent people from modifying the formatting of a document. He should do which of the following?

Sherri needs the people viewing a document to enter information in the document. She needs people to enter one of three choices. She should do which of the following?

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

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

Elijah needs to move information from the last row in a table to the second from the top row of the table. He should do which of the following?

Xavier is experimenting with different layouts for a table. To try out different heights for a row, he should do which of the following?

To prevent people from editing a document, which of the following should be done?

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

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

To edit the placeholder text of a rich text content control, which of the following should be done?

To add a content control that allows users to select from a variety of AutoText options, add a plain text content control.

Jada needs the text in a cell to be rotated 90 degrees to the right. She should do which of the following?

To add choices to a drop-down content control, 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