USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Numbers
|
|
Letters
|
|
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. To refer to a cell, type the column letter followed by the row number.
Detailed explanation-2: -Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3).
Detailed explanation-3: -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-4: -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-5: -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. Clear the Use R1C1 reference style check box.