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

Question 1

To apply a macro to a document,run the macro.

Answer 1

True

Question 2

To view a list of macros in a document,click the Macros button in the Developer tab.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

To make a picture in a document appear as if it were sketched using pencils,apply a picture style to the picture.

Question 5

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

Question 6

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

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

Question 7

To group shapes,make sure their text wrapping is set to In Line with Text.

Question 8

To change the color saturation of a picture,use Word's Color function.

Question 9

Which of the following describes the results of hiding text in Word?

A) The text is moved to the clipboard.
B) The text is deleted from the document.
C) The text does not appear in the document.
D) The text is moved to a comment.

Question 10

A character style includes text formatting information but not paragraph formatting information.

Question 11

To create a macro by writing the computer code directly,which of the following should be done?

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

Question 12

When checking spelling and grammar in a document written using a language other than English,make sure to do which of the following?

A) Check the document for accessibility.
B) Use the thesaurus.
C) Enable tracked changes.
D) Set the proofing language.

Question 13

To change the color tone of a picture,apply a picture effect to the picture.

Question 14

To replace a picture in a document,use the Change Picture function.

Question 15

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

Question 16

To have shapes in a document behave as a single object,group the shapes.

Question 17

Word enables you to customize the status bar to display a variety of information.

Question 18

To hide text from a document,apply a text effect.

Question 19

Aaron needs to create a style that specifies the indentation of text.He should create a character style.

Question 20

To make changes to a preexisting macro,which of the following should be done?

A) Edit the macro in the Visual Basic window.
B) Record the macro.
C) Modify the document properties.
D) Enter Design Mode.

Question 21

To have multiple pictures in a document behave like a single object,which of the following should be done?

A) Align the pictures to the bottom.
B) Send the pictures to the front.
C) Change the text wrapping of the pictures.
D) Group the pictures.

Question 22

To have multiple shapes in a document behave like a single object,which of the following should be done?

A) Apply Shape Effects to the shapes.
B) Group the shapes.
C) Align the shapes.
D) Edit the shapes.

Question 23

To make a picture in a document appear as if it was painted using a brush,which of the following should be done?

A) Apply a correction to the picture.
B) Modify the picture color.
C) Apply a picture style.
D) Apply an artistic effect.

Question 24

To have a picture appear slightly rotated into the page,which of the following should be done?

A) Apply a picture effect.
B) Apply a picture layout.
C) Apply an artistic effect.
D) Apply a correction.

Question 25

To change the color tone of a picture,which of the following should be done?

A) Click the Picture Layout button and select the desired option.
B) Click the Corrections button and select the desired option.
C) Click the Artistic Effects button and select the desired option.
D) Click the Color button and select the desired option.

Question 26

To add an electronic,encrypted,stamp of authentication to a Word document,which of the following should be done?

A) Add a watermark.
B) Add a digital signature.
C) Add a signature line.
D) Add a header.

Question 27

To apply a macro to a document,which of the following should be done?

A) Add the macro to the Quick Access Toolbar.
B) View the macro in the Visual Basic window.
C) Run the macro.
D) Insert a rich text content control.

Question 28

To make changes to a preexisting macro,which of the following should be done?

A) Edit the macro in the Visual Basic window.
B) Record the macro.
C) Modify the document properties.
D) Enter Design Mode.

Question 29

Which of the following styles is a character style?

A) A style that defines indentation and font size
B) A style that defines indentation and paragraph alignment
C) A style that defines font color and font size
D) A style that defines font color and paragraph alignment

Question 30

Samantha needs to create a style that specifies the font color and size of text.She should create which of the following?

A) A character style.
B) A paragraph style.
C) A document theme.
D) A document watermark.

Question 31

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

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

Question 32

To replace a picture in a document with another picture,which of the following should be done?

A) Compress the picture.
B) Reset the picture.
C) Change the picture.
D) Remove the picture background.

Question 33

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

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

Question 34

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

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 35

To create a macro by performing the steps,which of the following should be done?

A) Create the macro by recording it.
B) Create the macro using the Visual Basic window.
C) Create the macro by modifying the document's macro security.
D) Create the macro by modifying the document properties.

Question 36

Amanda wants to use styles she created in one document in another document.She should do which of the following?

