Question 1

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 2

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 known as the header row.

Question 3

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 4

You can quickly center a table on a page by clicking the ____ button in the Paragraph group on the HOME tab.
A) Center
B) Align
C) Center Table
D) Line Up

Accepted Answer

The button to quickly center a table on a page is the "Center" button in the Paragraph group on the HOME tab.

Question 5

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 use an Insert Control or use the buttons on the Ribbon.
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, you need to select the number of rows you want to insert and then use an Insert Control or use the buttons on the Ribbon. Option A is not a valid option, there is no such command as "Insert Multiple Rows." Option C is an option, but it requires you to insert one row at a time and then specify how many rows you want to insert. Option D is incorrect because it is possible to insert multiple rows at the same time.

Question 6

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

Accepted Answer

Ascending order lists data from lowest to highest or from A to Z in alphabetical order.

Question 7

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 dialog box can be used to sort data that is not formatted as a table, such as lists or paragraphs. It allows the user to select the sorting criteria and choose whether to sort in ascending or descending order.

Question 8

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 9

When you move the pointer to the left of two existing rows, a(n) ____ appears outside the table.
A) Insert Control
B) New Row icon
C) Mini toolbar
D) Table Selector

Accepted Answer

When you move the pointer to the left of two existing rows, an Insert Control appears outside the table, which allows you to insert a new row above or below the existing rows. The other options listed are not relevant to this action.

Question 10

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

Accepted Answer

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

Question 11

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 12

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

Accepted Answer

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

Question 13

Item ____, shown in the accompanying figure, is an Insert Control.
A) 1
B) 2
C) 3
D) 4

Accepted Answer

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

Question 14

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) Click the Select button in the Table group, click Select Table, then click the Align Center Left button in the Alignment group.
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 15

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

Accepted Answer

The question states that Item ____ is a result of clicking item 1. The only item shown that is a result of clicking item 1 is item 2, therefore the answer is B.

Question 16

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

Accepted Answer

The term "merge" is commonly used in spreadsheet programs to refer to combining adjacent cells into a single larger cell. "Combine" and "join" could also be used, but "merge" is the most common and specific term. "Split" refers to dividing a cell or range of cells into smaller cells, which is the opposite action of merging.

Question 17

A(n) ____ is a box formed by the intersection of a column and a row.
A) divider
B) table
C) cell
D) border

Accepted Answer

A cell is the intersection of a column and a row in a table.

Question 18

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 19

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

Accepted Answer

Clicking the table move handle selects the entire table, allowing for further actions like moving or formatting the table as a whole.

Question 20

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 "Sort" dialog box is used specifically for organizing rows in alphabetical or sequential order based on data in one or more columns. The other options listed are not specifically designed for this task.

Quiz 6: Creating and Formatting Tables

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

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

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

You can quickly center a table on a page by clicking the ____ button in the Paragraph group on the HOME tab.

How do you insert multiple rows at the same time?

Which sort order lists data alphabetically from A to Z?

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

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

When you move the pointer to the left of two existing rows, a(n) ____ appears outside the table.

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

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

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

Item ____, shown in the accompanying figure, is an Insert Control.

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

Item ____, shown in the accompanying figure, is a result of clicking item 1.

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

A(n) ____ is a box formed by the intersection of a column and a row.

The Split Cells command appears in the ____ group on the TABLE TOOLS LAYOUT tab.

What happens when you click the table move handle?

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.