Question 1

To copy styles from one document to another, which of the following should be done?

Accepted Answer

A)  Use the Manage Styles command. 
B)  Use the Style Inspector command. 
C)  Use the Styles pane. 
D)  Use the Navigation pane. 
A)  Use the Manage Styles command. 
B)  Use the Style Inspector command. 
C)  Use the Styles pane. 
D)  Use the Navigation pane.

Question 2

To record a macro, click the create macro button.

Accepted Answer

False - re

Question 3

To check a document written in Spanish for spelling and grammar errors, first set the proofing language.

Accepted Answer

A) True 
 B)False

Question 4

What are user-defined details about a file that describe its content and origin called?

Accepted Answer

A)  document properties 
B)  comments 
C)  formatting marks 
D)  references 
A)  document properties 
B)  comments 
C)  formatting marks 
D)  references

Question 5

Kayla wants light text to appear in the background of every page of a document, she should add a text watermark.

Accepted Answer

A) True 
 B)False

Question 6

To resize the width of a picture without changing the height, resize the picture nonproportionally.

Accepted Answer

A) True 
 B)False

Question 7

David needs an oval to appear in his document. He should do which of the following?

Accepted Answer

A)  Click the Chart button and select the desired option. 
B)  Click the Shapes button and select the desired option. 
C)  Click the Table button and select the desired option. 
D)  Click the WordArt button and select the desired option. 
A)  Click the Chart button and select the desired option. 
B)  Click the Shapes button and select the desired option. 
C)  Click the Table button and select the desired option. 
D)  Click the WordArt button and select the desired option.

Question 8

If you open a document and see field codes, you need to edit the field codes to see the resulting values.

Accepted Answer

False - to

Question 9

To display section information in the status bar, which of the following should be done?

Accepted Answer

A)  Insert a section break. 
B)  Display the Developer tab. 
C)  Split the view. 
D)  Customize the status bar. 
A)  Insert a section break. 
B)  Display the Developer tab. 
C)  Split the view. 
D)  Customize the status bar.

Question 10

Kyle needs the same text to appear at the top of each page in a document. Which of the following is the best method to achieve this?

Accepted Answer

A)  Edit the document header. 
B)  Manually enter the desired text at the top of each page. 
C)  Modify the Document Properties. 
D)  Add a comment at the top of each page. 
A)  Edit the document header. 
B)  Manually enter the desired text at the top of each page. 
C)  Modify the Document Properties. 
D)  Add a comment at the top of each page.

Question 11

To have text appear in the background of every page in a document, which of the following should be done?

Accepted Answer

A)  Insert a Text Box. 
B)  Insert a text watermark. 
C)  Insert WordArt. 
D)  Insert SmartArt. 
A)  Insert a Text Box. 
B)  Insert a text watermark. 
C)  Insert WordArt. 
D)  Insert SmartArt.

Question 12

To locate a tab character in a document, use the Find and Replace dialogue box and search for the appropriate special character.

Accepted Answer

A) True 
 B)False

Question 13

To ensure that the result of a formula in a table is accurate, which of the following should be done?

Accepted Answer

A)  Protect the document. 
B)  Check the document for spelling and grammar errors. 
C)  Inspect the document. 
D)  Update the corresponding field. 
A)  Protect the document. 
B)  Check the document for spelling and grammar errors. 
C)  Inspect the document. 
D)  Update the corresponding field.

Question 14

Sharon needs to view the document's character count in the status bar. She should do which of the following?

Accepted Answer

A)  Use the Go To command. 
B)  Customize the status bar. 
C)  Split the view. 
D)  Display the Developer tab. 
A)  Use the Go To command. 
B)  Customize the status bar. 
C)  Split the view. 
D)  Display the Developer tab.

Question 15

Amanda found code that she wants to use for a macro in one of her textbooks. She should do which of the following?

Accepted Answer

A)  Modify the document header. 
B)  Modify the document properties. 
C)  Record a macro. 
D)  Enter the code into a macro using the Visual Basic window. 
A)  Modify the document header. 
B)  Modify the document properties. 
C)  Record a macro. 
D)  Enter the code into a macro using the Visual Basic window.

Question 16

To prompt the user for input after creating a document from a template, make sure the template contains a fill-in field.

