Exam 3: Working With Large Worksheets, Charting, and What-If Analysis

Explore all topics

Nathan is creating a document that needs to be accessible to people with visual impairment.He should do what to the pictures in the document?

(Multiple Choice)

4.8/5

(30)

Question 61

Hannah needs a picture to be positioned in the middle and center of a page.After applying Square text wrapping to the picture,she should do which of the following?

(Multiple Choice)

4.9/5

(33)

Question 62

To decrease the font size by two points,press CTRL+SHIFT+<.

(True/False)

4.9/5

(34)

Question 63

To quickly change the outline,fill,and font color of a SmartArt shape,which of the following should be done?

(Multiple Choice)

4.9/5

(37)

Question 64

Nevaeh needs a paragraph border to be very thick.He should do which of the following?

(Multiple Choice)

4.9/5

(42)

Question 65

Press CTRL+SHIFT+> to increase the font size by two points.

(True/False)

5.0/5

(31)

Question 66

Alexis needs the text after a tab character to be moved further to the right.She should do which of the following?

(Multiple Choice)

5.0/5

(27)

Question 67

To ensure a document with a table can be interpreted by people with vision impairment,make sure to do which of the following?

(Multiple Choice)

4.8/5

(32)

Question 68

Sydney has created a table with two columns to store the name and address of clients.She needs to add additional information about phone numbers.She should do which of the following?

(Multiple Choice)

4.7/5

(36)

Question 69

Alyssa needs a paragraph to have a dotted border.She should do which of the following?

(Multiple Choice)

4.7/5

(32)

Question 70

Alexandra wants text to appear within a circle shape in her document.She should do which of the following?

(Multiple Choice)

5.0/5

(33)

Question 71

To move an inline picture,which of the following should be done?

(Multiple Choice)

4.7/5

(34)

Question 72

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

(Multiple Choice)

4.7/5

(33)

Question 73

To insert a text box,click the SmartArt button.

(True/False)

4.8/5

(42)

Question 74

Alexis needs to remove an entry going from left to right in a table.She first needs to do which of the following?

(Multiple Choice)

4.9/5

(34)

Question 75

Showing 61 - 75 of 75

Nathan is creating a document that needs to be accessible to people with visual impairment.He should do what to the pictures in the document?

Hannah needs a picture to be positioned in the middle and center of a page.After applying Square text wrapping to the picture,she should do which of the following?

To decrease the font size by two points,press CTRL+SHIFT+<.

To quickly change the outline,fill,and font color of a SmartArt shape,which of the following should be done?

Nevaeh needs a paragraph border to be very thick.He should do which of the following?

Press CTRL+SHIFT+> to increase the font size by two points.

Alexis needs the text after a tab character to be moved further to the right.She should do which of the following?

To ensure a document with a table can be interpreted by people with vision impairment,make sure to do which of the following?

Sydney has created a table with two columns to store the name and address of clients.She needs to add additional information about phone numbers.She should do which of the following?

Alyssa needs a paragraph to have a dotted border.She should do which of the following?

Alexandra wants text to appear within a circle shape in her document.She should do which of the following?

To move an inline picture,which of the following should be done?

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

To insert a text box,click the SmartArt button.

Alexis needs to remove an entry going from left to right in a table.She first needs to do which of the following?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

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

Filters