Your teacher asked you to create a table of students in Excel, doing different activities in the school. While making the table, you have forgotten to add an important row in the table. Now you want to insert the row, without disturbing the whole table. By which option will you do so?
Answers
Answer:
Adding tables to an Excel worksheet makes it super easy to add and remove data, rows and columns. I would say this is likely one of the biggest advantages to using a table. When you create a table, formatting, such as shading and borders, is automatically added as well. When deleting or inserting rows and columns, the table element keeps the formatting intact. For example, if you add data to the first empty row below the table, Excel automatically extends the formatting to the new row.
We will look at a couple examples in this lesson and learn how to add and remove data, insert and delete rows and columns and resize tables.
The steps shown below can be used to insert a row into an Excel table without actually affecting or disturbing the entire table:
1) The very first step is to Select which row you want to place the new row into.
2) From the context menu, right-click on the selected row and select "Insert."
3) And Finally, the selected row will be followed by a new row, and the preceding rows will be lowered.
By inserting a row in this manner, the table's formatting and formulas are kept, and the new row is automatically formatted to match the table's formatting. This makes sure that the table's integrity is upheld and allows you to add the crucial data without changing the remainder of the database.
For more such questions:-
https://brainly.in/question/31443142
#SPJ3