☰ Contents · Computing

Operations on tables

Lessons 13 · 1 lessons · B. Boltayev, M. Mahkamov, A. Azamatov, S. Rahmonqulova. Informatics and Information Technology Grade 6. “O‘zbekiston” publishing house, 2017
13

Operations on tables

Textbook: pp. 61–64
GoalAdd and delete rows and columns, merge and split cells, and change the text direction inside a cell.
New words
merge cells · kataklarni birlashtirishsplit cells · kataklarni bo‘lishtext direction · matn yo‘nalishiinsert a column · ustun qo‘shish
Explanation

A finished table often needs changes. To add a new row or column, put the cursor in a cell next to where it should go and, in the Rows & Columns group of the Layout tab, choose Insert Above, Insert Below, Insert Left or Insert Right. To delete an extra row or column, put the cursor in it (select them if there are several) and choose Delete Rows or Delete Columns from the Delete list; the ordinary Delete key only erases the text inside the cell. To merge cells, select a rectangular block of cells and press Merge Cells; this is handy for a table title spanning several columns. To split one cell, put the cursor in it, press Split Cells and enter the number of columns and rows to create. Text in a cell can run horizontally or vertically (top to bottom or bottom to top); press the Text Direction button several times or choose it from the right-click menu. To select a row or column with the mouse, click at its left edge or on the arrow above it.

Worked examples
To write a title “Dushanba” (Monday) across 2 columns in a timetable, select the two top cells and merge them; the number of columns does not change, one cell just becomes wider.
To add a new subject to a marks table: put the cursor in the last row and press Insert Below – a blank row appears underneath.
Class activity

“Table repairers”: the teacher gives a badly built table (an extra column, an unmerged heading) and groups repair it in 5 minutes.

Practice
1
A table had 4 rows. How many does it have after adding two rows?
2
What do you do to delete a column from a table?
3
Which operation turns the 3 cells of the first row into one cell?
4
Why does the Delete key not remove a row from a table?