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: -Key Difference between Rows and Column Rows go across from left to right. On the other hand, Columns are arranged from up to down. In a spreadsheet such as MS Excel WPS, LibreOffice, or Google Sheets, the row heading is indicated by numbers, whereas column headings are denoted by letters.
Detailed explanation-3: -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-4: -Columns run vertically in the worksheet, and the data goes from up to down. Column A is the first column in Excel. In the example below, you can see that the whole column with header B is selected by pressing/clicking on the letter at the top.