Question 1

Laila needs to divide a cell into two cells.She should do which of the following?

Accepted Answer

A)  Split the cell. 
B)  Merge the cell. 
C)  Split the table. 
A)  Split the cell. 
B)  Merge the cell. 
C)  Split the table. A

Question 2

To center a table on the page,change the alignment of the table.

Accepted Answer

A) True 
 B)False  True

Question 3

Josiah needs a row to be exactly 0.5 inches tall.He should do which of the following?

Accepted Answer

A)  Select the row,then enter the desired width in the Width text box. 
B)  Select the row,then enter the desired height in the Height text box. 
C)  Drag the row border to adjust the width. 
D)  Drag the row border to adjust the height. 
A)  Select the row,then enter the desired width in the Width text box. 
B)  Select the row,then enter the desired height in the Height text box. 
C)  Drag the row border to adjust the width. 
D)  Drag the row border to adjust the height. B

Question 4

To specify the distance of a paragraph from the left margin,adjust the left indent marker.

Accepted Answer

A) True 
 B)False

Question 5

To increase the distance between cells in a table,which of the following should be done?

Accepted Answer

A)  Increase the spacing between cells. 
B)  Increase the border weight. 
C)  Increase the cell margin. 
D)  Increase the width of cells. 
A)  Increase the spacing between cells. 
B)  Increase the border weight. 
C)  Increase the cell margin. 
D)  Increase the width of cells.

Question 6

Chloe is experimenting with different layouts for a table.To try out different widths for a column,she should do which of the following?

Accepted Answer

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

Question 7

To add a border to a table,modify the table shading.

Accepted Answer

A) True 
 B)False

Question 8

To remove a line of cells going from the top of a table to the bottom of the table,which of the following should be done?

Accepted Answer

A)  Distribute the table's rows. 
B)  Distribute the table's columns. 
C)  Delete a table row. 
D)  Delete a table column. 
A)  Distribute the table's rows. 
B)  Distribute the table's columns. 
C)  Delete a table row. 
D)  Delete a table column.

Question 9

To evenly space the columns in a table,click Distribute Columns.

Accepted Answer

A) True 
 B)False

Question 10

To duplicate the contents of a line of cells going from the top of a table to the bottom of the table,which of the following should be done?

Accepted Answer

A)  Copy and paste the desired table column. 
B)  Cut and paste the desired table column. 
C)  Copy and paste the desired table row. 
D)  Cut and paste the desired table row. 
A)  Copy and paste the desired table column. 
B)  Cut and paste the desired table column. 
C)  Copy and paste the desired table row. 
D)  Cut and paste the desired table row.

Question 11

To change lowercase letters to uppercase letters in a smaller font size,which of the following should be done?

Accepted Answer

A)  Format the text in Small caps. 
B)  Manually replace the lowercase letters with uppercase letters. 
C)  Format the text in All caps. 
A)  Format the text in Small caps. 
B)  Manually replace the lowercase letters with uppercase letters. 
C)  Format the text in All caps.

Question 12

To move a list item to a higher level,which of the following should be done?

Accepted Answer

A)  Promote the item. 
B)  Demote the item. 
C)  Insert a right tab stop. 
D)  Insert a left tab stop. 
A)  Promote the item. 
B)  Demote the item. 
C)  Insert a right tab stop. 
D)  Insert a left tab stop.

Question 13

To automatically resize the columns in a table to fit the contents of cells,click Distribute Columns.

Accepted Answer

A) True 
 B)False

Question 14

To add a line around the outside of a table,modify the table shading.

Accepted Answer

A) True 
 B)False

Question 15

To view the edges of cells in a table,click View Gridlines

Accepted Answer

A) True 
 B)False

Question 16

To remove a cover page,use the Remove Current Cover Page function.

Accepted Answer

A) True 
 B)False

Question 17

To move a list item to a lower level,demote the list item.

Accepted Answer

A) True 
 B)False

Question 18

To evenly space the columns in a table,which of the following should be done?

Accepted Answer

A)  Click Distribute Rows. 
B)  Click Distribute Columns. 
C)  Click AutoFit Contents. 
D)  Click AutoFit Window. 
A)  Click Distribute Rows. 
B)  Click Distribute Columns. 
C)  Click AutoFit Contents. 
D)  Click AutoFit Window.

Question 19

Matthew needs to increase the space between the contents of a cell and the border of the cell.He should do which of the following?

Accepted Answer

A)  Increase the cell margins. 
B)  Decrease the cell margins. 
C)  Increase the cell width. 
D)  Decrease the cell width 
A)  Increase the cell margins. 
B)  Decrease the cell margins. 
C)  Increase the cell width. 
D)  Decrease the cell width

Question 20

To specify the distance of a paragraph from the left margin,which of the following should be done?

Accepted Answer

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

Laila needs to divide a cell into two cells.She should do which of the following?

To center a table on the page,change the alignment of the table.

Josiah needs a row to be exactly 0.5 inches tall.He should do which of the following?

To specify the distance of a paragraph from the left margin,adjust the left indent marker.

To increase the distance between cells in a table,which of the following should be done?

Chloe is experimenting with different layouts for a table.To try out different widths for a column,she should do which of the following?

To add a border to a table,modify the table shading.

To remove a line of cells going from the top of a table to the bottom of the table,which of the following should be done?

To evenly space the columns in a table,click Distribute Columns.

To duplicate the contents of a line of cells going from the top of a table to the bottom of the table,which of the following should be done?

To change lowercase letters to uppercase letters in a smaller font size,which of the following should be done?

To move a list item to a higher level,which of the following should be done?

To automatically resize the columns in a table to fit the contents of cells,click Distribute Columns.

To add a line around the outside of a table,modify the table shading.

To view the edges of cells in a table,click View Gridlines

To remove a cover page,use the Remove Current Cover Page function.

To move a list item to a lower level,demote the list item.

To evenly space the columns in a table,which of the following should be done?

Matthew needs to increase the space between the contents of a cell and the border of the cell.He should do which of the following?

To specify the distance of a paragraph from the left margin,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

Laila needs to divide a cell into two cells.She should do which of the following?

To center a table on the page,change the alignment of the table.

Josiah needs a row to be exactly 0.5 inches tall.He should do which of the following?

To specify the distance of a paragraph from the left margin,adjust the left indent marker.

To increase the distance between cells in a table,which of the following should be done?

Chloe is experimenting with different layouts for a table.To try out different widths for a column,she should do which of the following?

To add a border to a table,modify the table shading.

To remove a line of cells going from the top of a table to the bottom of the table,which of the following should be done?

To evenly space the columns in a table,click Distribute Columns.

To duplicate the contents of a line of cells going from the top of a table to the bottom of the table,which of the following should be done?

To change lowercase letters to uppercase letters in a smaller font size,which of the following should be done?

To move a list item to a higher level,which of the following should be done?

To automatically resize the columns in a table to fit the contents of cells,click Distribute Columns.

To add a line around the outside of a table,modify the table shading.

To view the edges of cells in a table,click View Gridlines

To remove a cover page,use the Remove Current Cover Page function.

To move a list item to a lower level,demote the list item.

To evenly space the columns in a table,which of the following should be done?

Matthew needs to increase the space between the contents of a cell and the border of the cell.He should do which of the following?

To specify the distance of a paragraph from the left margin,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