DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
columns begin with a column letter
|
|
|
columns begin a series of numbers.
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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.
Detailed explanation-2: -How are columns and rows labeled? All spreadsheet programs, including Microsoft Excel, rows are labeled using numbers (e.g., 1 to 1, 048, 576). All columns are labeled with letters starting with the letter A and then incrementing by a letter after the final letter Z.
Detailed explanation-3: -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-4: -If your data has equal rows and columns of worksheet data, Excel plots the rows of data on the vertical axis, and the columns of data on the horizontal axis.
Detailed explanation-5: -Select a column, and then select Transform > Rename. You can also double-click the column header. Enter the new name.