DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
numbers
|
|
|
letters
|
|
|
colors
|
|
|
pictures
|
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: -By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65, 536). These letters and numbers are called row and column headings. To refer to a cell, type the column letter followed by the row number.
Detailed explanation-3: -Columns are vertically arranged groups of cells that run from top to bottom.
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.