WORKING
WITH TABLES
OBJECTIVES
: At the end of the lesson, we should be
able to: Click icon to add picture
1. Define a table
2. Insert and format a table
3. Explain the importance of orderliness
2
TABLE
A table is a collection of cells arranged in columns and rows. It is used to
organize text or data.
For instance, we can use a table for our class schedule or class list. Let us
see this example to be familiar with the parts of a table.
SPORTS SCHEDULE
Monday Wednesday Friday
Basketball Biking Tennis
“
PARTS OF A TABLE
”
TABLE HEADER
It contains the title of the table. In the example. “Sports
Schedule” is the table header. There are actually three (3)
cells merged together in the table header.
SPORTS
SCHEDULE
Monday Wednesday Friday
Basketball Biking Tennis
CELL
It is the smallest unit on a table. In the example, the days
and activities are placed in each cell.
SPORTS SCHEDULE
Monday Wednesday Friday
Basketball Biking Tennis
COLUMNS
These are the vertical series of cells in a table. In the
example, there are three (3) columns. Each column
pertains to a day and a sports activity.
SPORTS SCHEDULE
Monday Wednesday Friday
Basketball Biking Tennis
ROWS
These are the horizontal series of cells in a table. In the example,
there are three (3) rows. The first row has the table header, the
second row has the days, and the last row has the sports
activities.
SPORTS SCHEDULE
Monday Wednesday Friday
Basketball Biking Tennis
“ CREATE A TABLE
”
Let us create an example for our sports schedule.
To add a new table, we do the following steps:
1. Choose the Table button in the tables
group on the insert ribbon.
2. Specify the number of columns and rows
hovering the mouse on the tiny boxes, then
press click.
In the example on the right, 3x2 Table means
three (3) columns and two (2) rows.
“ ROWS AND
COLUMNS
”
As we work, we might need to add or remove a row or a column on
our table.
In the example below, the cursor is in “Monday” that is in the second
row. We can add another row below it.
Monday Wednesday Friday
To add a row, we do the following steps:
1. Click the row
2. Then, do any of these:
a. Right-click the table. Click insert, and choose Insert Rows
Below the table.
b. Right-click, go to mini toolbar. Click insert, and choose Insert
Below.
c. Go to the Rows & Columns group on the Table Tools Layout
ribbon, and click Insert Below.
d. Move the mouse over the farthest column for the insert
indicator to appear, and click it.
To add a row above or another column, or to delete them, we also do
the same steps and choose the correct option.
To also change the column width and row height, we click the
resizing handle at the bottom right.
“ SORT A TABLE
”
Sorting the content of our table is to arrange them in ascending or
descending order. To sort the following sports in the third and fourth
row, we select rows three or four, and do the next steps.
Monday Wednesday Friday
Swimming Hiking Tennis
Basketball Biking Volleyball
1. Click the Sort button in the Data group on the Table Tools Layout
ribbon.
2. The Sort window opens. Choose the columns to sort and specify
the order either by ascending or descending.
Ascending order starts from A to Z, while descending order starts
from Z to A.
3. Once Done, click
OK.
Here is the output:
“
MERGE AND SPLIT
CELLS
”
To create a table header, we have to combine or merge the cells. To
do so, we do these steps:
1. Select the cells and right-click them.
2. Then, do any of the next steps:
a. Choose Merge Cells. b. Click Merge Cells button from
the
Merge group on the Table
Tools
Layout ribbon.
Here is an
output:
To split cells or table, we
click the split Cells or Split
Table buttons.
“ STYLES AND
ALIGNMENTS
”
Tables should not be boring. We can add styles and change its text
alignment. To do so, we do the following steps:
1. Select the table by clicking the tiny box at the top left.
2. Choose our desired style from the Table Styles on the Table Tools
Design Contextual ribbon.
By clicking the More button, we can see more types of table style.
The three (3) types of table style are: plain, grid, and list tables.
To set the text alignment, we choose the alignment in the Alignment
group Here is a sample output:
“ SHADING AND
BORDERS
”
Customizing our table is possible by using borders and shading. To
do so, we use the buttons in the Table Styles (Shading button ) and in
the Borders groups on the Table Tools Design Contextual ribbon.
This process will become simple once that we get used to these tools.
“
POSITION A TABLE
”
Arranging our table together with the other content on our document
can be done by clicking and dragging the tiny box at the top left to
move our table.
“ ACTIVITY
”
CREATE A BUDGET
ALLOWANCE
Phil is a Grade 7 student who wants to save his allowance for Christmas.
His daily allowance is PHP 250. Create a table for him to budget his
allowance.
1. Create a 6x7 table.
2. The first row is merged and contains the week date.
3. The first cells in the second and third rows are merged.
4. The second row contains the weekdays in bold and is aligned at the
center.
5. The third row contains the daily allowance at PHP 250 and in bold.
6. The first column (from fourth to seventh row) has the list of expenses
and savings: Transportation, Recess, Lunch, and Savings. They are in
CREATE A BUDGET
ALLOWANCE
7. The last row (First to fifth columns) is merged and has the
text, TOTAL SAVINGS in bold and aligned right.
8. The remaining cells have the detailed amount of expenses
and savings. They are aligned at the center.
9. Save your work.
[Link] the File name format and saving location.
Sample File Name: CANEDABGD7
Saving Location: DESKTOP
CREATE A BUDGET
ALLOWANCE
HERE IS THE SAMPLE OUTPUT:
Monday Tuesday Wednesda Thursda Frida
y y y
250 250 250 250 250
Transportati 75 55 45 65 75
on
Recess 45 50 65 50 50
Lunch 85 100 90 85 85
Savings 45 45 50 50 40
TOTAL SAVINGS 230
PERSONAL PROFILE
NAME: KASHIECA FAITH CORSANES SO
ADDRESS: BRGY. 1 NAZARENO ST. JARO, LEYTE
BIRTHDATE: FEBRUARY 06, AGE: 17
2006
HOBBIES FAVORITE FOOD FAVORITE COLOR
1. VOLLEYBALL 1. FRIED CHICKEN 1.
2. BADMINTON 2. GRAPES 2.
3. 3. 3.
4. 4. 4.
5. 5. 5.
36 Presentation title 20XX
WEEKLY ACTIVITY PLAN
NAME:
ADDRESS:
WEDNESD THURSDA
TIME MONDAY TUESDAY FRIDAY
AY Y
37 Presentation title 20XX