Question 1

You can convert text that is separated by commas into a table.

Accepted Answer

A) True 
 B)False

Question 2

How do you insert multiple rows at the same time?

Accepted Answer

A)  Click Insert Multiple Rows in the Rows & Columns group. 
B)  Select the number of rows you want to insert, then use the buttons in the Rows & Columns group to insert the new rows. 
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.

Question 3

Match between columns
                        Premises: Show/Hide button
End of cell or table mark
Table move handle
Distribute Rows button
Resizes a column to fit the text

Accepted Answer

The Answer of <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9111/11ebd73d_4593_4c5f_9603_ed6113fd678e_TBX9111_11.jpg" alt=" " class="answers-bank-image d-inline" rel="preload" is...

Question 4

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

Accepted Answer

The answer of A(n) ____________________ is the box formed by...

Question 5

You manage the Sales department of a company that has four salespeople. You are creating a table that summarizes the company's sales to send to your manager. Below is the table that you have created thus far.  
 How can you use the SUM function to calculate the total sales for P. Burke? ( Hint : Write the formula.)

Accepted Answer

The answer of You manage the Sales department of a...

Question 6

Which key is used to update a calculation?

Accepted Answer

A)  [F6] 
B)  [F9] 
C)  [F4] 
D)  [F3]

Question 7

Click the Formula button in the ____ group on the Table Tools Layout tab to open the Formula dialog box.

Accepted Answer

A)  Table 
B)  Rows & Columns 
C)  Formulas 
D)  Data

Question 8

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

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4

Question 9

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

Accepted Answer

A)  [Alt] 
B)  [Ctrl] 
C)  [Shift] 
D)  [Ctrl][Alt]

Question 10

Use the ____________________ Table menu command to insert a blank Excel worksheet into a document as an embedded object.

Accepted Answer

The answer of Use the ____________________ Table menu command to...

Question 11

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

Accepted Answer

A)  Distribute Columns 
B)  AutoFit 
C)  No Spacing 
D)  Alignment

Question 12

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 13

____________________ sort order lists data from Z to A, 9 to 0, or latest to earliest.

Accepted Answer

The answer of ____________________ sort order lists data from Z...

Question 14

Describe the different ways you could sort data in a table and how you would do so.

Accepted Answer

The answer of Describe the different ways you could sort...

Question 15

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

Question 16

Use the Word Draw Table feature to draw table cells exactly where you want them.

Accepted Answer

A) True 
 B)False

Question 17

You manage the Sales department of a company that has four salespeople. You are creating a table that summarizes the company's sales to send to your manager. Below is the table that you have created thus far.  
 Once all the sales per person totals have been calculated, how would you use the SUM function to calculate the grand total of all the sales?

Accepted Answer

The answer of You manage the Sales department of a...

Question 18

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 19

Pressing [Enter] at the end of the last cell of a table creates a new row at the bottom of the table.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____________________ is a table that is inserted into the cell of another table.

Accepted Answer

The answer of A(n) ____________________ is a table that is...

Exam 4: Creating and Formatting Tables

You can convert text that is separated by commas into a table.

How do you insert multiple rows at the same time?

Match each item with a statement below.

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

Which key is used to update a calculation?

Click the Formula button in the ____ group on the Table Tools Layout tab to open the Formula dialog box.

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

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

Use the ____________________ Table menu command to insert a blank Excel worksheet into a document as an embedded object.

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.

____________________ sort order lists data from Z to A, 9 to 0, or latest to earliest.

Describe the different ways you could sort data in a table and how you would do so.

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

Use the Word Draw Table feature to draw table cells exactly where you want them.

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

Pressing [Enter] at the end of the last cell of a table creates a new row at the bottom of the table.

A(n) ____________________ is a table that is inserted into the cell of another table.