A) Copy the styles to the other document using the Manage Styles command.
B) Copy the styles to the other document using the Compare documents command.
C) Copy text from the source document and paste it in the destination document using the Keep Source Formatting option.
D) Copy text from the source document and paste it in the destination document using the Merge Formatting option.

Question 37

To temporarily suspend recording steps into a macro,which of the following should be done?

A) Pause recording.
B) Enter Design Mode.
C) Open the XML Mapping pane.
D) Open the Visual Basic window.

Question 38

To prompt the user for input after creating a document from a template,which of the following should be done?

A) Insert a text box.
B) Insert a plain text content control.
C) Insert a comment.
D) Insert a fill-in field in the document.

Question 39

To allow people to sign a document,which of the following should be done?

A) Add a document header.
B) Add a digital signature to the document.
C) Add a hyperlink to the document.
D) Add a signature line to the document.

Question 40

To change the color saturation of a picture,which of the following should be done?

A) Click the Color button and select the desired option.
B) Click the Corrections button and select the desired option.
C) Click the Artistic Effects button and select the desired option.
D) Click the Picture Layout button and select the desired option.

Question 41

Damien needs a line of text to be removed from a document on an as needed basis.He should do which of the following when he wants to remove the text?

A) Format the text as hidden.
B) Format the text as small caps.
C) Format the text as superscript.
D) Format the text as subscript.

Question 42

Tara needs to prevent people from making changes to a document that she plans to distribute.She should do which of the following?

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

Question 43

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

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

Question 44

To make a picture appear grayscale,which of the following should be done?

A) Change the color saturation to 0%.
B) Change the color saturation to 50%.
C) Change the color saturation to 100%.
D) Change the color saturation to 400%.

Question 45

To guarantee that the individual sending a document really is who he or she claims to be,which of the following should be done?

A) Add a watermark.
B) Add a digital signature.
C) Add a header.
D) Check the document for accessibility.

Question 46

Nina needs a picture in a document to appear as if it were tilted in perspective.She should do which of the following?

A) Apply a 3-D artistic effect.
B) Apply a 3-D picture effect.
C) Apply a 3-D picture layout.
D) Apply a 3-D correction.

Question 47

To transfer all data in a table to text separated by tabs,which of the following should be done?

A) Change the alignment of the table.
B) Apply a table style to the table.
C) Convert the table to text.
D) Apply shading to the table.

Question 48

Darren needs a picture in his document to appear as if it was painted using a brush.He should do which of the following?

A) Modify the picture color.
B) Apply a correction to the picture.
C) Apply an artistic effect.
D) Apply a picture style.

Question 49

Erin needs to move multiple pictures around in a document as if they were a single object.She should do which of the following?

A) Group the pictures.
B) Send the pictures to the front.
C) Align the pictures to the bottom.
D) Change the text wrapping of the pictures.

Question 50

Karen needs to replace a picture in a document with an updated version of the picture? She should do which of the following?

A) Remove the picture background.
B) Reset the picture.
C) Change the picture.
D) Compress the picture.

Question 51

Katie is working on a document written in German.She wants to check the document for spelling errors.Before running spell check,she should do which of the following?

A) Enable tracked changes.
B) Set the proofing language.
C) Use the thesaurus.
D) Check the document for accessibility.

Question 52

Amy created a contract that she needs people to sign.She should do which of the following?

A) Add a digital signature to the document.
B) Add a signature line to the document.
C) Add a hyperlink to the document.
D) Add a document header.

Question 53

Adrian needs to create a style that specifies the font and character spacing of text.She should create which of the following?

A) A document watermark
B) A paragraph style
C) A document theme
D) A character style

Question 54

To transfer all data in a table to text separated by tabs,convert the table to text.

Question 55

Kim wants a picture in a document to appear as if it was drawn using chalk.She should do which of the following?

A) Apply a picture style.
B) Modify the picture color.
C) Apply a correction to the picture.
D) Apply an artistic effect.

Question 56

Amanda needs a picture to have a warmer color tone.She should do which of the following?

A) Click the Artistic Effects button and select the desired option.
B) Click the Color button and select the desired option.
C) Click the Picture Layout button and select the desired option.
D) Click the Corrections button and select the desired option.