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 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.  
​ The total sales for Quarter 1 and Quarter 2 for each of the four salespeople are in cells D3 through D6. How would you use the SUM function to calculate the grand total of all the sales?

Accepted Answer

=SUM(ABOVE

Question 3

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.  
There are four salespeople in the table. How would you sort the table by the names of the salespeople in alphabetical order?

Accepted Answer

Select the four rows that contain the na

Question 4

The Colors list arrow is on the ____ tab.

Accepted Answer

A)  Home 
B)  Style 
C)  Swatches 
D)  Design 
A)  Home 
B)  Style 
C)  Swatches 
D)  Design

Question 5

The Table button is on the Insert tab.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  AutoFit Contents 
B)  AutoFit Window 
C)  Distribute Rows 
D)  Distribute Columns 
A)  AutoFit Contents 
B)  AutoFit Window 
C)  Distribute Rows 
D)  Distribute Columns

Question 7

Use the AutoFit command to change the height of rows or the width of columns.

Accepted Answer

A) True 
 B)False

Question 8

Ascending order lists data alphabetically from A-Z or sequentially from 0-9.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  gridlines 
B)  guidelines 
C)  borders 
D)  dividers 
A)  gridlines 
B)  guidelines 
C)  borders 
D)  dividers

Question 10

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: 
   
What could you do to quickly make the table more attractive and easy to read?

Accepted Answer

You could apply a table style to the tab

Question 11

The Table Tools Layout tab includes buttons for applying table styles and for adding, removing, and customizing borders and shading.​

Accepted Answer

A) True 
 B)False

Question 12

____________________ sort order lists data alphabetically or sequentially.

Accepted Answer

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

Question 13

When you copy and paste a row within a table, the row is inserted belo w the row containing the insertion point.​

Accepted Answer

A) True 
 B)False

Question 14

You can convert text that is sep arated by a comma into a table.​

Accepted Answer

A) True 
 B)False

Question 15

You can convert text that is separated by a tab, a(n) ____________________, or another separator character into a table.​

Accepted Answer

The answer of You can convert text that is separated...

Question 16

The Shading list arrow is in the ____ group.

Accepted Answer

A)  Table Styles 
B)  Borders & Shading 
C)  Format 
D)  Design 
A)  Table Styles 
B)  Borders & Shading 
C)  Format 
D)  Design

Question 17

Pressing ____ at the end of a row moves the insertion point to the first cell in the next row.

Accepted Answer

A)  [Spacebar] 
B)  [Tab] 
C)  [Enter] 
D)  [Ctrl] 
A)  [Spacebar] 
B)  [Tab] 
C)  [Enter] 
D)  [Ctrl]

Question 18

You copy and move rows and columns differently than you copy and move text.​

Accepted Answer

A) True 
 B)False

Question 19

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

Question 20

To open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.​

Accepted Answer

The answer of To open the Formula dialog box, click...

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

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. There are four salespeople in the table. How would you sort the table by the names of the salespeople in alphabetical order?

The Colors list arrow is on the ____ tab.

The Table button is on the Insert tab.

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

Use the AutoFit command to change the height of rows or the width of columns.

Ascending order lists data alphabetically from A-Z or sequentially from 0-9.

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

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: What could you do to quickly make the table more attractive and easy to read?

The Table Tools Layout tab includes buttons for applying table styles and for adding, removing, and customizing borders and shading.

____________________ sort order lists data alphabetically or sequentially.

When you copy and paste a row within a table, the row is inserted belo w the row containing the insertion point.

You can convert text that is sep arated by a comma into a table.

You can convert text that is separated by a tab, a(n) ____________________, or another separator character into a table.

The Shading list arrow is in the ____ group.

Pressing ____ at the end of a row moves the insertion point to the first cell in the next row.

You copy and move rows and columns differently than you copy and move text.

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

To open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.

Getting Started With Microsoft Office 2016

Creating Documents With Word 2016

Editing Documents

Formatting Text and Paragraphs

Formatting Documents

Illustrating Documents With Graphics

Working With Themes and Building Blocks

Merging Word Documents

Develop Multipage Documents

Working With Styles and Templates

Working With References

Integrating Word With Other Programs

Exploring Advanced Graphics

Building Forms

Collaborating With Coworkers

Customizing Word

Filters

Exam 6: Creating and Formatting Tables

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

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. There are four salespeople in the table. How would you sort the table by the names of the salespeople in alphabetical order?

The Colors list arrow is on the ____ tab.

The Table button is on the Insert tab.

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

Use the AutoFit command to change the height of rows or the width of columns.

Ascending order lists data alphabetically from A-Z or sequentially from 0-9.

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

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: What could you do to quickly make the table more attractive and easy to read?

The Table Tools Layout tab includes buttons for applying table styles and for adding, removing, and customizing borders and shading.​

____________________ sort order lists data alphabetically or sequentially.

When you copy and paste a row within a table, the row is inserted belo w the row containing the insertion point.​

You can convert text that is sep arated by a comma into a table.​

You can convert text that is separated by a tab, a(n) ____________________, or another separator character into a table.​

The Shading list arrow is in the ____ group.

Pressing ____ at the end of a row moves the insertion point to the first cell in the next row.

You copy and move rows and columns differently than you copy and move text.​

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

To open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.​

Getting Started With Microsoft Office 2016

Creating Documents With Word 2016

Editing Documents

Formatting Text and Paragraphs

Formatting Documents

Illustrating Documents With Graphics

Working With Themes and Building Blocks

Merging Word Documents

Develop Multipage Documents

Working With Styles and Templates

Working With References

Integrating Word With Other Programs

Exploring Advanced Graphics

Building Forms

Collaborating With Coworkers

Customizing Word

Filters

The Table Tools Layout tab includes buttons for applying table styles and for adding, removing, and customizing borders and shading.

When you copy and paste a row within a table, the row is inserted belo w the row containing the insertion point.

You can convert text that is sep arated by a comma into a table.

You can convert text that is separated by a tab, a(n) ____________________, or another separator character into a table.

You copy and move rows and columns differently than you copy and move text.

To open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.