USING MICROSOFT EXCEL
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: -Drag the rows or columns to another location. 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: -Rows go across, i.e. from left to right. On the contrary, Columns are arranged from up to down.
Detailed explanation-4: -Try to swap adjacent rows or columns To do this, click on the first cell in the row or column that you’d like to swap, and then hold the mouse down while you drag the cursor across or down the row or column to select a range of cells. Doing this causes a green box to appear around the cells you’ve selected.