Assignments of Class 4
Tables and Table Formatting
Beginner Assignments
Assignment 1: Simple Table Creation
- Objective: Practice inserting and basic formatting of a table.
- Task:
- Open a new document and save it as Simple_Table_Exercise.docx.
- Insert a table with 3 columns and 4 rows.
- Label the columns as: Name, Role, Department.
- Enter sample data for each column (e.g., names of team members, their roles, and departments).
- Apply Table Style 1 from the Table Tools Design tab.
- Save and submit the document.
Assignment 2: Merging and Splitting Cells
- Objective: Practice merging and splitting cells in a table.
- Task:
- Open a new document and save it as Merge_Split_Exercise.docx.
- Create a table with 4 columns and 5 rows.
- Merge the first row across all columns and type "Department Overview".
- Split the cell in the second row, first column into two cells.
- Add sample data to the table (e.g., department names, key activities).
- Save and submit the document.
Intermediate Assignments
Assignment 3: Formatting a Report Table
- Objective: Format a table with borders, shading, and alignment.
- Task:
- Open a new document and save it as Formatted_Report_Table.docx.
- Insert a table with 5 columns and 6 rows.
- Label the columns as: Date, Task, Assigned To, Status, Completion Date.
- Enter sample data relevant to project management.
- Apply borders to all cells and shading to the header row.
- Adjust column widths and align text within cells.
- Save and submit the document.
Assignment 4: Creating a Business Data Table with Advanced Formatting
- Objective: Use advanced formatting options to enhance a table.
- Task:
- Open a new document and save it as Business_Data_Table.docx.
- Create a table with 6 columns and 7 rows.
- Label the columns as: Month, Revenue, Expenses, Profit, Growth (%), Comments.
- Enter sample data for each column.
- Apply custom borders, shading, and a table style from the Table Tools Design tab.
- Adjust cell sizes and align text appropriately.
- Save and submit the document.
Advanced Assignments
Assignment 5: Multi-Section Report Table
- Objective: Create and format a complex table for a detailed report.
- Task:
- Open a new document and save it as Multi_Section_Report_Table.docx.
- Create a table with 8 columns and 10 rows.
- Add sections with merged cells for titles (e.g., "Quarterly Sales Report").
- Insert sub-sections with detailed data, such as Region, Product, Sales Target, Actual Sales, Variance, Percentage Achieved.
- Format the table with different border styles, shading, and alignment options.
- Apply different Table Styles for various sections to enhance readability.
- Save and submit the document.
Assignment 6: Financial Data Table with Conditional Formatting
- Objective: Apply conditional formatting to highlight specific data in a table.
- Task:
- Open a new document and save it as Financial_Data_Table.docx.
- Create a table with 5 columns and 8 rows.
- Label the columns as: Quarter, Revenue, Expenses, Net Profit, Profit Margin.
- Enter sample financial data for each quarter.
- Apply conditional formatting to highlight cells where the Net Profit is below a certain threshold.
- Use shading and border styles to emphasize key figures.
- Save and submit the document.
SOLUTIONS
"Assignment 1: Simple Table Creation" in MS Word.
Steps
- Open
a New Document
- Open
Microsoft Word.
- Go
to File > New and select a blank document.
- Save
it immediately as Simple_Table_Exercise.docx.
- Go
to File > Save As, choose a location, name the file Simple_Table_Exercise.docx,
and click Save.
- Insert
a Table with 3 Columns and 4 Rows
- Go
to the Insert tab on the ribbon.
- Click
on Table and then select a 3x4 table by highlighting 3 columns and 4 rows
or using the Insert Table option.
- Label
the Columns
- In
the first row (header row) of the table, enter the column headers:
- Type
Name in the first cell.
- Type
Role in the second cell.
- Type
Department in the third cell.
- Enter
Sample Data
- In
the remaining rows, enter sample data for each column:
- Example:
- Row
2: John Doe | Manager | Sales
- Row
3: Jane Smith | Analyst | Marketing
- Row
4: David Lee | Developer | IT
- Apply
Table Style 1
- Click
anywhere inside the table to display the Table Tools tab.
- Select
the Design tab under Table Tools.
- Look
for the Table Styles group and click on Table Style 1. If not
immediately visible, click the drop-down arrow to view more styles.
- Save
the Document
- Go
to File > Save or press Ctrl + S to save all changes.
"Assignment 2: Merging and Splitting Cells" in MS
Word.
Steps:
- Open
a New Document
- Open
Microsoft Word.
- Go
to File > New and select a blank document.
- Save
it immediately as Merge_Split_Exercise.docx.
- Go
to File > Save As, choose a location, name the file Merge_Split_Exercise.docx,
and click Save.
- Create
a Table with 4 Columns and 5 Rows
- Go
to the Insert tab on the ribbon.
- Click
on Table and then select a 4x5 table by highlighting 4 columns and 5 rows
or using the Insert Table option.
- Merge
the First Row Across All Columns
- Click
and drag to select all four cells in the first row.
- Go
to the Layout tab under Table Tools.
- Click
on Merge Cells in the Merge group to combine the selected cells into one
large cell.
- Type
Department Overview into the merged cell.
- Split
the Cell in the Second Row, First Column
- Click
on the cell in the second row, first column (top-left cell of the second
row).
- Go
to the Layout tab under Table Tools.
- Click
on Split Cells.
- In
the dialog box, set Number of columns to 2 and Number of rows
to 1.
- Click
OK to split the cell into two smaller cells within the same row.
- Add
Sample Data
- Enter sample data for each column and row in the table.
- Example:
- Row
2: Sales | Promotions | Budgeting | Reporting
- Row
3: IT | Development | Maintenance | Security
- Row
4: HR | Recruitment | Training | Policy Management
- Row
5: Marketing | Campaigns | Research | Branding
- Save
the Document
- Go
to File > Save or press Ctrl + S to save all changes.
"Assignment 3: Formatting a Report Table" in MS
Word.
Steps
- Open
a New Document
- Open
Microsoft Word.
- Go
to File > New and select a blank document.
- Save
it immediately as Formatted_Report_Table.docx.
- Go
to File > Save As, choose a location, name the file Formatted_Report_Table.docx,
and click Save.
- Insert
a Table with 5 Columns and 6 Rows
- Go
to the Insert tab on the ribbon.
- Click
on Table and select a 5x6 table by highlighting 5 columns and 6 rows, or
use the Insert Table option.
- Label
the Columns
- In
the first row (header row) of the table, enter the column headers:
- Date
in the first cell.
- Task
in the second cell.
- Assigned
To in the third cell.
- Status
in the fourth cell.
- Completion
Date in the fifth cell.
- Enter
Sample Data
- Enter relevant sample data in the remaining rows
- Example:
- Row
2: 10/25/2024 | Design Phase | John Doe | In Progress | 11/05/2024
- Row
3: 10/27/2024 | Prototype | Jane Smith | Not Started | 11/12/2024
- Row
4: 10/30/2024 | Testing | David Lee | Pending | 11/20/2024
- Row
5: 11/02/2024 | Deployment | Alice Kim | In Progress | 11/25/2024
- Row
6: 11/04/2024 | Feedback Review | Team | Pending | 11/30/2024
- Apply
Borders to All Cells
- Select
the entire table by clicking the cross icon at the top-left corner of the
table.
- Go
to the Table Design tab under Table Tools.
- In
the Borders group, click on Borders and select All Borders to
apply borders to every cell.
- Apply
Shading to the Header Row
- Select
the first row (header row).
- In
the Table Design tab under Table Tools, click on Shading in the Table
Styles group.
- Choose
a shading color, such as light gray, to apply a background color to the
header row.
- Adjust
Column Widths
- Hover
over the right border of any column header until the resize cursor
appears.
- Click
and drag to adjust each column width as needed for clear display of all
text.
- Adjust
based on the content, making sure the Date and Completion Date columns
are narrower than Task and Assigned To.
- Align
Text within Cells
- Select
the entire table.
- Go
to the Layout tab under Table Tools.
- In
the Alignment group, choose Center alignment for the text to
ensure all content is centered within each cell. Alternatively, adjust
the alignment individually as needed for different columns.
- Save
the Document
- Go
to File > Save or press Ctrl + S to save all changes.
"Assignment 4: Creating a Business Data Table with
Advanced Formatting" in MS Word.
Steps
- Open
a New Document
- Open
Microsoft Word.
- Go
to File > New and select a blank document.
- Save
it immediately as Business_Data_Table.docx.
- Go
to File > Save As, choose a location, name the file Business_Data_Table.docx,
and click Save.
- Create
a Table with 6 Columns and 7 Rows
- Go
to the Insert tab on the ribbon.
- Click
on Table and select a 6x7 table by highlighting 6 columns and 7 rows, or
use the Insert Table option.
- Label
the Columns
- In
the first row (header row) of the table, enter the column headers:
- Month
in the first cell.
- Revenue
in the second cell.
- Expenses
in the third cell.
- Profit
in the fourth cell.
- Growth
(%) in the fifth cell.
- Comments
in the sixth cell.
- Enter
Sample Data
- Enter relevant sample data in the remaining rows.
- Example:
- Row
2: January | $10,000 | $7,000 | $3,000 | 5% | Stable
- Row
3: February | $12,000 | $8,000 | $4,000 | 8% | Increase
- Row
4: March | $15,000 | $10,000 | $5,000 | 10% | Good
- Row
5: April | $14,000 | $9,000 | $5,000 | 0% | Stable
- Row
6: May | $16,000 | $11,000 | $5,000 | 4% | Improved
- Row
7: June | $18,000 | $12,000 | $6,000 | 7% | Growing
- Apply
Custom Borders
- Select
the entire table by clicking the cross icon at the top-left corner of the
table.
- Go
to the Table Design tab under Table Tools.
- In
the Borders group, click on Borders and choose Borders and Shading.
- In
the dialog box:
- Set
the Style, Color, and Width options to create a custom border.
- Apply
Outside Borders for a thicker outline and Inside Borders
for thinner lines within the table.
- Apply
Shading
- Select
the first row (header row) to apply shading to the headers.
- Go
to the Table Design tab under Table Tools.
- Click
on Shading in the Table Styles group and choose a color (e.g., light gray
or blue) to highlight the header row.
- Optionally,
apply lighter shading to alternate rows to make data more readable.
- Select
each row, go to Shading, and choose a lighter color to alternate with
the default background.
- Apply
a Table Style
- With
the table selected, go to the Table Design tab under Table Tools.
- In
the Table Styles group, click on the drop-down arrow to display more
styles.
- Choose
a style that enhances the table, keeping readability in mind. For
example, choose a style with clear borders and header shading.
- Adjust
Cell Sizes
- Adjust
column widths to fit the content appropriately.
- Hover
over the right border of any column header until the resize cursor
appears.
- Drag
to adjust the width of each column based on the data (e.g., make the Month
and Comments columns wider).
- Adjust
row heights if necessary by selecting rows and using the Row Height
option in the Layout tab.
- Align
Text within Cells
- Select
the entire table.
- Go
to the Layout tab under Table Tools.
- In
the Alignment group, choose the appropriate text alignment for each
column. Here’s a suggestion:
- Center
the text in Month, Growth (%), and Comments columns.
- Right-align
the text in Revenue, Expenses, and Profit columns for better
readability.
- Save
the Document
- Go
to File > Save or press Ctrl + S to save all changes.
"Assignment 5: Multi-Section Report Table" in MS
Word.
Steps:
- Open
a New Document
- Open
Microsoft Word.
- Go
to File > New and select a blank document.
- Save
it immediately as Multi_Section_Report_Table.docx.
- Go
to File > Save As, choose a location, name the file Multi_Section_Report_Table.docx,
and click Save.
- Create
a Table with 8 Columns and 10 Rows
- Go
to the Insert tab on the ribbon.
- Click
on Table and select an 8x10 table by highlighting 8 columns and 10 rows,
or use the Insert Table option.
- Add
Sections with Merged Cells for Titles
- In
the first row, merge the first 8 cells to create a title row:
- Select
the first row, right-click, and choose Merge Cells.
- Type
Quarterly Sales Report in the merged cell.
- Center
the title text:
- With
the merged cell selected, go to the Home tab and click on the Center
alignment button.
- Change
the font size and style as desired (e.g., make it bold and increase the
font size to 14 pt).
- Insert
Sub-sections with Detailed Data
- In
the second row, enter the sub-section headers:
- Region
in cell 1.
- Product
in cell 2.
- Sales
Target in cell 3.
- Actual
Sales in cell 4.
- Variance
in cell 5.
- Percentage
Achieved in cell 6.
- Leave
cells 7 and 8 blank for future data or additional notes.
- Enter sample data in the following rows (3 to 10).
- Example:
- Row
3: North | Product A | $50,000 | $55,000 | $5,000 | 110% | Notes | ``
- Row
4: South | Product B | $40,000 | $38,000 | -$2,000 | 95% | Notes | ``
- Row
5: East | Product C | $30,000 | $28,000 | -$2,000 | 93% | Notes | ``
- Row
6: West | Product D | $60,000 | $65,000 | $5,000 | 108% | Notes | ``
- (Continue
with Rows 7-10 with similar data for additional regions and products.)
- Format
the Table with Different Border Styles
- Select
the entire table by clicking the cross icon at the top-left corner.
- Go
to the Table Design tab under Table Tools.
- In
the Borders group, click on Borders and select Borders and Shading.
- In
the dialog box, set different border styles for different sections:
- Use
a thick border for the title row and sub-section headers.
- Use
a thin border for the rest of the table.
- Ensure
all borders are applied where needed.
- Apply
Shading
- Select
the title row and apply a background color.
- Go
to the Table Design tab, click on Shading, and choose a color (e.g.,
dark blue).
- Change
the font color to white for better contrast (select the text, go to the Home
tab, and select white from the font color dropdown).
- For
the sub-section header row, apply a lighter shade (e.g., light gray) for
clarity.
- Align
Text Appropriately
- Select
the entire table and go to the Layout tab under Table Tools.
- In
the Alignment group, choose the following alignment options:
- Center
for headers (Region, Product, etc.).
- Right-align
the numeric data in columns (Sales Target, Actual Sales, Variance,
Percentage Achieved).
- Apply
Different Table Styles for Various Sections
- While
the table is selected, go to the Table Design tab.
- Click
on the table styles dropdown to select a style for the main table.
- For
any sub-section headers or rows, consider using a different style or
simply adjusting the shading to distinguish them from regular data rows.
- Save
the Document
- Go
to File > Save or press Ctrl + S to save all changes.
Assignment 6: Financial Data Table with Conditional
Formatting in Microsoft Word.
Steps
- Open
a New Document
- Open
Microsoft Word.
- Go
to File > New and select a blank document.
- Save
it immediately as Financial_Data_Table.docx.
- Go
to File > Save As, choose a location, name the file Financial_Data_Table.docx,
and click Save.
- Create
a Table with 5 Columns and 8 Rows
- Go
to the Insert tab on the ribbon.
- Click
on Table and select a 5x8 table by highlighting 5 columns and 8 rows, or
use the Insert Table option.
- Label
the Columns
- In
the first row, enter the following headers:
- Quarter
in cell 1.
- Revenue
in cell 2.
- Expenses
in cell 3.
- Net
Profit in cell 4.
- Profit
Margin in cell 5.
- Enter
Sample Financial Data
- In rows 2 to 8, enter the sample financial data.
- Example:
- Row
2: Q1 | $100,000 | $60,000 | $40,000 | 40%
- Row
3: Q2 | $120,000 | $70,000 | $50,000 | 41.67%
- Row
4: Q3 | $110,000 | $80,000 | $30,000 | 27.27%
- Row
5: Q4 | $130,000 | $90,000 | $40,000 | 30.77%
- Row
6: Q1 | $140,000 | $95,000 | $45,000 | 32.14%
- Row
7: Q2 | $150,000 | $100,000 | $50,000 | 33.33%
- Row
8: Q3 | $125,000 | $120,000 | $5,000 | 4%
- Apply
Conditional Formatting
- Unfortunately,
Word does not have built-in conditional formatting like Excel, but you
can visually highlight cells manually based on criteria:
- For
this task, let's say we want to highlight Net Profit cells that
are below $30,000.
- Select
the cells in the Net Profit column (from row 2 to row 8).
- Right-click
and select Borders and Shading or simply use the Shading
option to apply a light red fill for any cells that contain values below
$30,000.
- For
example, highlight the cell in Row 4 and Row 8 with light red shading.
- Use
Shading and Border Styles to Emphasize Key Figures
- To
emphasize key figures, you might want to shade the header row:
- Select
the first row, go to the Table Design tab, click on Shading, and choose
a color (e.g., dark blue).
- Change
the font color to white for better contrast (select the text, go to the Home
tab, and select white from the font color dropdown).
- For
the Net Profit column, select the cells and apply bold formatting
for emphasis.
- Add
borders to the table:
- Select
the entire table, go to the Table Design tab, click on Borders, and
select All Borders to ensure all cells have a border.
- Adjust
Column Widths
- Adjust
the widths of the columns to ensure that the data is well-presented and
readable.
- You
can do this by hovering over the column borders until you see a
double-sided arrow, then clicking and dragging to resize.
- Save
the Document
- Go
to File > Save or press Ctrl + S to save all changes.
Assignment 7: Create a Financial Comparison Table with Proper Formatting
Objective:
Learn how to create and format a detailed financial comparison table to effectively present and analyze financial data.
Instructions:
- Open a New Document:
- Launch MS Word and create a new blank document.
- Save the document as Financial_Comparison_Table_Exercise.docx.
- Create the Table:
- Insert a Table:
- Place your cursor where you want the table to appear.
- Go to the Insert tab on the Ribbon.
- Click on the Table button in the Tables group.
- Hover over the grid to select 6 columns and 5 rows, then click to insert the table.
- Label the Table Columns and Rows:
- Header Row:
- Column 1: Item
- Column 2: Quarter 1
- Column 3: Quarter 2
- Column 4: Quarter 3
- Column 5: Quarter 4
- Column 6: Annual Total
- Example Rows:
- Row 1: Revenue
- Row 2: Expenses
- Row 3: Net Profit
- Row 4: Growth Rate (%)
- Enter Sample Data:
- Fill in the table with sample financial data. For example:
| Item | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Annual Total |
|--------------|-----------|-----------|-----------|-----------|--------------|
| Revenue | $10,000 | $12,000 | $15,000 | $14,000 | $51,000 |
| Expenses | $5,000 | $6,000 | $7,000 | $6,500 | $24,500 |
| Net Profit | $5,000 | $6,000 | $8,000 | $7,500 | $26,500 |
| Growth Rate (%) | 5% | 7% | 8% | 6% | - |
- Format the Table:
- Borders and Shading:
- Click anywhere inside the table to select it.
- Go to the Table Tools Design tab.
- In the Borders group, choose All Borders to apply borders to every cell.
- Apply shading to the header row:
- Select the header row.
- Click on the Shading button in the Table Tools Design tab.
- Choose a color to differentiate the header from the data rows.
- Cell Alignment:
- Select the entire table or specific cells where you want to adjust alignment.
- Go to the Table Tools Layout tab.
- In the Alignment group, set the alignment to Center for numbers and Left for text.
- Number Formatting:
- Select the cells containing numerical data.
- Right-click and choose Format Cells.
- Choose Currency or Number format as needed.
- Adjust Column Widths and Row Heights:
- Position the cursor on the border of a column or row.
- Drag the border to adjust the width or height to fit the content.
- Add a Table Title:
- Above the table, type a title such as "Financial Comparison Table for Fiscal Year 2024."
- Center the title and apply Heading 1 style for emphasis.
- Proofread and Finalize:
- Review the table to ensure all data is entered correctly and formatting is consistent.
- Check for any alignment or spacing issues and adjust as needed.
- Save and Submit:
- Save the document again to ensure your formatting and data are preserved.
- Submit the file as directed by your instructor or as required.
Expected Outcome:
By completing this exercise, you will be able to create a well-formatted financial comparison table that presents data clearly and professionally. This skill is crucial for effectively communicating financial information in reports and business documents.
