Question 1

A Style set defines font and paragraph settings for headings and body text.

Accepted Answer

A) True 
 B)False

Question 2

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 3

To email a document to clients who may or may not have Microsoft Office installed,which of the following should be done?

Accepted Answer

A)  Email the document as a .pdf file. 
B)  Email the document as a .xml file. 
C)  Email the document as a .docx file. 
D)  Email the document as a .doc file. 
A)  Email the document as a .pdf file. 
B)  Email the document as a .xml file. 
C)  Email the document as a .docx file. 
D)  Email the document as a .doc file.

Question 4

Makayla has an email address in her document.She wants people to be able to CTRL+click the email address to send an email to the address.She should do which of the following?

Accepted Answer

A)  Add a text effect to the email address. 
B)  Add a hyperlink to the email address. 
C)  Apply shading to the email address. 
D)  Apply a style to the email address. 
A)  Add a text effect to the email address. 
B)  Add a hyperlink to the email address. 
C)  Apply shading to the email address. 
D)  Apply a style to the email address.

Question 5

To enable people reading a document to easily send an email to an email address,which of the following should be done?

Accepted Answer

A)  Insert the email address as a hyperlink. 
B)  Insert the email address in the document header. 
C)  Insert the email address as SmartArt. 
D)  Insert the email address as WordArt. 
A)  Insert the email address as a hyperlink. 
B)  Insert the email address in the document header. 
C)  Insert the email address as SmartArt. 
D)  Insert the email address as WordArt.

Question 6

To view exactly which formats are applied to the character,paragraph,and section of selected text,which of the following should be done?

Accepted Answer

A)  Use the Navigation pane. 
B)  Use the Reveal Formatting task pane. 
C)  Use the Researcher pane. 
D)  Use the Smart Lookup pane. 
A)  Use the Navigation pane. 
B)  Use the Reveal Formatting task pane. 
C)  Use the Researcher pane. 
D)  Use the Smart Lookup pane.

Question 7

To specify the color palette of a document,which of the following should be done?

Accepted Answer

A)  Create custom theme colors. 
B)  Create custom theme fonts. 
C)  Create custom theme effects. 
A)  Create custom theme colors. 
B)  Create custom theme fonts. 
C)  Create custom theme effects.

Question 8

Which of the following is an example of a building block?

Accepted Answer

A)  a Quick Part 
B)  a Reference 
C)  a Footnote 
D)  a Style 
A)  a Quick Part 
B)  a Reference 
C)  a Footnote 
D)  a Style

Question 9

Karen needs to create a specific color palette for her document.She should do which of the following?

Accepted Answer

A)  Modify the document properties. 
B)  Create custom theme colors. 
C)  Insert a header. 
D)  Change the page orientation. 
A)  Modify the document properties. 
B)  Create custom theme colors. 
C)  Insert a header. 
D)  Change the page orientation.

Question 10

Sharon needs to send a document to clients who may or may not have Microsoft Office installed.She should send the document as a PDF.

Accepted Answer

A) True 
 B)False

Question 11

To have text appear over a hyperlink when you hover your mouse over the link,add ScreenTip text to the link.

Accepted Answer

A) True 
 B)False

Question 12

To see how your documents will look if used in an online environment.

Accepted Answer

A)  Read Mode. 
B)  Print Layout view. 
C)  Web Layout view. 
D)  Outline view. 
A)  Read Mode. 
B)  Print Layout view. 
C)  Web Layout view. 
D)  Outline view.

A Style set defines font and paragraph settings for headings and body text.

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 email a document to clients who may or may not have Microsoft Office installed,which of the following should be done?

Makayla has an email address in her document.She wants people to be able to CTRL+click the email address to send an email to the address.She should do which of the following?

To enable people reading a document to easily send an email to an email address,which of the following should be done?

To view exactly which formats are applied to the character,paragraph,and section of selected text,which of the following should be done?

To specify the color palette of a document,which of the following should be done?

Which of the following is an example of a building block?

Karen needs to create a specific color palette for her document.She should do which of the following?

Sharon needs to send a document to clients who may or may not have Microsoft Office installed.She should send the document as a PDF.

To have text appear over a hyperlink when you hover your mouse over the link,add ScreenTip text to the link.

To see how your documents will look if used in an online environment.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel

Filters

Exam 5: Working With Multiple Worksheets and Workbooks

A Style set defines font and paragraph settings for headings and body text.

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 email a document to clients who may or may not have Microsoft Office installed,which of the following should be done?

Makayla has an email address in her document.She wants people to be able to CTRL+click the email address to send an email to the address.She should do which of the following?

To enable people reading a document to easily send an email to an email address,which of the following should be done?

To view exactly which formats are applied to the character,paragraph,and section of selected text,which of the following should be done?

To specify the color palette of a document,which of the following should be done?

Which of the following is an example of a building block?

Karen needs to create a specific color palette for her document.She should do which of the following?

Sharon needs to send a document to clients who may or may not have Microsoft Office installed.She should send the document as a PDF.

To have text appear over a hyperlink when you hover your mouse over the link,add ScreenTip text to the link.

To see how your documents will look if used in an online environment.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, Visual Basic for Applications Vba, and Collaboration Features in Excel

Filters