Question 1

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 2

To divide a cell, click Merge Cells.

Accepted Answer

False - sp

Question 3

To create a content control that allows people to place a check in a box, which of the following should be done?

Accepted Answer

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

Question 4

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 5

To add choices to a combo box content control, which of the following should be done?

Accepted Answer

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

Question 6

To automatically resize the columns in a table to fit the contents of cells, click Distribute Columns.

Accepted Answer

A) True 
 B)False

Question 7

To create two tables from a single table, click Split Table.

Accepted Answer

A) True 
 B)False

Question 8

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 9

To uniquely identify a content control in a document, which of the following should be done?

Accepted Answer

A)  Modify the content control's tag. 
B)  Group the content control. 
C)  Apply shading to the content control. 
D)  Change the paragraph alignment of the content control. 
A)  Modify the content control's tag. 
B)  Group the content control. 
C)  Apply shading to the content control. 
D)  Change the paragraph alignment of the content control.

Which of the following describes the purpose of Design mode?

To divide a cell, click Merge Cells.

To create a content control that allows people to place a check in a box, which of the following should be done?

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 add choices to a combo box content control, which of the following should be done?

To automatically resize the columns in a table to fit the contents of cells, click Distribute Columns.

To create two tables from a single table, click Split Table.

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

To uniquely identify a content control in a document, 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

Which of the following describes the purpose of Design mode?

To divide a cell, click Merge Cells.

To create a content control that allows people to place a check in a box, which of the following should be done?

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 add choices to a combo box content control, which of the following should be done?

To automatically resize the columns in a table to fit the contents of cells, click Distribute Columns.

To create two tables from a single table, click Split Table.

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

To uniquely identify a content control in a document, 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