BUSINESS ADMINISTRATION
BUSINESS ANALYTICS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A, B, C, etc
|
|
|
1, 2, 3 etc
|
|
|
A1, A2, etc.
|
|
|
D.$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: -In all spreadsheet programs including Microsoft Excel, rows are labeled using numbers (e.g., 1 to 1, 048, 576).
Detailed explanation-3: -Row header or Row heading is the gray-colored column located on the left side of column 1 in the worksheet, which contains the numbers (1, 2, 3, etc.) where it helps out to identify each row in the worksheet.
Detailed explanation-4: -In the modern versions of Excel there are 1, 048, 576 rows. In older versions of Excel (2003 and prior) there were 65, 536 rows.