Employee Salary Table /Converting Text to Table
Employee Salary Table /Converting Text to Table Grading Rubric

When you insert separator characters — such as commas or tabs — in a word document you can divide text into columns. In this activity you will convert the text in the Sales by Region document to a table. You will also learn how to manipulate tables to present data in a logical manner.

Open the Sales by Region 2010 word document. When you created your recipient list it now associates the list with this document. You don't need a recipient list for this project, just the data enter. When you are prompted if you want to continue select No.

Prompt

Save the document again with the name Employee Salary Table.

Select the Data

While holding down your left mouse drag over all the text in the document (or while holding down the Ctrl + A keys).

Selected Text

Convert the Text to Table

On the Insert tab, select Tables and then click Convert Text to Table.

Convert Text to Table

This opens the Convert Text to Table dialog box. Make sure the default settings are correct. Number of columns set to 4, fixed column width is selected under the AutoFit behavior, and Commas is selected under Separate text at.

Convert Text to Table

Click OK to set the text in the table.

Text Converted to Tables

Insert Table Row Above

Place your cursor in the top row that contains the employee Coco Crisp's data.

With the Table Tools Layout tab select Inset Above in the Rows and Columns section of the ribbon.

Insert Row Above

Insert Table Row Below

With your cursor in the top row click the Insert Below Insert Below button on the Rows and Columns section on the Table Tools Layout tab. You should now have two table rows added to the table.

Two Rows Inserted

Merge Top Row Cells

With the top row selected, with the Table Tools Layout tabs selected click the Merge Cells button in the Merge sections of the ribbon.

Merge Cells

Center Text Vertically and Horizontally in Row

With your cursor in the top row click the center vertically and horizontally button in the Alignment section of the Table Tools Layout tab.

Center Row

Type Salary by Region.

Table Text

Bold Text

Select the text Salary by Region then click the bold button on the home tab.

Bold Text

Enter Header Text and Center Top Center

You will now enter table column header text in the second row. For the first column type Employee Name, second column Region, third column Job Title, and the last column type Salary. This time align the text top center Align Top Center.You are going to replace the column data e-mail addresses with the salary of the employee.

Header Text

Delete E-mail Data

Select all the e-mail data by dragging over it while holding down your left mouse button.

Select Data

Press the delete button on the keyboard.

Data Deleted

Type in Salary Data

Type in the data shown below in the Salary column.

Salary Data

Insert Total Row Below

With your cursor in the last row of the cell insert a row below. Merge the first three cells and right center align the text and type total formatted bold.

Total

Insert Sum Function

Place your cursor in the last row and last column of the table. With the Table Tools Layout tab selected click the Formula button

Insert Function

This opens the Formula dialog box. The sum above function should already appear by default. Select the $#,##0.00;($#,##0.00).

Sum Above

Your table should now look like this:

Salary Table

The last task is to apply a Gradient fill Blue, Accent 1, Outline, White, Glow, Accent 2 to the title of the table Salary by Region. First select the text in the top row by dragging over it with your mouse. With the Home tab selected click the text effects button and choose the Gradient fill Blue, Accent 1, Outline, White, Glow, Accent 2 style as shown below:

Gradient Fill

Your top row in the table should now look like this:

Gradient Applied to Text

Notice how washed out it appears. No problem! You will add shading to only the top row of your table. With your cursor in the top row with the Table Tools Design tab selected click the shading button and choose black from the color options.

Shading

Your top row should now appear black as shown below:

Top Row Shaded

Save and close your document.

Creating Business Documents in Microsoft 2010