DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Letters
|
|
|
Numbers
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A text string that describes a column of data associated with a buffer-field. Data type: CHARACTER. Access: Readable/Writeable. Applies to: Buffer-field object handle.
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: -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-4: -The Column Headings aka Column Labels are the ones that you can see at the top of your worksheet columns as A, B, and C. You can use this to address a Cell or Cells in combination with the Row Headings aka Row Labels (1, 2, 3…). See the image to understand what is Column Heading or Column Label.