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.
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).
Convert the Text to Table
On the Insert tab, select Tables and then click 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.
Click OK to set the text in the table.
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 Table Row Below
With your cursor in the top row click the 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.
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.
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.
Type Salary by Region.
Select the text Salary by Region then click the bold button on the home tab.
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 .You are going to replace the column data e-mail addresses with the salary of the employee.
Delete E-mail Data
Select all the e-mail data by dragging over it while holding down your left mouse button.
Press the delete button on the keyboard.
Type in Salary Data
Type in the data shown below in the Salary column.
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.
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
This opens the Formula dialog box. The sum above function should already appear by default. Select the $#,##0.00;($#,##0.00).
Your table should now look like this:
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:
Your top row in the table should now look like this:
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.
Your top row should now appear black as shown below:
Save and close your document.