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

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

(Multiple Choice)

4.8/5

(36)

Question 21

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

(Multiple Choice)

4.8/5

(32)

Question 22

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

(Multiple Choice)

4.9/5

(39)

Question 23

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?

(Multiple Choice)

4.8/5

(30)

Question 24

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

(Multiple Choice)

4.8/5

(42)

Question 25

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

(True/False)

4.9/5

(32)

Question 26

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

(Multiple Choice)

4.8/5

(32)

Question 27

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

(Multiple Choice)

5.0/5

(37)

Question 28

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

(Multiple Choice)

4.8/5

(37)

Question 29

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

(Multiple Choice)

4.8/5

(30)

Question 30

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

(True/False)

4.9/5

(35)

Question 31

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

(Multiple Choice)

4.9/5

(33)

Question 32

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

(True/False)

4.7/5

(38)

Question 33

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?

(Multiple Choice)

4.9/5

(30)

Question 34

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

(True/False)

4.8/5

(33)

Question 35

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

(Multiple Choice)

4.8/5

(32)

Question 36

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

(Multiple Choice)

4.8/5

(33)

Question 37

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

(True/False)

4.9/5

(40)

Question 38

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

(Multiple Choice)

4.9/5

(40)

Question 39

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

(True/False)

4.7/5

(29)

Question 40

Showing 21 - 40 of 56

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

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

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

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?

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

Working With Multiple Worksheets and Workbooks

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

Filters