MS Excel: “Learn how to create a table in MS Excel”

0
11

MS Excel: “Learn how to create a table in MS Excel”

Tables :-  In Msword, whenever we have to write data in tabular form. Use tables. This gives data rows & column.The commands related to formatting its data are found. They are as follows.

Insert Table :-  From this option, create a table in the document. When you select this, a dialog box opens. Which includes the number of rows & column.By selecting or input the ok button, where the cursor is, the table is created on the right side. Its a dialog box looks like this.

Insert Row :- This adds a new row to the table.

Insert-Column: – It adds a new column to the table.
Delete-Table: – Removes it from the seleted table document.
Delete-Rows: – This removes the selected row from the table.
Delete-Column: – This option is deleted from the slected column table.
Select-Table: – The table is selected by this.
Select-Row: – With that, the column gets selected in the table. Wherever the cursor happens
Merge-Cells: – With the help of two or two.

Split Cell: – With the help of this commond, two or more cells are made in a cell.
Split Table: – This table is divided into several parts. Wherever the cursor happens Wah is broken into two parts.
Table Autoformat: – The table is formatted through this option. When you select it, there is a dialog box display. Where some pre-built formats are shown. Selects the format of the table that changes into that format. This is sel.

Convert: – This option is converted to selected table in text or in table text.
Sort: – This operation is arranged in ascending order / descending order.
Formula: – Some formula (formula) is available for calculating the row wise / column wise or cell wise data in the table with this option. Using which we can calculate. Its dialog box is like this.

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.