Question 1

To specify the right edge of a paragraph,which of the following should be done?

Accepted Answer

A)  Drag the right indent marker. 
B)  Drag the left indent marker. 
C)  Drag the first line indent marker. 
D)  Drag the hanging indent marker. 
A)  Drag the right indent marker. 
B)  Drag the left indent marker. 
C)  Drag the first line indent marker. 
D)  Drag the hanging indent marker.

Question 2

Jasmine needs to modify the right boundary of a paragraph.She should do which of the following?

Accepted Answer

A)  Drag the left indent marker. 
B)  Drag the hanging indent marker. 
C)  Drag the right indent marker. 
D)  Drag the first line indent marker. 
A)  Drag the left indent marker. 
B)  Drag the hanging indent marker. 
C)  Drag the right indent marker. 
D)  Drag the first line indent marker.

Question 3

Joan needs to calculate the average of a column of cells in a table.She should do which of the following?

Accepted Answer

A)  Insert Document Info in the table. 
B)  Insert a Quick Part in the table. 
C)  Convert the table to text. 
D)  Insert a formula in the table. 
A)  Insert Document Info in the table. 
B)  Insert a Quick Part in the table. 
C)  Convert the table to text. 
D)  Insert a formula in the table.

Question 4

To join two cells into a single cell,click Merge Cells.

Accepted Answer

A) True 
 B)False

Question 5

Nevaeh needs bullets in a list to appear like her company's logo.She should change the bullets to a picture.

Accepted Answer

A) True 
 B)False

Question 6

Brandon needs the outside border of a table to be red.He should do which of the following?

Accepted Answer

A)  Change the border Pen Color to red and then select the Outside Borders option. 
B)  Change the border Pen Color to red and then select the Inside Borders option. 
C)  Change the shading Color to red and then select the Outside Borders option. 
D)  Change the shading Color to red and then select the Inside Borders option. 
A)  Change the border Pen Color to red and then select the Outside Borders option. 
B)  Change the border Pen Color to red and then select the Inside Borders option. 
C)  Change the shading Color to red and then select the Outside Borders option. 
D)  Change the shading Color to red and then select the Inside Borders option.

Question 7

Kiara needs each column in a table to be 0.5 inches in width.She should do which of the following?

Accepted Answer

A)  Specify a fixed width for the columns. 
B)  Autofit content in the columns. 
C)  Click Distribute Columns. 
D)  Click Distribute Rows. 
A)  Specify a fixed width for the columns. 
B)  Autofit content in the columns. 
C)  Click Distribute Columns. 
D)  Click Distribute Rows.

Question 8

To position text midway between the top,bottom,left,and right of a table cell,which of the following should be done?

Accepted Answer

A)  Select the cell and click Align Bottom Center. 
B)  Select the cell and click Align Center Right. 
C)  Select the cell and click Align Center Left. 
D)  Select the cell and click Align Center. 
A)  Select the cell and click Align Bottom Center. 
B)  Select the cell and click Align Center Right. 
C)  Select the cell and click Align Center Left. 
D)  Select the cell and click Align Center.

Question 9

Xavier is experimenting with different layouts for a table.To try out different heights for a row,he should do which of the following?

Accepted Answer

A)  Select Draw Table and modify the table as desired. 
B)  Drag the row border to resize the height to an approximate value. 
C)  Select the row and press Delete. 
D)  Select the row and press Split Cells. 
A)  Select Draw Table and modify the table as desired. 
B)  Drag the row border to resize the height to an approximate value. 
C)  Select the row and press Delete. 
D)  Select the row and press Split Cells.

Question 10

To change the color of a bullet in a list,which of the following should be done?

Accepted Answer

A)  Change the document theme. 
B)  Click the Colors button and select the desired option. 
C)  Define a new bullet with the desired color. 
D)  Click the Theme Effects button and select the desired option. 
A)  Change the document theme. 
B)  Click the Colors button and select the desired option. 
C)  Define a new bullet with the desired color. 
D)  Click the Theme Effects button and select the desired option.

Question 11

To position text midway between the top,bottom,left,and right of a table cell,select the cell and click Align Top Left.

Accepted Answer

A) True 
 B)False

Question 12

Jada needs the text in a cell to be rotated 90 degrees to the right.She should do which of the following?

Accepted Answer

A)  Click the Align Center Right button. 
B)  Click the Text Direction button. 
C)  Click the Sort button. 
D)  Click the Insert Right button. 
A)  Click the Align Center Right button. 
B)  Click the Text Direction button. 
C)  Click the Sort button. 
D)  Click the Insert Right button.

Question 13

To remove a line or cells going from right to left in a table,which of the following should be done?

Accepted Answer

A)  Delete a table row. 
B)  Delete a table column. 
C)  Delete a table cell. 
A)  Delete a table row. 
B)  Delete a table column. 
C)  Delete a table cell.

Question 14

To create a numbered list that uses Roman numerals,change the list numbering style.

Accepted Answer

A) True 
 B)False

Question 15

Nevaeh is working on a document that has text appearing at the top of every page.To delete this text,he should remove the document header.

Accepted Answer

