DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
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: -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: -Explanation: Rows are labelled as numbers, Columns are labelled as alphabets.
Detailed explanation-4: -Cause: The default cell reference style (A1), which refers to columns as letters and refers to rows as numbers, was changed. Solution: Clear the R1C1 reference style selection in Excel preferences. On the Excel menu, click Preferences.