Question 1

What formula would you use to calculate the total of the values in cells A1 through A4?

Accepted Answer

A)  =SUM(A1:A4) 
B)  =(A1-A4) 
C)  =SUM(A1-A4) 
D)  =(A1:A4) 
A)  =SUM(A1:A4) 
B)  =(A1-A4) 
C)  =SUM(A1-A4) 
D)  =(A1:A4)

Question 2

You can use the No Spacing button to remove the paragraph spacing below the text in each table cell.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

To turn gridlines off or on, you should click the View Gridlines button in the ____ group on the Table Tools Layout tab.

Accepted Answer

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

Question 5

You can click ____ in the gallery of table styles to remove all borders, shading, and other style elements from the selected table.

Accepted Answer

A)  Clear 
B)  Reset 
C)  Default 
D)  Remove 
A)  Clear 
B)  Reset 
C)  Default 
D)  Remove

Question 6

Use the Page Layout tab to insert a table.

Accepted Answer

A) True 
 B)False

Question 7

____________________ sort order lists data alphabetically or sequentially.

Accepted Answer

The answer of ____________________ sort order lists data alphabetically or...

Question 8

Quickly resize a table by dragging the table resize handle to a new location.

Accepted Answer

A) True 
 B)False

Question 9

In the table shown in the accompanying figure, what is the cell reference for the cell labeled "C"?

Accepted Answer

A)  A5 
B)  A9 
C)  E1 
D)  5A 
A)  A5 
B)  A9 
C)  E1 
D)  5A

Question 10

Use the ____________________ Table menu command to create a complex table by drawing the table columns and rows.

Accepted Answer

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

Question 11

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are:   
 You decide to move the three Print rows above the Web rows. How would you do this?

Accepted Answer

You would use the Cut and Paste function

Question 12

Use the AutoFit button to make all columns in a table the same width.

Accepted Answer

A) True 
 B)False

Question 13

If you want to sort an entire table, you must select the table.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)  Table Properties 
B)  Page Setup 
C)  Table Setup 
D)  Table Options 
A)  Table Properties 
B)  Page Setup 
C)  Table Setup 
D)  Table Options

Question 15

Use the ____________________ function to quickly total the numbers in a column or row.

Accepted Answer

The answer of Use the ____________________ function to quickly total...

Question 16

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

Accepted Answer

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

Question 17

The lines that divide the columns and rows in a table are called:

Accepted Answer

A)  Gridlines 
B)  Guidelines 
C)  Borders 
D)  Table lines 
A)  Gridlines 
B)  Guidelines 
C)  Borders 
D)  Table lines

Question 18

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

Accepted Answer

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

Question 19

Which sort order lists data alphabetically from A to Z?

Accepted Answer

A)  Alphabetical 
B)  Descending 
C)  Sequential 
D)  Ascending 
A)  Alphabetical 
B)  Descending 
C)  Sequential 
D)  Ascending

Question 20

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

Accepted Answer

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. 
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.

What formula would you use to calculate the total of the values in cells A1 through A4?

You can use the No Spacing button to remove the paragraph spacing below the text in each table cell.

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

To turn gridlines off or on, you should click the View Gridlines button in the ____ group on the Table Tools Layout tab.

You can click ____ in the gallery of table styles to remove all borders, shading, and other style elements from the selected table.

Use the Page Layout tab to insert a table.

____________________ sort order lists data alphabetically or sequentially.

Quickly resize a table by dragging the table resize handle to a new location.

In the table shown in the accompanying figure, what is the cell reference for the cell labeled "C"?

Use the ____________________ Table menu command to create a complex table by drawing the table columns and rows.

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: You decide to move the three Print rows above the Web rows. How would you do this?

Use the AutoFit button to make all columns in a table the same width.

If you want to sort an entire table, you must select the table.

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

Use the ____________________ function to quickly total the numbers in a column or row.

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

The lines that divide the columns and rows in a table are called:

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

Which sort order lists data alphabetically from A to Z?

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

Editing Documents

Formatting Text and Paragraphs

Formatting Documents

Illustrating Documents With Graphics

Working With Themes and Building Blocks

Merging Word Documents

Getting Started With Microsoft

Creating Documents With Word 2010

Working With Windows Live and Office Web Apps Question

Filters

Exam 4: Creating and Formatting Tables

What formula would you use to calculate the total of the values in cells A1 through A4?

You can use the No Spacing button to remove the paragraph spacing below the text in each table cell.

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

To turn gridlines off or on, you should click the View Gridlines button in the ____ group on the Table Tools Layout tab.

You can click ____ in the gallery of table styles to remove all borders, shading, and other style elements from the selected table.

Use the Page Layout tab to insert a table.

____________________ sort order lists data alphabetically or sequentially.

Quickly resize a table by dragging the table resize handle to a new location.

In the table shown in the accompanying figure, what is the cell reference for the cell labeled "C"?

Use the ____________________ Table menu command to create a complex table by drawing the table columns and rows.

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: You decide to move the three Print rows above the Web rows. How would you do this?

Use the AutoFit button to make all columns in a table the same width.

If you want to sort an entire table, you must select the table.

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

Use the ____________________ function to quickly total the numbers in a column or row.

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

The lines that divide the columns and rows in a table are called:

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

Which sort order lists data alphabetically from A to Z?

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

Editing Documents

Formatting Text and Paragraphs

Formatting Documents

Illustrating Documents With Graphics

Working With Themes and Building Blocks

Merging Word Documents

Getting Started With Microsoft

Creating Documents With Word 2010

Working With Windows Live and Office Web Apps Question

Filters