A) True 
 B)False

Question 16

To create columns and rows in a table using the cursor,first which of the following should be done?

Accepted Answer

A)  Click Split Cells. 
B)  Click Split Table. 
C)  Click Merge Cells. 
D)  Click Draw Table. 
A)  Click Split Cells. 
B)  Click Split Table. 
C)  Click Merge Cells. 
D)  Click Draw Table.

Question 17

To automatically resize the columns in a table to fit the contents of cells,which of the following should be done?

Accepted Answer

A)  Click Distribute Columns. 
B)  Click Distribute Rows. 
C)  Click AutoFit Contents. 
D)  Click Align,then Distribute Horizontally. 
A)  Click Distribute Columns. 
B)  Click Distribute Rows. 
C)  Click AutoFit Contents. 
D)  Click Align,then Distribute Horizontally.

Question 18

To join two cells into a single cell,which of the following should be done?

Accepted Answer

A)  Click the Merge Cells button. 
B)  Click the Distribute Rows button. 
C)  Click the Split Cells button. 
D)  Click the Split Table button. 
A)  Click the Merge Cells button. 
B)  Click the Distribute Rows button. 
C)  Click the Split Cells button. 
D)  Click the Split Table button.

Question 19

Tyler created a table that spans across multiple pages.To have the header row appear at the top of each page,he should do which of the following?

Accepted Answer

A)  Select the header row and then click Repeat Header Rows. 
B)  Copy the header row and paste it in the top row of every page. 
C)  Select the header row and click Distribute Rows. 
D)  Select the header and click Insert Below. 
A)  Select the header row and then click Repeat Header Rows. 
B)  Copy the header row and paste it in the top row of every page. 
C)  Select the header row and click Distribute Rows. 
D)  Select the header and click Insert Below.

Question 20

To change the color of a cell in a table,which of the following should be done?

Accepted Answer

A)  Modify the font color of text in the cell. 
B)  Modify the cell border style. 
C)  Apply shading to the cell. 
A)  Modify the font color of text in the cell. 
B)  Modify the cell border style. 
C)  Apply shading to the cell.

To specify the right edge of a paragraph,which of the following should be done?

Jasmine needs to modify the right boundary of a paragraph.She should do which of the following?

Joan needs to calculate the average of a column of cells in a table.She should do which of the following?

To join two cells into a single cell,click Merge Cells.

Nevaeh needs bullets in a list to appear like her company's logo.She should change the bullets to a picture.

Brandon needs the outside border of a table to be red.He should do which of the following?

Kiara needs each column in a table to be 0.5 inches in width.She should do which of the following?

To position text midway between the top,bottom,left,and right of a table cell,which of the following should be done?

Xavier is experimenting with different layouts for a table.To try out different heights for a row,he should do which of the following?

To change the color of a bullet in a list,which of the following should be done?

To position text midway between the top,bottom,left,and right of a table cell,select the cell and click Align Top Left.

Jada needs the text in a cell to be rotated 90 degrees to the right.She should do which of the following?

To remove a line or cells going from right to left in a table,which of the following should be done?

To create a numbered list that uses Roman numerals,change the list numbering style.

Nevaeh is working on a document that has text appearing at the top of every page.To delete this text,he should remove the document header.

To create columns and rows in a table using the cursor,first which of the following should be done?

To automatically resize the columns in a table to fit the contents of cells,which of the following should be done?

To join two cells into a single cell,which of the following should be done?

Tyler created a table that spans across multiple pages.To have the header row appear at the top of each page,he should do which of the following?

To change the color of a cell in a table,which of the following should be done?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

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 4: Financial Functions, Data Tables, and Amortization Schedules

To specify the right edge of a paragraph,which of the following should be done?

Jasmine needs to modify the right boundary of a paragraph.She should do which of the following?

Joan needs to calculate the average of a column of cells in a table.She should do which of the following?

To join two cells into a single cell,click Merge Cells.

Nevaeh needs bullets in a list to appear like her company's logo.She should change the bullets to a picture.

Brandon needs the outside border of a table to be red.He should do which of the following?

Kiara needs each column in a table to be 0.5 inches in width.She should do which of the following?

To position text midway between the top,bottom,left,and right of a table cell,which of the following should be done?

Xavier is experimenting with different layouts for a table.To try out different heights for a row,he should do which of the following?

To change the color of a bullet in a list,which of the following should be done?

To position text midway between the top,bottom,left,and right of a table cell,select the cell and click Align Top Left.

Jada needs the text in a cell to be rotated 90 degrees to the right.She should do which of the following?

To remove a line or cells going from right to left in a table,which of the following should be done?

To create a numbered list that uses Roman numerals,change the list numbering style.

Nevaeh is working on a document that has text appearing at the top of every page.To delete this text,he should remove the document header.

To create columns and rows in a table using the cursor,first which of the following should be done?

To automatically resize the columns in a table to fit the contents of cells,which of the following should be done?

To join two cells into a single cell,which of the following should be done?

Tyler created a table that spans across multiple pages.To have the header row appear at the top of each page,he should do which of the following?

To change the color of a cell in a table,which of the following should be done?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

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