DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A, B, C, etc
|
|
|
1, 2, 3 etc
|
|
|
A1, A2, etc
|
|
|
$A$1, $A$2, etc.
|
Detailed explanation-1: -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.
Detailed explanation-2: -Columns in Spreadsheet are labelled by letters of alphabet. The cell address in excel is the combination of rows and column number like A1, C5, B15 etc.
Detailed explanation-3: -In Microsoft Excel, columns are labelled as A, B, C, D, E and more. Was this answer helpful?
Detailed explanation-4: -A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3).
Detailed explanation-5: -Go to the Table tab on the Ribbon. In the Table Style Options group, select the Header Row check box to hide or display the table headers.