DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Number
|
|
|
Letter
|
|
|
Symbol
|
|
|
None of the above
|
Detailed explanation-1: -Columns are denoted and identified by a unique alphabetical header letter, which is located at the top of the worksheet. Column headers range from A-XFD, as Excel spreadsheets can have 16, 384 columns in total.
Detailed explanation-2: -Understanding cells Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5.
Detailed explanation-3: -Each row is identified by a number. For example, the first row has an index 1, the second – 2 and the last – 1048576. Similarly, a column is a group of cells that are vertically stacked and appear on the same vertical line. Columns in RadSpreadProcessing are identified by a letter or a combination of letters.
Detailed explanation-4: -A cell range is specified in a spreadsheet by the reference of the upper left cell (minimum value) and the reference of the lower right cell (highest value). The excel range notation A1:D6 denotes from upper left cell A1 to bottom right cell D6.