DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Spreadsheet
|
|
columns
|
|
Rows
|
|
Commands
|
Detailed explanation-1: -A column is a group of cells that runs vertically from top to bottom. Columns are identified by letters. Column C is selected in this example.
Detailed explanation-2: -A column is a vertical line of cells, whereas a row is a horizontal line of cells.
Detailed explanation-3: -Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5.
Detailed explanation-4: -The key difference between columns and rows is that a column arranges data vertically from top to bottom, while a row arranges data horizontally from left to right.