“A TABLE IS A SET OF RELATED DATA [ FIGURES(DATA) AND DETAILS] PRESENTED IN A SYSTEMATIC WAY AS ROWS AND COLUMNS”.
When we give the facts and figures in text or lengthy lines, it is always difficult to extract the information and we need to read the complete paragraph. It was when the need of table arose. The table contains only the important figures and no theory. The benefit of tables are the ease of data crunching. We can have a look at the table and get the useful data at once.
There are 50 students in Class A , 55 in Class B, 40 in Class C
In the table , we’ll just show
Number of Students
Class A 50
Class B 55
Class C 40
It is clearly visible that the way 2, which is via the use of tabular form, the information grasping is better, clear and fast. So it is very important to be able to create tables in GOOGLE SHEETS and use them effectively.
ALTHOUGH THE GRID ITSELF ACTS AS A TABLE BUT EVEN THEN THERE ARE MANY ADDITIONAL FUNCTIONS WHICH CAN BE USED IN MANY FRUITFUL WAYS IN A TABLE.
THE ARTICLE DISCUSSES HOW TO CREATE GOOGLE SHEETS.
THERE IS NO DIRECT OPTION FOR CREATING TABLE IN GOOGLE SHEETS. BUT WE CAN CREATE A TABLE BY INDIVIDUAL OPTIONS AND MAKING THEM VISUALLY IMPRESSIVE.
STEPS TO ENTER THE TABULAR DATA
For the example, let us create a table with the student details. [ Name, Id no. Batch, Age ]
The data is shown below.
It is always advisable to make the headers bold, so that they are highlighted.
Follow the steps to make the headers bold in google sheets.
To make the table still more beautiful and readable, we can put alternating colors to the table.
ALTERNATING COLORS PUT THE COLORS IN THE TABLE IN AN ALTERNATING FASHION IN WHICH ONE ROW IS FILLED WITH A COLOR AND NEXT ROW IS FILLED WITH OTHER COLOR. THE SEQUENCE IS REPEATED TILL THE END.
Follow the steps to use alternating colors in tables in google sheets.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE