DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Numbers
|
|
|
Letters
|
|
|
Roman Numerals
|
|
|
Numbers and Letters
|
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. To refer to a cell, type the column letter followed by the row number.
Detailed explanation-2: -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.
Detailed explanation-3: -Column headings, row numbers and cell addresses The Column header bar identifies each column with a letter of the alphabet. Down the left side of the screen is the Row number bar, which identifies each row with a number. The intersection of a column and a row is known as a cell.
Detailed explanation-4: -Rows run horizontally across the worksheet ranging from 1 to 1048576. A row is identified by the number on the left side of the row, from where the row originates.