Accepted Answer

A) True 
 B)False

Question 17

To insert a document property in a header, first which of the following should be done?

Accepted Answer

A)  Click the Link button. 
B)  Click the Icons button. 
C)  Click the Chart button. 
D)  Click the Quick Parts button. 
A)  Click the Link button. 
B)  Click the Icons button. 
C)  Click the Chart button. 
D)  Click the Quick Parts button.

Question 18

Katlyn needs to remove all tab characters from a document. She should locate the tab characters by doing which of the following?

Accepted Answer

A)  Use Go To to locate the desired text. 
B)  Manually locate tab characters by scrolling through the document. 
C)  Use the Find and Replace dialogue box to locate the tab characters. 
A)  Use Go To to locate the desired text. 
B)  Manually locate tab characters by scrolling through the document. 
C)  Use the Find and Replace dialogue box to locate the tab characters.

Question 19

To remove all document properties from a file, which of the following do you do?

Accepted Answer

A)  Close the file and reopen it. 
B)  Save the document as a new file. 
C)  Check the document's accessibility. 
D)  Inspect the document. 
A)  Close the file and reopen it. 
B)  Save the document as a new file. 
C)  Check the document's accessibility. 
D)  Inspect the document.

Question 20

To have a picture appear slightly rotated into the page, apply a 3-D rotation picture effect.

Accepted Answer

A) True 
 B)False

To copy styles from one document to another, which of the following should be done?

To record a macro, click the create macro button.

To check a document written in Spanish for spelling and grammar errors, first set the proofing language.

What are user-defined details about a file that describe its content and origin called?

Kayla wants light text to appear in the background of every page of a document, she should add a text watermark.

To resize the width of a picture without changing the height, resize the picture nonproportionally.

David needs an oval to appear in his document. He should do which of the following?

If you open a document and see field codes, you need to edit the field codes to see the resulting values.

To display section information in the status bar, which of the following should be done?

Kyle needs the same text to appear at the top of each page in a document. Which of the following is the best method to achieve this?

To have text appear in the background of every page in a document, which of the following should be done?

To locate a tab character in a document, use the Find and Replace dialogue box and search for the appropriate special character.

To ensure that the result of a formula in a table is accurate, which of the following should be done?

Sharon needs to view the document's character count in the status bar. She should do which of the following?

Amanda found code that she wants to use for a macro in one of her textbooks. She should do which of the following?

To prompt the user for input after creating a document from a template, make sure the template contains a fill-in field.

To insert a document property in a header, first which of the following should be done?

Katlyn needs to remove all tab characters from a document. She should locate the tab characters by doing which of the following?

To remove all document properties from a file, which of the following do you do?

To have a picture appear slightly rotated into the page, apply a 3-D rotation picture effect.

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

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Filters

Exam 8: Performing What-If Analyses

To copy styles from one document to another, which of the following should be done?

To record a macro, click the create macro button.

To check a document written in Spanish for spelling and grammar errors, first set the proofing language.

What are user-defined details about a file that describe its content and origin called?

Kayla wants light text to appear in the background of every page of a document, she should add a text watermark.

To resize the width of a picture without changing the height, resize the picture nonproportionally.

David needs an oval to appear in his document. He should do which of the following?

If you open a document and see field codes, you need to edit the field codes to see the resulting values.

To display section information in the status bar, which of the following should be done?

Kyle needs the same text to appear at the top of each page in a document. Which of the following is the best method to achieve this?

To have text appear in the background of every page in a document, which of the following should be done?

To locate a tab character in a document, use the Find and Replace dialogue box and search for the appropriate special character.

To ensure that the result of a formula in a table is accurate, which of the following should be done?

Sharon needs to view the document's character count in the status bar. She should do which of the following?

Amanda found code that she wants to use for a macro in one of her textbooks. She should do which of the following?

To prompt the user for input after creating a document from a template, make sure the template contains a fill-in field.

To insert a document property in a header, first which of the following should be done?

Katlyn needs to remove all tab characters from a document. She should locate the tab characters by doing which of the following?

To remove all document properties from a file, which of the following do you do?

To have a picture appear slightly rotated into the page, apply a 3-D rotation picture effect.

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

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Filters