Question 1

To specify how a shape interacts with the text around it,modify the text wrapping of the shape.
​

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

To copy formatting from one selection of text to another,use the Format Painter.

Accepted Answer

A) True 
 B)False

Question 4

Laila needs to change the formatting of a table.To do so,which of the following does she need to do first?

Accepted Answer

A)  Select a row in the table. 
B)  Select the table. 
C)  Select a column in the table. 
A)  Select a row in the table. 
B)  Select the table. 
C)  Select a column in the table.

Question 5

When you recolor a picture,you use the Paintbrush tool to add color to parts of the picture.

Accepted Answer

A) True 
 B)False

Question 6

Chloe notices that when she inserts a tab character,her insertion point moves to the right side of the page and the text she enters is right-justified.She does not want tab characters to behave this way.She should do which of the following?

Accepted Answer

A)  Change the paragraph justification. 
B)  Remove the tab stop. 
C)  Remove the paragraph. 
D)  Change the paragraph spacing. 
A)  Change the paragraph justification. 
B)  Remove the tab stop. 
C)  Remove the paragraph. 
D)  Change the paragraph spacing.

Question 7

Nathan needs more room to add another entry in a table.To do so,he should insert a row.

Accepted Answer

A) True 
 B)False

Question 8

To right-justify text at a tab stop,change the tab stop alignment options.

Accepted Answer

A) True 
 B)False

Question 9

To add a shadow to a picture,click the Picture Border button.

Accepted Answer

A) True 
 B)False

Question 10

Caleb needs to copy a picture from one document and paste it in another document in such a way that it retains the original appearance.He should use which of the following paste options?

Accepted Answer

A)  Use Destination Theme 
B)  Keep Source Formatting 
C)  Keep Text Only 
A)  Use Destination Theme 
B)  Keep Source Formatting 
C)  Keep Text Only

Question 11

Jeremiah needs to organize information in his document using rows and columns.He should insert a table.

Accepted Answer

A) True 
 B)False

Question 12

To specify the location the cursor stops after the tab key is pressed,create a hanging indent.

Accepted Answer

A) True 
 B)False

Question 13

Laila needs the pictures in her document to be distributed vertically.She should do which of the following?

Accepted Answer

A)  Press the Position button and select the desired option. 
B)  Press the Align button and select the desired option. 
C)  Press the Wrap Text button and select the desired option. 
D)  Press the Corrections button and select the desired option. 
A)  Press the Position button and select the desired option. 
B)  Press the Align button and select the desired option. 
C)  Press the Wrap Text button and select the desired option. 
D)  Press the Corrections button and select the desired option.

Question 14

Brianna needs the rows in a table to alternate colors.She should do which of the following?

Accepted Answer

A)  Manually apply alternating fill colors to each row. 
B)  Select the table and apply a table style with banded rows. 
C)  Modify the table border style. 
D)  Click Distribute Rows. 
A)  Manually apply alternating fill colors to each row. 
B)  Select the table and apply a table style with banded rows. 
C)  Modify the table border style. 
D)  Click Distribute Rows.

Question 15

Makayla needs text to appear above and below a shape on the page.She should set the text wrapping of the shape to which of the following?

Accepted Answer

A)  Square 
B)  Tight 
C)  Top and Bottom 
D)  Through 
A)  Square 
B)  Tight 
C)  Top and Bottom 
D)  Through

Question 16

Jeremiah has inserted a table and needs to fill it with data.After entering a value,he should do which of the following to advance the curser to the next cell in the table?

Accepted Answer

A)  Press TAB. 
B)  Press ENTER. 
C)  Press ESC. 
D)  Press INSERT. 
A)  Press TAB. 
B)  Press ENTER. 
C)  Press ESC. 
D)  Press INSERT.

Question 17

To recolor a picture with a green tint,which of the following should be done?

Accepted Answer

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

Question 18

To ensure that the edges of several pictures line up,align the pictures.

