DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Up & Down
|
|
|
Left to Right
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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.
Detailed explanation-2: -Move or copy rows or columns Hold down OPTION and drag the rows or columns to another location. Hold down SHIFT and drag your row or column between existing rows or columns. Excel makes space for the new row or column.
Detailed explanation-3: -Key Difference between Rows and Column Rows go across from left to right. On the other hand, Columns are arranged from up to down.
Detailed explanation-4: -In a spreadsheet, rows run horizontally from left to right while columns run vertically from top to bottom.
Detailed explanation-5: -Rows are a group of cells arranged horizontally to provide uniformity. Columns are a group of cells aligned vertically, and they run from top to bottom.