As coach of a soccer team, you need to distribute a roster to all your players with contact information, uniform numbers, and assigned snack responsibilities. You received a rough list from the league, and you would like to convert it to table form.

 Begin on a blank page below.

 

1. Begin your table at 2 to 2.5" from the top of the page, and insert text from the following:

Annette Hill, #4, 806-555-0110, 09/09

Brian Groth, #3, 806-555-0134, 09/16

Chris Preston, #6, 806-555-0182, 10/14

Dylan Miller, #1, 806-555-0149, 11/04

Eric Parkinson, #5, 806-555-0170, 11/11

Garrett Young, #9, 806-555-0192, 10/28

Lee Oliver, #8, 806-555-0154, 10/07

Maria Hammond, #2, 806-555-0175, 09/23

Russell King, #7, 806-555-0161, 09/30

 

1. Convert Text to Table using 4 as the number of columns and separate text by commas. Select your table and apply the proper font style (as per assignment instructions). Use 11 pt. font for this table.
2. Insert a secondary header row with the following headings for each column and ensure this secondary header applies proper class formatting. Make this row 0.5" high.

           Name        Uniform Number        Phone Numbers        Snack Responsibility

 

1. Insert a row above for the secondary heading for a table title. Soccer Team Roster. Press a hard enter, then type a sub-heading Snack Schedule into the same row. Increase that row height to 0.8", ensure it is formatted as a primary header following class instructions.
2. Sort the table by name in ascending order.
3. Apply any list-style design to the table. Remove the formatting for the first column.
4. Make sure your table is horizontally centre aligned on the page. Make sure all columns have at least 0.5" between them.

INSTRUCTIONS:

Your company has just received all of its sales volumes for 2019 and 2020. Using the table below, calculate all the sums and stylize the table so that it's completed professionally.

That means you need to space all columns properly so they do not look crowded. Ensure your heading row is bolded, upper/lower and centre aligned in the cell. 

Using the table below, insert a column after the month of December, the title of this new column should be Total. 

Using table formulas, under the Totals column, add up the sums in row 2 and 3. Make sure these sums are in the newly created column and you have applied the $ number format to them.

Now create a formula to add up columns B through to Column N in row 4, apply 0 as the number format.

Make row 1 = 0.5" in height, make rows 2 through 4 = 0.4" in height.

Apply any Grid Style Table and deactivate banded rows and columns, activate first column.

Centre the table horizontally and vertically on the page.

 

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2019	29	42	19	28	17	38	29	20	0	19	26	0
2020	16	31	28	47	0	28	16	30	20	10	0	23
Totals

INSTRUCTIONS:

Using the table below, you are going to begin working on this multipage table. Make sure it MUST begin on a page of its own, not on the same page as these instructions and minimum page count is 2 pages. Include the appropriate page break to begin.

Start with adding a row at the top of the table and apply a header row.

Column A Heading: Company Name

Column B Heading: Hiring Authority

Column D Heading: Phone Number

Column E Heading: Representative Position

 

Merge row 1 columns B and C so that the Hiring Authority heading appears over both columns.

Make all rows 0.5" high except the header row, this must be 0.8". Ensure your header row is capitalized, bolded, centred align per cell.

Make the table font style Arial but use 11-pt. size in the body of the table.

Apply any grid-style table design you want. Make sure your Header Row, First Column and Banded Rows are activated in table style options.

Sort the table by Company Name in ascending order.

Make sure the header is appearing on both pages of the table. Centre align the table horizontally. 

 

Contoso Pharmaceuticals	Rob	Karon	469-555-0109
Litware, Inc.	Julie	Bankert	469-555-0167
Adventure Works	Mark	Harrington	972-555-0145
Proseware, Inc.	Robert	Zaretty	972-555-0139	VP Marketing & Communications
Trey Research	Mike	Tiano	469-555-0182
A. Datum Corporation	Arlene	Huff	469-555-0173	VP Marketing
City Power & Light Corporation	Pat	Coleman	972-555-0191
Lucerne Publishing	Brian	Clark	469-555-0178	Director Marketing VP Public Relations
Wingtip Toys	Mary	Baker	972-555-0167	VP Direct Marketing
Fabrikam, Inc.	John	Frum	972-555-0154
Baldwin Museum of Science	Stefan	Delmarco	972-555-0189
Consolidated Messenger	Holly	Dickson	469-555-0123	Dir Corp Communications
Humongous Insurance	Mindy	Martin	469-555-0145	Dir External Communications
Woodgrove Bank	Mike	Nash	972-555-0189
Fourth Coffee	Joe	Young	972-555-0177	VP Marketing and Public Relations
Southridge Video	Tony	Wang	469-555-0199
Tailspin Toys	Olinda	Turner	469-555-0183
The Phone Company	Frank	Lee	972-555-0166	Dir National Marketing
Wide World Importers	Scott	Culp	469-555-0141
Northwind Exchange	Annette	Hill	972-555-0129

 

Section 4: Re-creation Merge/Split                                                        /10 marks

INSTRUCTIONS:

Using the table shown on the page below, re-create this table using the split table functionality. 

Make table in 2 FORMATS: 1 FORMAT AS A FULL TABLE (NO PARAGRAPH TEXT INSERTED); THE SECOND FORMAT USING THE SPLIT TABLE FUNCTIONALITY WITH PROVIDED PARAGRAPH TEXT IN BETWEEN EACH SPLIT IN THE TABLE.

Recreate the table below using Arial font and 11-point size in the body. 

Treat primary and secondary headers as instructed in class, do not follow formatting below.

Make a border around the full table using ½ point line and applying all borders.

Make the table horizontally on the page.  

Do spacing between all cells equal to 0.02". 

Ensure equal spacing between split cells and paragraph text.  

 

 

 

EMPLOYEES EMPLOYEE DEPARTMENT YEARS OF SERVICE SUPERVISOR Bill Summers Finance 15 years Judith Meyers Jane Matthews Mary Northup Marketing 13 years Phillip Miller John Smith Based on company policy, the above-mentioned employees have been with our company for 10+ years. Susan Smith Finance 9 years Judith Meyers Bruce Abbott Human Resources 5 years Bob Allan Suzanna Bryant The above-mentioned employees fall into the 5-10-year range of employment. Cathy Taylor Marketing 2 years Phillip Miller Peter Dunn Finance 6 months Judith Meyers These employees are under 5 years of employment.