Accepted Answer

A) True 
 B)False

Question 19

Jaylen needs a shape in her document to have the same formatting as another shape in her document.She should do which of the following?

Accepted Answer

A)  Use the Clipboard. 
B)  Use Smart Lookup. 
C)  Use the Tell Me box. 
D)  Use the Formatting Painter. 
A)  Use the Clipboard. 
B)  Use Smart Lookup. 
C)  Use the Tell Me box. 
D)  Use the Formatting Painter.

Question 20

Makayla needs to select the entire line of cells in a table going from left to right.She needs to select a column.

Accepted Answer

A) True 
 B)False

To specify how a shape interacts with the text around it,modify the text wrapping of the shape.

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

To copy formatting from one selection of text to another,use the Format Painter.

Laila needs to change the formatting of a table.To do so,which of the following does she need to do first?

When you recolor a picture,you use the Paintbrush tool to add color to parts of the picture.

Chloe notices that when she inserts a tab character,her insertion point moves to the right side of the page and the text she enters is right-justified.She does not want tab characters to behave this way.She should do which of the following?

Nathan needs more room to add another entry in a table.To do so,he should insert a row.

To right-justify text at a tab stop,change the tab stop alignment options.

To add a shadow to a picture,click the Picture Border button.

Caleb needs to copy a picture from one document and paste it in another document in such a way that it retains the original appearance.He should use which of the following paste options?

Jeremiah needs to organize information in his document using rows and columns.He should insert a table.

To specify the location the cursor stops after the tab key is pressed,create a hanging indent.

Laila needs the pictures in her document to be distributed vertically.She should do which of the following?

Brianna needs the rows in a table to alternate colors.She should do which of the following?

Makayla needs text to appear above and below a shape on the page.She should set the text wrapping of the shape to which of the following?

Jeremiah has inserted a table and needs to fill it with data.After entering a value,he should do which of the following to advance the curser to the next cell in the table?

To recolor a picture with a green tint,which of the following should be done?

To ensure that the edges of several pictures line up,align the pictures.

Jaylen needs a shape in her document to have the same formatting as another shape in her document.She should do which of the following?

Makayla needs to select the entire line of cells in a table going from left to right.She needs to select a column.

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

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

To specify how a shape interacts with the text around it,modify the text wrapping of the shape. ​

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

To copy formatting from one selection of text to another,use the Format Painter.

Laila needs to change the formatting of a table.To do so,which of the following does she need to do first?

When you recolor a picture,you use the Paintbrush tool to add color to parts of the picture.

Chloe notices that when she inserts a tab character,her insertion point moves to the right side of the page and the text she enters is right-justified.She does not want tab characters to behave this way.She should do which of the following?

Nathan needs more room to add another entry in a table.To do so,he should insert a row.

To right-justify text at a tab stop,change the tab stop alignment options.

To add a shadow to a picture,click the Picture Border button.

Caleb needs to copy a picture from one document and paste it in another document in such a way that it retains the original appearance.He should use which of the following paste options?

Jeremiah needs to organize information in his document using rows and columns.He should insert a table.

To specify the location the cursor stops after the tab key is pressed,create a hanging indent.

Laila needs the pictures in her document to be distributed vertically.She should do which of the following?

Brianna needs the rows in a table to alternate colors.She should do which of the following?

Makayla needs text to appear above and below a shape on the page.She should set the text wrapping of the shape to which of the following?

Jeremiah has inserted a table and needs to fill it with data.After entering a value,he should do which of the following to advance the curser to the next cell in the table?

To recolor a picture with a green tint,which of the following should be done?

To ensure that the edges of several pictures line up,align the pictures.

Jaylen needs a shape in her document to have the same formatting as another shape in her document.She should do which of the following?

Makayla needs to select the entire line of cells in a table going from left to right.She needs to select a column.

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

To specify how a shape interacts with the text around it,modify the text wrapping of the shape.