Question 1

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.

Accepted Answer

A)  Organize 
B)  Format Table 
C)  Table Properties 
D)  Sort

Question 2

The lines that divide columns and rows in a table are called borders .

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)  combine 
B)  merge 
C)  split 
D)  join

Question 4

The Cell Margins button appears in the ____ group on the Table Tools Layout tab.

Accepted Answer

A)  Layout 
B)  Cell Size 
C)  Alignment 
D)  Print Preview

Question 5

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

Accepted Answer

A)  Insert Control 
B)  New Row icon 
C)  Mini toolbar 
D)  Table Selector

Question 6

It is often easier to add and delete columns and rows using the mouse.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  Rows & Columns 
B)  Cell Size 
C)  Merge 
D)  Split

Question 8

The cell in the fifth row of the third column is cell ____.

Accepted Answer

A)  5C 
B)  3E 
C)  E3 
D)  C5

Question 9

The text following an equal sign (=) is a(n) ____.

Accepted Answer

A)  formula 
B)  cell reference 
C)  function 
D)  argument

Question 10

Use the ____ Table menu command to create a table with any number of columns and rows and then select an AutoFit behavior.

Accepted Answer

A)  Quick Tables 
B)  Draw Table 
C)  Insert Table 
D)  New Table

Exam 6: Creating and Formatting Tables

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.