Question 1

How do you insert multiple rows at the same time?
A) Click Insert Multiple Rows in the Rows & Columns group.
B) Select the number of rows you want to insert, then click an Insert Control.
C) Select one row and click the Insert Above or Insert Below button. You will be prompted to choose how many rows to insert.
D) You cannot insert multiple rows at the same time.

Accepted Answer

To insert multiple rows at the same time, select the number of rows you want to insert, then click an Insert Control. This will insert the desired number of rows at once. Option A is not a valid option, and option C would still require selecting and inserting rows one at a time. Option D is incorrect as well, as multiple rows can be inserted at once using the correct method.

Question 2

Which command would you use to make the width of all selected columns fit the text?
A) Distribute Columns
B) AutoFit
C) No Spacing
D) Alignment

Accepted Answer

The AutoFit command adjusts the width of the selected columns to fit the text within them.

Question 3

Use the ____ dialog box to organize the rows of a table in alphabetical or sequential order based on the data in one or more columns.
A) Organize
B) Format Table
C) Table Properties
D) Sort

Accepted Answer

The correct option is to use the "Sort" dialog box to easily organize the rows of a table in alphabetical or sequential order based on the data in one or more columns. This option allows you to choose the column(s) to sort by and whether to sort in ascending or descending order.

Question 4

Item ____, shown in the accompanying figure, is an end of cell mark.
A) 1
B) 2
C) 3
D) 4

Accepted Answer

The answer of  Item ____, shown in the accompanying...

Question 5

Use the ____ dialog box to sort data that is not formatted as a table, such as lists or paragraphs.
A) Sort Text
B) Sort
C) Paragraph
D) Organize

Accepted Answer

The Sort Text command can be used to sort data that is not formatted as a table, such as lists or paragraphs. It allows the user to choose which character to use as the delimiter and in which direction to sort the data (ascending or descending). The Sort command is typically used to sort data within a table, not for unformatted text. The Paragraph and Organize options are not applicable for sorting data.

Question 6

How do you delete a row?
A) Select the row and press [Delete].
B) Select the row and press [Ctrl][Delete].
C) Select the row, click the Delete button on the Mini toolbar, then click Delete Rows.
D) Select the row and press [Ctrl][D].

Accepted Answer

This option provides a more specific and guided way to delete the row by using the Delete button on the Mini toolbar and selecting Delete Rows. This ensures that only the desired row is deleted and reduces the risk of accidentally deleting other rows or data.

Question 7

Which dialog box is used to set an exact width for the table?
A) Table Properties
B) Page Setup
C) Table Setup
D) Table Options

Accepted Answer

The Table Properties dialog box allows users to set an exact width for the table. It also offers other settings such as border and cell padding options. The other choices are irrelevant to setting the width of the table.

Question 8

Press ____ as you drag a border to display the column width or row height measurements on the ruler.
A) [Alt]
B) [Ctrl]
C) [Shift]
D) [Ctrl][Alt]

Accepted Answer

Pressing [Alt] as you drag a border allows you to see the column width or row height measurements on the ruler in many spreadsheet programs like Microsoft Excel.

Question 9

Which tab in the Table Properties dialog box allows you set text wrapping options for the table?
A) Column
B) Row
C) Table
D) Cell

Accepted Answer

The answer of Which tab in the Table Properties dialog...

Question 10

What happens when you click the table move handle?
A) The table moves.
B) All the rows and columns are automatically resized.
C) The entire table is selected.
D) The pointer changes to the Move pointer.

Accepted Answer

Clicking the table move handle selects the entire table, allowing you to move or format it as a whole.

Question 11

When you ____ a cell, you combine adjacent cells into a single larger cell.
A) combine
B) merge
C) split
D) join

Accepted Answer

When you merge a cell, you combine adjacent cells into a single larger cell.

Question 12

If you want to quickly make all the columns in a table the same width, which command do you use?
A) AutoFit Contents
B) AutoFit Window
C) Distribute Rows
D) Distribute Columns

Accepted Answer

"Distribute Columns" is the correct command for making all columns in a table the same width. This evenly distributes the width of all columns across the table.

Question 13

Item ____, shown in the accompanying figure, is a column.
A) 1
B) 2
C) 3
D) 4

Accepted Answer

The answer of  Item ____, shown in the accompanying...

Question 14

Item ____, shown in the accompanying figure, is used to move the table.
A) 1
B) 2
C) 3
D) 4

Accepted Answer

The answer of  Item ____, shown in the accompanying...

Question 15

The Split Cells command appears in the ____ group on the Table Tools Layout tab.
A) Rows & Columns
B) Cell Size
C) Merge
D) Split

Accepted Answer

The answer of The Split Cells command appears in the...

Question 16

By default, table cells have ____ left and right cell margins with no spacing between the cells.
A) .08"
B) .03"
C) .05"
D) .10"

Accepted Answer

The answer of By default, table cells have ____ left...

Question 17

What happens when you use the Copy or Cut and Paste commands to move a row in a table?
A) The row is inserted above the row containing the insertion point.
B) The row is inserted below the row containing the insertion point.
C) You are prompted to choose where to insert the row.
D) You cannot use the Copy or Cut and Paste commands to move rows in a table.

Accepted Answer

When you use the Copy or Cut and Paste commands to move a row in a table, the row is inserted above the row containing the insertion point.

Question 18

How do you center the text vertically in each table cell?
A) Select the table and click the Center button in the Paragraph group on the Home tab.
B) Select the table and click the Align Center Left button in the Alignment group on the Table Tools Layout tab.
C) Select the table and click the Distribute Columns button.
D) Select the table and click the AutoFit button.

Accepted Answer

The answer of How do you center the text vertically...

Question 19

Which sort order lists data alphabetically from A to Z?
A) Alphabetical
B) Descending
C) Sequential
D) Ascending

Accepted Answer

Ascending sort order lists data alphabetically from A to Z.

Question 20

A ____ row is the first row of a table that contains the column headings.
A) header
B) title
C) primary
D) heading

Accepted Answer

The first row of a table that contains the column headings is commonly referred to as the header row. This row helps to identify the contents of each column in the table, making it easier for the reader to understand the information presented.

Quiz 4: Creating and Formatting Tables

How do you insert multiple rows at the same time?

Which command would you use to make the width of all selected columns fit the text?

Use the ____ dialog box to organize the rows of a table in alphabetical or sequential order based on the data in one or more columns.

Item ____, shown in the accompanying figure, is an end of cell mark.

Use the ____ dialog box to sort data that is not formatted as a table, such as lists or paragraphs.

How do you delete a row?

Which dialog box is used to set an exact width for the table?

Press ____ as you drag a border to display the column width or row height measurements on the ruler.

Which tab in the Table Properties dialog box allows you set text wrapping options for the table?

What happens when you click the table move handle?

When you ____ a cell, you combine adjacent cells into a single larger cell.

If you want to quickly make all the columns in a table the same width, which command do you use?

Item ____, shown in the accompanying figure, is a column.

Item ____, shown in the accompanying figure, is used to move the table.

The Split Cells command appears in the ____ group on the Table Tools Layout tab.

By default, table cells have ____ left and right cell margins with no spacing between the cells.

What happens when you use the Copy or Cut and Paste commands to move a row in a table?

How do you center the text vertically in each table cell?

Which sort order lists data alphabetically from A to Z?

A ____ row is the first row of a table that contains the column headings.